...
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 Warehouseis a default ETL Source with a special function.
...
| Note |
|---|
Warning – Unexpected Results Extracting Data from ExcelThe driver which that opens and reads the Excel files controls how the data is read and extracted from Excel. Warning: The driver does not pay attention to the data type assigned to the columns in Excel! This can lead to unexpected results. You may need to change the data type and re-cast the data in the Design page. |
...
ETL+ Source Types (ETL Source panel) An overview of the types of data sources ETL+ can connect to.
ETL+ Source Types Details about the various data source drivers supported by ETL+.
ETL+ Issues Importing from Excel Troubleshooting. A Microsoft driver largely determines how Excel data is extracted.
Adding a new data source to ETL+ DataSelf Training page.
...