OData is a REST-based and standardized protocol that provides access to data over the Web. You can use the OData protocol to access data services from the Cloud, including internal data sources like those available with a JDBC connection.
OASIS has standardized on
. Informatica recommends that you use version to use OData V4, and it is the default version.
Your organization can expose OData feeds on an endpoint such as:
https://[host].rt.informaticacloud.com/active-bpel/odata/[version]/[connection name]/[data source name]
For example, these two endpoints expose the
OData Version 2
OData Version 4
Data is available in Atom XML format or JSON, including support for the XML content-type.
When the OData schema is generated, note the following:
The IID fields are excluded.
The key fields are added to the OData Key definition.
The schema uses the same type as the native data type for each field.
You can enable OData in connections configured to run on Secure Agents. The Secure Agent, rather than opening a port, opens up an outbound connection to the Informatica Cloud servers through which all communication occurs. The Secure Agent then has access to any on-premises applications or data sources.
For the best practices on using the recommended version of OData, OData Version 4, along with a JDBC connector like Salesforce Connect, for example, see
If you publish an OData enabled connection to a Secure Agent, the OData URL on the
page is an Informatica Cloud URL.
You do not see a Secure Agent URL. To construct the Secure Agent URL, replace all text
in the Informatica Cloud URL with
For example, if the Informatica Cloud URL is
, the Secure Agent URL is