...
Click here to fill out the DataSelf Analytics Deployment Form.
Set up a Sage 100 Providex ODBC DSN. ETL+ uses ODBC to extract data from Sage 100 Providex. Set up the ODBC on the same computer where ETL+ will be installed.
...
If you haven’t installed ETL+ yet: ETL+ Deployment Instructions.
See Sage 100 Providex ODBC DSN Setup - Summarized for how to configure the ODBC driver.
Sign in (Login) to ETL+.
Select the Sage 100 object on the Source Objects panel.
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.
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.
Customize the Alias as desired.
Click Connect.
You’ll return to the ETL page and see tables under the Sage 100 source on the left panel.
...
Failure? It’s likely that the prior step wasn’t properly configured. Go back and review it.
Click the
Log
icon (top right) to view data load results. Log page help here.
Schedule the Data Load
On the ETL main page, click
Job
(top right icon on the center panel).The Job page usually comes pre-configured to your source system(s).
Overview this page’s configuration. On the right panel, feel free to uncheck tables and Tableau extracts that don’t apply to your reporting needs.
Run a Job now (optional): click the
Run Job
(play icon) on the left panel.To schedule the data load (optional):
Select a Job → Job Properties (wrench icon) → configure the schedule panel → Save
Click
Close
->Close
.
...
ETL+ must have already loaded your data manually or scheduled.
Steps
On the ETL main page, click the top-right
Log
icon. Log page help here.Scroll down on the log page and double-check that no table load failed, and the row count matches with the Sage 100 tables. Following is an example highlighting two tables and their loaded row count.
...
Sage 100 Pre-mapped Data Warehouse Tables
Sage 100 Date Issues
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
Related Pages
Sage 100 Technical Details – issues in more depth
Sage 100 Providex Dates – Adjusting date values on the ETL+ Design Page., – How to process ‘bad’ dates
Providex SQL Syntax – SQL syntax only for use on the ETL+ Extract SQL Statement Panel
Providex Documentation
Providex ODBC Syntax Functions and Data Types from http://manual.pvxplus.com
https://manual.pvxplus.com/PXPLUS/odbc/using_odbc_driver/scalar_functions.htm
...
Providex ODBC References
Reading PxPlus™ Language Reference Documentation
...
Open http://manual.pvxplus.com/
...
Select PxPlus SQL ODBC > Using the PxPlus SQL ODBC Driver
...
ETL+ Load Replace with Date-time fields – special caution for Sage 100 users.
– Guide to finding SQL documentation in this reference manual.
PxPlus Documentation – Link to the reference manual itself
SQL syntax for Sage 100
SQL syntax to use in the ETL+ Extract SQL Statement Panel
Sage 100 Database Guide
https://help-sage100.na.sage.com/2022/FLOR/index.htm#File_Layouts/File_Layouts_Overview.htm?TocPath=File%2520Layouts%257C_____0 – Sage 100 database metadata / database guide. See File Layouts tab for details on each file/table.
Search: S100, Sage100, database guide, file layouts