How do I publish a Tibco Data Virtualization (TDV) resource as an OData resource and access It?

How do I publish a Tibco Data Virtualization (TDV) resource as an OData resource and access It?

book

Article ID: KB0080585

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization -

Description

Introduction

This document describes the publication process in Tibco Data Virtualization (TDV) as an OData resource and the process to test that resource. OData is a web protocol used in order to query and update data. OData provides a Java Database Connectivity-like access to data and allows you to query a data source through the HTTP protocol and return results in the XML-based Atom format or JavaScript Object Notation (JSON) format.
For more details, see About the OData Feature in the TDV User Guide. 
 

Issue/Introduction

This document describes the publication process in Tibco Data Virtualization (TDV) as an OData resource and the process to test that resource.

Resolution

How do I publish a Tibco Data Virtualization (TDV) resource as an OData resource and access It?
  1. Choose the resource you want to publish.
  2. Right-click and publish the resource as a database. 
  3. Choose Add Composite Service and do not choose Add Catalog or Add Schema.
     
Note: procedures are not a supported type of resource in OData and that resources without a primary key are not supported.
  1. Follow the composite URL convention: localhost:9400/odata/<published_service_name> 
  2. Go to OData.org . Get the OData explorer URL and test the published OData resource.