Page Comparison

...

How to see he log entries from recent ETL+ processes.

1. Click Log.

...

Log page help here.

Schedule the Data Load

• 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.

Steps

1. Login to ETL+ (help here).

2. On the ETL main page, click the top-right Log icon. Log page help here.

3. Scroll down on the log page and double-check that no table load failed, and the row count matches with the Excel tables. Following is an example highlighting two tables and their loaded row count.

...

Related Pages

• /wiki/spaces/DS/pages/1998946305

  • /wiki/spaces/DS/pages/1920270337 – driver used by /wiki/spaces/DS/pages/1998946305 to open Excel files.

• ETL+ Extract, Transform and Load (ETL) 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.

• /wiki/spaces/DS/pages/1816887297 DataSelf Training page.

• ETL+ for CSV and Text Files

• /wiki/spaces/DS/pages/1920270337 – driver required to open Excel files