{"id":9787,"date":"2022-09-13T22:04:31","date_gmt":"2022-09-13T22:04:31","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=9787"},"modified":"2025-12-11T12:34:00","modified_gmt":"2025-12-11T12:34:00","slug":"connect-infor-compass-jdbc-driver-odbc-apps-power-bi-excel-informatica-sql-server","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/connect-infor-compass-jdbc-driver-odbc-apps-power-bi-excel-informatica-sql-server\/","title":{"rendered":"Connect to Infor Compass using JDBC Driver in ODBC Apps (e.g. SQL Server, Power BI, Excel, Informatica)"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a>In this blog post you will learn how to use Infor Compass JDBC driver<\/a> in ODBC Apps (i.e. non-JAVA apps) such as Power BI, Excel, Informatica and many more listed here<\/a> using JDBC-ODBC Bridge Driver<\/a>. 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#\u00a0 \/ Python etc.<\/p>\n

So lets get started.<\/p>\n

Requirements<\/h2>\r\nIn order to access API data inside your App using ODBC Driver you will need to make sure following requirements are met.\r\n
    \r\n \t
  1. Download and Install\u00a0ZappySys ODBC PowerPack<\/a>\u00a0(This includes XML \/ JSON \/ REST API and few other drivers for SQL Server and ODBC connectivity in tools like Excel, Power BI, SSRS)<\/li>\r\n<\/ol><\/div>\n

    Download Infor Compass JDBC Driver and ionapi file<\/h2>\n

    Check below links to download and configure Infor Compass JDBC.<\/p>\n

      \n
    1. Download Infor Compass JDBC Driver (*.jar file)<\/a><\/li>\n
    2. Extract Driver<\/a> files to local folder<\/li>\n
    3. Download and Configure *.ionapi file<\/a> – Infor Compass JDBC Driver.ionapi<\/strong> file (Placed in same directory where JDBC driver is saved)<\/li>\n<\/ol>\n

      Setup JDK (Java Runtime)<\/h2>\n

      Before you start using ZappySys JDBC Bridge Driver, we need to install JAVA Runtime (JRE) or Java Development Kit (JDK).<\/p>\n

      We recommend installing JDK21 or higher<\/strong> (other JRE \/ JDK version(s) might work too).<\/p>\n

      There are several ways to get Java Runtime Installer, but we recommend from following link. Skip below steps if you have JAVA Runtime already installed.<\/p>\n

        \n
      1. Download JDK 21 (i.e. Amazon Corrento OpenJDK distribution). Listed here<\/a>
        \nDirect Download Link<\/strong>:\u00a0         amazon-corretto-21-x64-windows-jdk.msi<\/a><\/li>\n
      2. Run the downloaded msi installer file<\/li>\n
      3. After it’s installed, you can confirm Java version by running the following command line. It will show\n
        java.exe -version<\/pre>\n
        Sample Output<\/strong><\/p>\n
        openjdk version \"21.0.7\" 2025-04-15 LTS\r\nOpenJDK Runtime Environment Temurin-21.0.7+6 (build 21.0.7+6-LTS)\r\nOpenJDK 64-Bit Server VM Temurin-21.0.7+6 (build 21.0.7+6-LTS, mixed mode, sharing)<\/pre>\n<\/li>\n<\/ol>\n
         <\/p>\n
        Download Infor JDBC Driver \/ Generate ionapi Credentials File<\/h2>\n
        To access infor Data using their official JDBC Driver you will need to do 2 things<\/p>\n
          \n
        1. Download Infor JDBC Driver locally<\/li>\n
        2. Create ionapi file locally<\/li>\n<\/ol>\n
          Read this link<\/a> for more information<\/p>\n
          Here is the video Tutorial<\/p>\n
          <\/div><\/div>
          <\/div>
          <\/div>
          <\/div><\/div><\/div>