ODBC Connectivity to the Infor Data Lake Using the Compass JDBC Driver and OpenAccess SDK

Introduction

In this tutorial we take an existing use case documented in our tutorial ODBC-JDBC Bridge: Quick and Easy ODBC Wrapper for a JDBC Data Source and make it specific to users of the Infor Data Lake using the Compass JDBC Driver. We will show you how you can use Progress DataDirect OpenAccess SDK to create a bridge between interfaces.

Prerequisites

  1. Contact Infor to obtain the Compass JDBC driver (dated Sept/Oct 2020).  Please note the location of the infor-compass-jdbc-xxx.jar and *.ionapi security file.  The JDBC drivers uses ION API authentication.  The *.ionapi file should be in the same directory as the .jar file.
  2. Download the Progress DataDirect OpenAccess Server SDK 8.1 and ODBC client for OpenAccess from the website
  3. Install the OpenAccess Server SDK 8.1 using the installer. Keep the options or values in installer to default and complete the installation.
  4. Once you are done with installing the OpenAccess Server, you need to install ODBC client for OpenAccess – for you to be able to get ODBC access using your JDBC driver

Set Up the Infor Data Lake

  1. Download Pass JDBC sample from Progress
  2. Extract the contents of the .zip to the following directory:
    C:\Program Files\Progress\DataDirect\oaserver81\ip\oajava

    This will create:

    C:\Program Files\Progress\DataDirect\oaserver81\ip\oajava\passjdbc
  3. Start a Command Prompt as Administrator, set the environment variable CLASSPATH to include oasql.jar library from the OpenAccess installation folder.
  4. Alternatively, you can go to System Properties -> Environment Variables and set the CLASSPATH as shown below Infor1
  5. Run a Command Prompt as Administrator and navigate to 

    C:\Program Files\Progress\DataDirect\oaserver81\ip\oajava\passjdbc

  6. From the passjdbc directory, run the below command to compile the passjdbc ip code. 

    javac *.java

  7. Now, open Management Console from the start menu. You can find this under Progress DataDirect OpenAccess Server folder in start menu.
  8. In the Management Console, connect to OpenAccess SDK Agent and under the services, create a new Java Service. To do that Right click on Services folder -> New -> Service. Infor2
  9. Click Next and now enter the service name and any TCP port that you would want the service to run on. Infor3
  10. Click on Next and this will create the new service. Now open the Infor_Datalake service you have just created, go to Configuration -> Service Settings -> IP Parameters and add the below attributes

    ServiceIPModule:  oadamipjava.dll

    ServiceJVMLocation: C:\Program Files\Java\jre1.8.0_XXX\bin\server

    ServiceJVMClassPath: C:\Infor\ION\infor-compass-jdbc-2020-09.jar;C:\Program Files\Progress\DataDirect\oaserver81\ip\oajava\oasql.jar;C:\Program Files\Progress\DataDirect\oaserver81\ip;

    Note: Replace the JVM ClassPath to the Infor JDBC driver.

  11. Go to Data Source settings -> Right Click on Data Source Setting -> Select New Data Source.  Name it Infor_OA. 
  12. Expand Infor_OA and select IP Parameters.  Add the below attributes.

    DataSourceIPType: DAMIP
    DataSourceIPClass
    : oajava/passjdbc/dbpassjdbc
    DataSourceIPCustomProperties
    : JDBC_DRIVER=com.infor.idl.jdbc.Driver;JDBC_URL=jdbc:infordatalake://SERVERNAME_TST 

    Note: Remove the attribute DataSourceIPSchemaPath Infor4
  13. Go to DataSource settings -> Default -> User Security and change the DataSourceLogonMethod to Anonymous.The .ionapi file should bein the same directory as the .jar file listed above in the ServiceJVMClassPath Infor5
  14. Now right click on the Infor_DataLake service and Start “Infor_DataLake”.

Set Up OpenAccess SDK

  1. Open ODBC administrator, go to System DSN tab and click on Add to add a new configuration.
  2. Choose Progress DataDirect OpenAccess SDK 8.1 as your driver and click on finish. Infor6
  3. Fill out the details as below. Use the same port used in Step #9.Use the same Service Data Source used in Step #11 Infor7
  4. Click on Test Connect to check the configuration. The connection will attempt to authenticate with your .ionapi file and you should be able to make a successful connection.
With Progress OpenAccess SDK, you can now connect to your Infor Data Lake. Feel free to contact us if you have any questions or issues, we will be happy to assist you. 
ODBC TUTORIAL

ODBC Connectivity to the Infor Data Lake Using the Compass JDBC Driver and OpenAccess SDK

View all Tutorials

Connect any application to any data source anywhere

A product specialist will be glad to get in
touch with you