Versions Compared

Old Version 47

changes.mady.by.user Cortlandt _

Saved on

compared with

New Version 48

changes.mady.by.user Cortlandt _

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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. Select the Sage 100 object on the Source Objects panel.

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

    • If the Microsoft SQL Server (instead of ODBC) page pops up,
      click Change Data Source (wrench icon) > ODBC.

  6. Select the correct Providex ODBC driver listed on the /wiki/spaces/DS/pages/2001502390 page.

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

...