Page Comparison

...

1. If you haven’t installed ETL+ yet: ETL+ Deployment Instructions.

2. See Sage 100 Providex ODBC DSN Setup - Summarized for how to configure the ODBC driver.

3. Sign in (Login) to ETL+.

4. On the ETL main page, right-click Select the Sage 100 object on the Source Objects panel > .

5. Select /wiki/spaces/DS/pages/2001502390 on the Source Objects panel.

   • If

   a

   • the Microsoft SQL Server (instead of ODBC) page pops up,
     click

   the

   • Change Data Source (wrench icon

   →

   • ) > ODBC.

6. On Select the correct Providex ODBC driver listed on the /wiki/spaces/DS/pages/2001502390 page, select the correct Providex ODBC Name from the list.

   • Can’t find your ODBC? It’s likely because your Providex ODBC is 32-bit: Download the DataSelf ETL+ 32bits file from here. Then copy/paste the downloaded file into C:\Program Files\DataSelf ETL Plus. Confirm the overwrite prompt.

   • If it fails, try adding the ODBC credentials.

7. Customize the Alias as desired.

   

8. Click Connect.

9. You’ll return to the ETL page and see tables under the Sage 100 source on the left panel.

...