Open Data Protocol (OData) is an OASIS standard that defines best practices to build and consume RESTful APIs.
You can focus on business logic and build RESTful APIs with OData instead of defining request headers, response headers, status codes, HTTP methods, URL conventions, media types, payload formats and the query options. OData guides you to track changes and define functions, or actions for reusable procedures and send asynchronous, or batch requests. Use OData for extension and to fulfill any custom needs of your RESTful APIs. OData builds on core protocols, such as HTTP and commonly recognized methodologies like REST.
OData Connector integrates Data Integration with systems, such as SharePoint, databases, SAP OData services, and Team Foundation Services. These systems are OData compliant, on-premise compliant or cloud applications compliant. OData Connector communicates with these systems in the OData protocol. OData Connector uses restful API calls to connect to an OData service. Rest calls can be in XML or JSON format. Choose the format that the OData service supports. Use OData Connector to connect to endpoints that support OData protocol version 2.
Create an OData connection to specify objects that are exposed in an OData service that you want to include in a task. You can use the OData connection in synchronization tasks, mappings, and mapping tasks.
You can configure a synchronization task using the Synchronization Task wizard. Create a synchronization task to synchronize data between a source and target. You can perform insert, update, upsert, or delete operations on OData objects.
Create a mapping task to process data based on the data flow logic defined in a mapping or integration template. You can switch mappings to advanced mode to include transformations and functions that enable advanced functionality.