Reference

Authentication ION API file (stored in the connection)

Description

No description available [API reference]

Instructions

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 C:\ZappySys\Jdbc\Infor Data Lake.
  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.

Parameters

Parameter Required Default value Options
Name: DriverFilePaths

Label: JDBC driver file(s)

Filled by the wizard after download. Separate multiple JARs with a semicolon (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). 		YES C:\ZappySys\Jdbc\Infor Data Lake\infor-compass-jdbc.jar
Name: DataLakeId

Label: Data lake id

Infor Data Lake identifier (e.g. MY_DATALAKE_ID). 		YES MY_DATALAKE_ID
Name: ionApiCredentials

Label: ION API file

The .ionapi file downloaded from Infor ION API for this tenant. Its content is saved with the connection, so the file can stay anywhere and each connection can use a different tenant. 		YES
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. com.infor.idl.jdbc.Driver). 		com.infor.idl.jdbc.Driver