Modelling Data using the RESTful ODBC Driver

Modelling Data using the RESTful ODBC Driver

To model the table's column-information in the desired way, you need to first generate the schema of your data source. Add the below connection parameter in the DSN Manager of your connection wizard:    

Generating Schema Files

Under the Connection properties, edit the Generate Schema Files = OnStart


 

Add the schema location

Provide a file location for the generated schema file in the Schema connection properties, as:


 

Editing the schema file

Once you establish the connections, a schema file is generated in the above Location with the file extension .rsd. Now, open this .rsd file as shown in below example,


The highlighted above are the column names of the table 'colors'. Edit the highlighted words with the desired words and save the changes made. Note that no two attributes should have the same name. All the names of the attributes should be kept unique.


Caching 

Now, in the Other connection properties, add: cachemetadatatablecolumns=false


Adding the above property will let you reflect any changes made in the metadata each time you make any changes in the schema. After making the changes in your schema, refresh the schema and the desired changes could be now witnessed.


Special Notes

Please make sure that for every table that you would like to model, you spend your time adding this table to the URI path so that a .RSD file can be created for it. It is within this file that you can make changes to the table names.

Creating Containers within the Intelligence Reporting Connector

  1. Create the connection to the System DSN
  2. Ensure you input the username and password for the connection again
  3. Try to add a table, you should be able to see all of the tables created above. i.e. for each .rsd file, there should be a corresponding table.