Option 3 - Incorporating the security credentials in the connection string without the tenant ID

  1. Open the SQL query tool.
  2. Select the option to set up a new driver.
  3. Specify a driver name, such as Compass JDBC Driver.
  4. Specify the URL: jdbc:infordataplatform:datalake://?ionApiCredentials=....
    1. 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” representing the closing bracket.
    2. Take the encoded credentials and add them to the end of the URL connection string. For example: jdbc:infordataplatform:datalake://?ionApiCredentials=YourEncodedCredentials
  5. Specify com.infor.idl.jdbc.Driver as the classname.
  6. Specify the library path to the JDBC driver
    c:\compass\infor-compass-jdbc-20xx-xx.jar
  7. Save the driver.
  8. Set up a connection to Data Lake and select the Compass JDBC driver.
  9. Connect to Data Lake.