Skip navigation

Log In

Forgot your password?
Don’t have an account? Sign Up

Sign Up

Access our rich network of apps, trials, and services.

Start the registration process by entering your email address below.

Already have an account? Log In

OData Connector

Free 30 day trial

Posted by: Informatica Intelligent Cloud Services

Query and update data from any client or server library by using the OData protocol using Informatica iPaaS.


OData is an HTTP-based web protocol designed on RESTful principles which delivers its payload through ATOM or JSON. Different applications provide different methods of accessing, and interacting with the data model through their APIs. OData standardizes this access by providing a uniform way to expose, structure, query and manipulate this data.

The OData ecosystem consists of “producers” and “consumers”. Producers are services that expose their data using the OData protocol, while consumers are simply applications that consume the exposed data using the protocol. Some of the popular applications that expose their data using OData are SharePoint 2010, IBM WebSphere eXtreme Scale REST, Microsoft Dynamics CRM 2011, Microsoft Dynamics NAV 2013, SAP NetWeaver Gateway, SQL Server 2012, Team Foundation Server, and Windows Azure Table Storage.

Key Features

Perform Read and Insert operations on OData objects.

Support for the Equals, NotEquals, LessThan,LessThanEquals, GreaterThan, GreaterThanEquals, Startswith operators for retrieving data from OData objects using relevant filters.

Support for the AND conjunction between filters.


  • Requires subscription to an Informatica Cloud Integration edition.

Click below to view Objects supported


  • Informatica Cloud support options are available for paid editions of Informatica Cloud. Click here for documentation on OData Connector.

Comments Comments (0)