New sign-in method that stores the ION API file's content in the connection (no file beside the driver jar, one connection per tenant). The existing file-next-to-the-jar method no longer asks for a user name and password, which ION API sign-in does not use. Audited JDBC metadata: official HelpLinks, clear Auth labels, explicit empty defaults, and supported authentication options. 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. Use this sign-in method when you connect to more than one tenant, or when you cannot place files next to the driver.

1. Download the Compass JDBC JAR from the Infor documentation page (not Maven Central). Put it under {DownloadFolder}.
2. Download the ION API file for your tenant from Infor ION API and pick it in ION API file. It can stay anywhere; its content is saved with this connection.
3. Replace MY_DATALAKE_ID on the DSN Main UI after Finish.
4. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
5. Done. You can query from C#, Python, PowerShell, and ODBC apps.

]]> 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. The driver reads the ION API file from the folder that holds the driver jar, so that folder serves one tenant.

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.

]]>