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
- In Power BI, Connect to Other -> ODBC and you should the data source created above.
- You should now be able to connect to your data through your custom JDBC Driver.
- Here is a simple visualization I made using my custom JDBC Driver for Stocks API in Power BI.
You can use Progress DataDirect SequeLink with any JDBC driver and make it accessible as ODBC Connection for your application. Also, SequeLink supports ADO.NET and OLEDB, if you need access to these legacy technologies. Feel free to try Progress DataDirect SequeLink and let us know if you have any questions or issues.