Auth Notes (numbered steps), documented params, Maven DriverDownloadLinks, extra SQL examples for ODBC apps. Initial version. Infor Compass JDBC (Data Lake) from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

1. Download the Compass JDBC JAR from the Infor documentation page (not Maven Central). Put it under {DownloadFolder}.
2. Download the ION API file (Infor Compass JDBC Driver.ionapi) and place it in the same folder. Do not rename it.
3. Replace MY_DATALAKE_ID on the DSN Main UI after Finish.
4. Optional: watch the setup video.
5. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
6. Done. You can query from C#, Python, PowerShell, and ODBC apps.

]]> Returns customer master data from the Data Lake (e.g. RCM in Infor ERP LX / BPCS). Uses infor.lastmodified() for incremental extracts in Power BI or ADF.

]]> = '2026-02-01T00:00:00.000Z']]> Returns sales order headers from ECH. Limits to the most recent 100 orders.

]]> Returns item master from IIM. Filters by load date using infor.lastmodified().

]]> = '2026-01-01T00:00:00.000Z']]> Joins ECH, ECL, and IIM for a combined sales extract. Use in a SQL Server Linked Server view or Crystal Reports.

]]> = '2026-02-01T00:00:00.000Z']]> Counts rows in RCM. Simple SSRS scalar.

]]> Returns active-looking customer rows. Replace the status literal with your catalog value.

]]> Column list instead of star. Prefer this in Linked Server views.

]]> Most recently loaded items. Useful Excel preview.

]]>