/
ETL+ for MS Excel

ETL+ for MS Excel

Owned by Cortlandt _
Last updated: Jun 25, 2024
6 min read

ETL+ reads and extracts data from Microsoft Excel XLS, XLSX, and XLSM files.

ETL Sources & ETL Source Tables

ETL Source. An ETL Source refers to the connection to a data source. Connections to Excel files are maintained in the ETL Source panel with help from the Microsoft Excel page. The screenshot below shows two ETL Sources named Excel Workbook and zData Warehouse.

ETL Source Table. A ETL Source table refers to a table that ETL+ can extract data from. In the screenshot below Sheet1$ is a ETL Source table belonging to the ETL Source named Excel Workbook.

Excel Workbook is the name of the ETL Source and Sheet1$ is a ETL Source Table in Excel Workbook.

ETL Source Panel

Buttons on the ETL Source panel.

Add a New MS Excel Source

  1. Open and Login to ETL+ for the ETL+ entity. For more see ETL+ Sign in Page.

  2. Open the ETL+ Extract, Transform and Load (ETL) Page.

  3. Click Add Source > MS Excel on the ETL Source panel.

  4. Configure the Microsoft Excel page.

Notes

  • Read the warning below about Data Type Issues and how ETL+ interprets the data in Excel columns. Recommend always checking the data from Excel with the Target Object panels’s Design page.

  • To test and verify the data extracted from the data source see the headings below.

  • https://dataself.atlassian.net/wiki/spaces/DS/pages/1816887297 Page from DataSelf Training.

  • Troubleshooting – ETL+ Issues Importing from Excel

Maintain a MS Excel Source

  1. Select the Excel data source’s name from the ETL Source panel.

  2. Click Properties.

  3. Configure the Microsoft Excel page.

Microsoft Excel page

The Microsoft Excel page adds and maintains metadata about connections to ETL Sources.

  1. Configure the fields shown below.

  2. Click Connect or Save.

Microsoft Excel Page Settings

  • Alias. A alias name will be automatically populated, but you can customize it.

  • File Path. Options are:

    1. Enter the path and file name of a local Excel file.

    2. Select Browse to find the file.

    3. Enter a URL address for the file on your local network or internet.

Troubleshooting – ETL+ Issues Importing from Excel

View Excel Sheets (Tables) Available from a Excel Data Source

Each Excel workbook shown in the