Sage 100 Technical Details
In this section
Sage 100 Date Issues
ETL+ Load Replace – special uses with configuring dates from GETDATE() function.
Sage 100 Providex Dates – Transforming problematic dates in the Design page.
Providex SQL Syntax – tips for working with dates in the Extract SQL Statement panel.
ETL+ Load Replace with Date-time fields – when to use
CONVERT(DATE, GETDATE())instead ofGETDATE().
Related Pages
For Sage 100 Advanced Analytics for Sage100
Pages Linked to Sage 100
- Sage 100 Providex ODBC DSN Setup - Summarized
Internal Notes Usage: Documentation from Sage for Sage 100 “install Workstation Setup” with caps. AVOID: “install a workstation setup”
- For Sage 100
Advanced Analytic out-of-the-box templates & reports for Sage 100.
- Introduction / Overview
- Advanced Analytics for Sage 100 - Metadata
- Advanced Analytics for Sage 100: Sales
- QA for for Sage 100 Example: Accounts Receivable Invoice History Report
Example comparing report from Sage 100 with Tableau report based on DataSelf data warehouse.
- Sage 100 ProvideX SQL Examples for ETL+
Examples of Load Replace settings.
- “Source columns or/and formats of the table ... are currently not available”.
Error message when attempting to open Design page “Source columns or/and formats of the table <table name>… are currently not available”.
- Data Validation for Sage 100 Advanced Analytics (older Draft)
- Sage 100 Technical Details
ETL+ Load Replace – special uses with configuring dates from GETDATE() function. Sage 100 Providex Dates – Transforming problematic dates in the Design page. Providex SQL Syntax – tips for working with dates in the Extract SQL Statement panel. ETL+ Load Replace with Date-time fields – when to use CONVERT(DATE, GETDATE()) instead of GETDATE().
- Sage 100 Reports for QA Review
Quality Assurance – compare reports from Sage 100 to reports from Tableau based on data from DataSelf’s data warehouse.
Search: sage100, sage100 Providex, ODBC