#Odbc manager tutorial generator

Before going any further with the tutorial, I strongly recommend to get a bit familiar with the API which is a simple API and shouldn’t take long to understand.

I am going to be using the Alpha Vantage Time Series Data API in this tutorial and make sure that I support below functions of the Time Series Data API.In that folder create a file called TimeSeries.xml, where TimeSeries is the name of the table that I will expose through ODBC and the file holds the schema information for the Alpha Vantage endpoint. Create a new folder named schema in your project folder.First we will create schema file for the Alpha Vantage REST endpoint and then proceed to configuring input.props.Provide configuration info in input.props.Build a schema file for the API endpoint.Before you start generating template code, you need to do two things.Below is my folder structure for your reference. Move the contents of RestGenerator folder from the extracted files to the new folder that you have created above.

This will generate a new folder called ip with a structure as shown below.Extract the oa_rest_ip_generator_8_X_X.jar by running this on your command prompt:.For future references in the tutorial, I named my project folder Stocks-Alphavantage. Copy the oa_rest_ip_generator_8_X_X.jar to your workspace and create a new folder for the project.

#Odbc manager tutorial generator

To get you started with OpenAccess SDK easily with least friction, we have released a template code generator for writing your own ODBC driver called OpenAccess REST IP Generator.