This article outlines how to use Copy Activity in Azure Data Factory to copy data from an OData source. The article builds on Copy Activity in Azure Data Factory, which presents a general overview of Copy Activity.
You can copy data from an OData source to any supported sink data store. For a list of data stores that Copy Activity supports as sources and sinks, see Supported data stores and formats.
OData version 3.0 and 4.0.
Copying data by using one of the following authentications: Anonymous, Basic, Windows, AAD service principal, and managed identities for Azure resources.
The following sections provide details about properties you can use to define Data Factory entities that are specific to an OData connector.
"value": "<base64 encoded string of (.pfx) certificate data>"
"value": "<password of your certificate>"
"aadResourceId": "<AAD resource e.g. https://tenant.sharepoint.com>"
This section provides a list of properties that the OData dataset supports.
This section provides a list of properties that the OData source supports.
When you copy data from OData, the following mappings are used between OData data types and Azure Data Factory interim data types. To learn how Copy Activity maps the source schema and data type to the sink, see Schema and data type mappings.
OData complex data types (such as Object) aren't supported.