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.

    • Related Articles

    • Setting up an Excel ODBC (32bit) System DSN

      Issue You would like to connect to Excel files to use as data in your Intelligence Reports Resolution You need to configure a 32bit System DSN on all workstations. Instructions as follows: Set up a System Data Source Name (DSN) using the Microsoft ...

    • Deploying CData drivers using Citrix Machine Creation Services

      Issue: You are trying to license the CData drivers as per normal, but when you are spinning out new instances, the license is not holding on the newly created machine. Symptoms: You try and Test the connection to the drivers through the ODBC Driver ...

    • Data Source name not found and no default driver specified. SQLState=IM002

      Error "Data Source name not found and no default driver specified. SQLState=IM002" when trying to run any reports Resolution Go to the Connector Find the connection the report with the error is running off Ensure the report is on the correct ...

    • Installation of MYOB Live Intelligence Reporting (ODBCLink)

      How the product works We install a few products below that all work together to make a replication of your MYOBLive database on a local installation. The product that is doing the work is called ODBCLink which connects directly to MYOB live and ...

    • Does Intelligence Reporting and CData support TLS 1.2?

      Question A recent upgrade from Microsoft has marked End of Life for TLS 1.0 and 1.1. I am using Intelligence Reporting and/or Cdata drivers selled by Alchemex and need to upgrade my servers. How will it affect my Reporting? Support for Intelligence ...