Compass JDBC Driver in your SQL query tool

There are multiple options when setting up the Compass JDBC driver with a query tool.

Use the instructions to set up a driver and a connection through your SQL query tool. Note that the class path for the driver includes these references:

  • A reference to the driver file
  • A reference to the folder in which the ionapi file is stored

The instructions are general; they are not based on a specific query tool. The setup instructions can vary depending on the query tool that you are using.

For Data Lake, three options to use the JDBC URL are available with the combination of the tenantID and how the ionapi file credentials are specified.