Excel ETL Step- configuration XML file

Hello ​@habEshete 

Welcome the DocuSign Community!
 

Preparing an ETL configuration XML file for use in an Excel ETL step of a workflow typically involves defining:

• The source Excel file path

• Sheets or ranges to extract from

• Target database/table or output structure

• Column mappings and data types

• Transformation rules (if needed)

Example: 

<ETLConfig>
  <Source>
    <Type>Excel</Type>
    <FilePath>C:\Data\SalesData.xlsx</FilePath>
    <SheetName>Q1_Sales</SheetName>
    <HasHeaders>true</HasHeaders>
  </Source>

  <Target>
    <Type>Database</Type>
    <ConnectionString>Data Source=MyServer;Initial Catalog=SalesDB;Integrated Security=True;</ConnectionString>
    <TableName>Sales_Q1</TableName>
  </Target>

  <Mappings>
    <Column Source="Date" Target="SaleDate" DataType="DateTime" />
    <Column Source="Product" Target="ProductName" DataType="String" />
    <Column Source="Amount" Target="SaleAmount" DataType="Decimal" />
  </Mappings>

  <Transformations>
    <!-- Optional: Define transformation logic if needed -->
  </Transformations>
</ETLConfig>

Thanks!

👪 DocuSign Community Leaderboard Top 5 contributor
💹 Ranked #3 in the Reply Royalty category in DocuSign Community Wrapped 2024
🤝Let’s LinkedIn and roll: Pawan Gangwani - EY | LinkedIn