ETL+ for MS Excel
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+ supports a number of different types of data sources and data source drivers.
An ETL Source can have one or more ETL Source Tables.
zData Warehouse
is a default ETL Source with a special function.
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
Add a New MS Excel Source
Open and Login to ETL+ for the ETL+ entity. For more see ETL+ Sign in Page.
Click Add Source > MS Excel on the ETL Source panel.
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
Select the Excel data source’s name from the ETL Source panel.
Click Properties.
Configure the Microsoft Excel page.
Microsoft Excel page
The Microsoft Excel page adds and maintains metadata about connections to ETL Sources.
Configure the fields shown below.
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:
Enter the path and file name of a local Excel file.
Select Browse to find the file.
Enter a URL address for the file on your local network or internet.
Troubleshooting – ETL+ Issues Importing from Excel