Windows 7 64-bit
JDK 1.8 32-bit
Download and Installation
J2RE Path: C:\Program Files (x86)\Java\jdk1.8.0_161\jre
Driver Class Path: <path>/<to>/<customJDBCDriver.jar>
Driver Class Name: <Your JDBC Driver Class Name>
Connection URL: <Your JDBC Connection URL>
Do you have Custom JDBC Driver that you have built for internal purposes and now want to use it with data visualization tools like Tableau or Microsoft Power BI? As these tools use ODBC connections, you cannot directly use a JDBC driver with them. Progress DataDirect SequeLink is an API bridging solution that can help you get ODBC access for your JDBC driver or JDBC access for your ODBC driver. In this walkthrough we will demonstrate how you can get ODBC access using your JDBC driver and Progress DataDirect SequeLink.
There are two components for Progress DataDirect SequeLink, a Server component and a client component. For the scenario in this article, we will be using Server for JDBC socket and ODBC client to access your JDBC driver via ODBC connection.
For this tutorial, I will be using a Custom JDBC Driver for Stocks-AlphaVantage API, I have built using Progress DataDirect OpenAccess SDK. You can learn more about building this driver here