Connecting to TDV Server through OData
The Open Data Protocol (OData) is an open Web protocol for querying and updating data.
Connecting to TDV Server through OData varies depending on the development tool that you are using to develop your client application, but typically all you need to do is use the Service URL to establish the connection. There are no additional drivers to install.
These instructions are included as a guideline; your system and the necessary steps might vary. Refer to your development tool documentation and perform thorough testing of your system after establishing the connection between TDV Server and OData.
OData with TDV:
• Allows datasource query over HTTP.
• Returns results in XML.
• Similar to ODBC over HTTP.
• Comes for free when relational resource published in virtual database.
• Works with tables and views.
• Requires that primary key metadata is defined.
• Does not work with procedures.
To define the connection between TDV Server and OData
1. Open the Data Service in Studio.
2. Navigate to the OData configuration panel.
3. Copy the URL listed in the Service URLs section.
4. Open the development tool or file where you are developing your OData client, and paste the URL. For example, when using OData Explorer:
