Connect to Infor Compass using JDBC Driver in ODBC Apps (e.g. Power BI, Excel, Informatica, SQL Server)

Introduction

In this blog post you will learn how to use Infor Compass JDBC driver in ODBC Apps (i.e. non-JAVA apps) such as Power BI, Excel, Informatica and many more listed here using JDBC-ODBC Bridge Driver. In other words if you like to use Infor Compass data in your App / Programming language and App doesnt support using JDBC Driver Infor Provides then this article is for you. ZappySys has created a Bridge Driver which can translate ODBC calls to JDBC making it possible to call any JDBC driver in non Java Apps (i.e. ODBC Apps) written in languages like C++ / C#  / Python etc.

So lets get started.

Requirements

In order to access API data inside your App using ODBC Driver you will need to make sure following requirements are met.
  1. Download and Install ZappySys ODBC PowerPack (This includes XML / JSON / REST API and few other drivers for SQL Server and ODBC connectivity in tools like Excel, Power BI, SSRS)

Download Infor Compass JDBC Driver and ionapi file

Check below links to download and configure Infor Compass JDBC.

  1. Download Infor Compass JDBC
  2. Extract Driver files to local folder
  3. Download and Configure *.ionapi fileInfor Compass JDBC Driver.ionapi file (Placed in same directory where JDBC driver is saved)

Setup JRE (Java Runtime)

Before we start using ZappySys JDBC Bridge Driver, we need to install JAVA Runtime (JRE) or Java Development Kit (JDK).

We recommend installing JRE8 (other JRE version(s) might work too). There are several ways to get JRE8 installer, but we recommend using any of the following ways. Skip below steps if you have JAVA Runtime already installed.

  1. JRE for OpenJDK (FREE – Recommended). Download JRE-8 for OpenJDK (Its maintained by Amazon AWS)
  2. JRE for Oracle JAVA (For cost check Oracle Licensing) Download JRE8 for Oracle JAVA

Create ODBC DSN for Infor Compass JDBC Driver

In this section you will learn how to Configure ODBC DSN. Later on, this DSN can be used to use ZappySys Driver. ODBC DSN can be stored at Machine Level (for all users) or Current User Level. In this case we are going to load data into Microsoft Excel from PostgreSQL Storage using ZappySys JDBC Bridge ODBC Driver.

 

  1. Type odbcad32.exe in your search box and launch the DSN Config utility.
  2. If you want access for yourself then stay of User DSN Tab. If you want grant access other users, then go to System DSN tab. For SQL Server Integration go to System Tab and add new System DSN rather than User DSN. Click New button.
    ZappySys ODBC Driver - Open UI
  3. From the Driver list Select ZappySys ODBC Driver. For this example, select [ZappySys JDBC Bridge Driver].
    ZappySys ODBC Driver - Create JDBC Bridge Driver

 

Configure ODBC DSN for Infor Compass Connectivity

Once you downloaded / extracted JDBC (*.jar) and *.ionapi files and saved to local disk then you can configure ZappySys JDBC Bridge Driver like below

  1. Enter JDBC Connection String as per this format
  2. Enter Driver class (Optional).
  3. Enter User ID and Password and click Test Connection
    Using Infor Compass JDBC Driver in ODBC Apps via ZappySys JDBC Bridge Driver

    Using Infor Compass JDBC Driver in ODBC Apps via ZappySys JDBC Bridge Driver

  4. Now you can go to Preview Tab and select Table from the dropdown and write query to preview data

Video Tutorial – ODBC-JDBC Bridge Driver

 

Using Infor Compass ODBC-JDBC connection in various apps (e.g. Power BI, Excel, Informatica, SQL Server)

Once you create ODBC DSN you are ready to test that in any ODBC compliant apps listed here

If you app not listed in above link, then no worries just find Option to connect to ODBC in your App and use DSN we created in earlier section.

ZappySys ODBC Drivers built using ODBC standard which is widely adopted by industry for a long time. Which mean the majority of BI Tools / Database Engines / ETL Tools already there will support native / 3rd party ODBC Drivers. Below is the small list of most popular tools / programming languages our Drivers support. If your tool / programming language doesn't appear in the below list, which means we have not documented use case but as long as your tool supports ODBC Standard, our drivers should work fine.   ZappySys ODBC Drivers for REST API, JSON, XML - Integrate with Power BI, Tableau, QlikView, QlikSense, Informatica PowerCenter, Excel, SQL Server, SSIS, SSAS, SSRS, Visual Studio / WinForm / WCF, Python, C#, VB.net, PHP. PowerShell

BI / Reporting Tools Integration

ETL Tools Integration Programming Languages Integration
 

Conclusion

In this post we saw how easy it is to use Infor Compass JDBC driver in any non-JAVA apps in few steps. Click here to download ZappySys JDBC Bridge Driver.

Posted in JDBC Bridge Driver and tagged , , , .