Option 3 - Incorporating the security credentials in the connection string without the tenant ID
Open the SQL query tool.
Select the option to set up a new driver.
Specify a driver name, such as Compass JDBC Driver.
Specify the URL: jdbc:infordatalake://?ionApiCredentials=....
Using a URL Encoding method, URL encodes the contents of the .ionapi file.
The encoded result must start with a “%7B” representing the opening left bracket“{“ and end with “%7D” represents the closing bracket.
Take the encoded credentials and add them to the end of the URL connection string. For example: jdbc:infordatalake://?ionApiCredentials=YourEncodedCredentials
Specify com.infor.idl.jdbc.Driver as the classname.
Specify the library path to the JDBC driver
c:\compass\infor-compass-jdbc-20xx-xx.jar
Save the driver.
Set up a connection to Data Lake and select the Compass JDBC driver.