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.
The driver 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. The driver looks at the data in the first few rows in each column to determine the data type (float, integer, varchar, etc) and length of character strings the driver will use to extract and data from Excel.
Preview shows you the data in a ETL source table without (up)loading the data into the destination table in the target data warehouse. For Excel workbooks each sheet in the workbook can be a ETL source table.
On the ETL main page, click Refresh Batch (top right icon on the center panel).
Select a Refresh Batch or create a new one to load your Excel data on a schedule (help here) → on the right panel, be sure the Excel tables to load have their boxes checked and in the desired load order.
To load them now, click the Refresh Batch Now (play icon) on the left panel for the desired Refresh Batch.
To schedule the data load:
Click WTS Settings -> enter the WTS parameters → Apply.
This step might require you to run ETL+ app as “Run as administrator” in Windows.
Click Close -> Close.
After ETL+ has loaded your Excel files how to verify that the data extraction process finished successfully and number of rows extracted and loaded matches your Excel table.