Making an OpenLink ODBC-JDBC Bridge driver connection to Infor Data Lake data store using the Compass JDBC Driver

[hwilliams]

Making an OpenLink ODBC-JDBC Bridge driver connection to Infor Data Lake data store using the Compass JDBC Driver

Introduction

This document details how to make an ODBC connection to Infor Data Lake data store using the OpenLink ODBC to JDBC Bridge and Compass JDBC Driver on Windows.

Prerequisites

• Download and install the OpenLink ODBC-JDBC Bridge for Windows
• Download the Infor Compass JDBC Driver (infor-compass-jdbc-2020-09.jar as of writing)
• Obtain and place the Infor ionapi security authentication file in the same location as the Infor Compass JDBC Driver
• Obtain the Infor Compass JDBC Driver name (com.infor.idl.jdbc.Driver as of writing) and JDBC connect string URL ( of form jdbc:infordatalake://{Tenant ID}
• Add the Infor Compass JDBC Driver to the system Java CLASSPATH environment variable so it can be located by OpenLink ODBC to JDBC Bridge ( and other applications)

ODBC DSN Configuration

Having installed the OpenLink ODBC-JDBC Bridge for Windows , open the ODBC Data Source Administrator:

Check to ensure the OpenLink Lite for JDK 1.8 ... (8.0) drivers are installed:

Got to the System DSN tab and click the Add button:

Select the OpenLink Lite for JDK 1.8 (Unicode) (8.0) driver from the list available and click the Finish button:

The ODBC Setup Dialog for the driver is displayed where a data source Name and Description of choice can be added and click Next:

The JDBC Driver name com.infor.idl.jdbc.Driver and connection URL String for the Infor Data Lake tenant account jdbc:infordatalake://{Tenant ID}... can be entered along with login information and the Connect now to verify that all setting are correct check box selected to verify a connection can be made:

Once all required setup dialog params have been set for the DSN the Test Data Source button can be selected to validate the connection:

Test completed successfully:

Test Connection and Query

The Sample CPP Demo program shipped with the OpenLink ODBC driver can then be used to make a test connection and query data:

Select the Envirnment -> Open Connection menu item:

Choose the DSN created from the list presented:

Enter any login credentials require to make the connection:

Select the SQL -> Execute SQL menu item:

Enter the query to be executed and click the OK button to execute:

The query results are returned:

Related

• OpenLink ODBC-JDBC Bridge driver
• Installing & Using the OpenLink Lite Edition ODBC–to–JDBC Bridge Driver, on Windows
• Infor Data Lake