Do you have a custom API that you use in your company internally and would like to connect to your favorite analytics tool, or integrate with any other tool using standards based connectivity like ODBC?
Do you have a data source which has a REST API and doesn’t have a ODBC driver, but you would like to have one for your analytics or integration purposes?
If so, you're at the right place. This tutorial will get you started in building your own ODBC driver using Progress DataDirect OpenAccess SDK. In this tutorial, I will build an ODBC driver for a free financial REST API provided by the Alpha Vantage Stock API Platform, which offers real time and historical stock market data. Please refer to this stock market analysis that describes how stock API providers typically adjust historical prices based on corporate events such as splits and dividends.
Update: For a code-less solution, look at our new Autonomous REST Connector, which is designed to connect to any REST API easily. You can get started by following this tutorial.
- Open ODBC Administrator (32 bit if you have installed 32 bit OpenAccess ODBC client, else open 64-bit).
- Add New DataSource -> Choose Driver as DataDirect OpenAccess SDK 8.X and click on Finish to configure the driver as shown below.
- Configure the driver as shown below. The port number is the port that you have given when you created OpenAccess service.
- Click on Test Connect to test the connection. If your OpenAccess service is running, you should be able to connect successfully.
- Now go to Start Menu -> All Programs -> Progress DataDirect OpenAccess Client for ODBC xx_bit SDK and open Interactive SQL program.
- You should now see a terminal, enter the following command to connect to the above ODBC data source.
- You should now be able to run queries. If you have started debugging in IDE and placed breakpoints, you should be able to debug too simultaneously.
- Here are some sample queries you should be able to run, if you have used my code from GitHub.
We hope this tutorial helped you to build your own custom ODBC driver using Progress DataDirect OpenAccess SDK
. If you have any questions/issues, feel free to reach out to us, we will be happy to help you during your evaluation.