Hello everyone,
In this quick tutorial, we’re going to introduce a novel and simpler way to configure the Compass JDBC connector. This is a new enhancement that was introduced in the v2021-06 rollout.
In a nutshell, clients using the Compass JDBC driver to connect to the data lake are now able to forego having to use the IONAPI credentials file and simply pass this information in the connection string itself.
Let's take a look at how you can take advantage of this new feature.
Disclaimer: This tutorial is based on the official Infor OS documentation published on 2021-08-19, click here to access the latest documentation
The first step is to download the latest Compass JDBC driver from ION Desk in your tenant. You can do so by navigating to ION Desk > Configuration > Downloads > Files > Compass JDBC Driver.
Next, under Infor ION API > Authorized Apps, you’ll need to create an authorized backend services app for the JDBC driver or re-use an existing one to download the *.ionapi file containing your service account credentials.
Note: Please always contact your security or infrastructure team before creating an authorized app with credentials.
In your local SQL query tool, DBeaver in this example, proceed to create a new driver.
1. Specify the driver name, e.g., Compass JDBC Driver
2. Specify the class name: com.infor.idl.jdbc.Driver
3. Specify the library path to the JDBC driver (.jar file downloaded in the first step).
Recommended: it's best to leave the URL Template blank and define it instead on the connection side. This allows the ability to re-use the driver for different tenants.
4. Save the driver.
5. Set up a new connection to the Data Lake and select the Compass JDBC driver as your driver.
6. Specify the URL template as follows:
jdbc:infordatalake://?ionApiCredentials=<strong>Encoded_String </strong>
The Encoded_string is based on the content of the *.ionapi credentials file:
i. Open the *.ionapi file in a file editor to copy the entire contents.
ii. Recommended: If you are using Notepad++, you can simply use the built-in encoding capabilities (under MIME Tools) to avoid relying on online encoders:
Alternatively (not recommended), you may use other URL encoding services such as: https://www.url-encode-decode.com/.
iii. The result should start with a “%7B” representing the opening left bracket “{“ and end with “%7D” which is a closing bracket “}”.
iv. Copy the encoded string and paste it into the relevant section in the URL field.
7. Connect to the Infor Data Lake.
Notes:
- This feature is available to all Infor OS MT clients.
- The use of this authentication method is completely optional and does not affect any other existing methods.
Additional resources:
