Azure Data Factory Odata- connector (Copy data tool) does not work properly with Odata service URL

Question

Azure Data Factory V2 Odata- connector (Copy data tool) does not work for connecting to Odata service url. But I use same service url and same credentials and same authentication type for Fabric Azure Data Factory dataflow gen 2 and it works like it should be.

What is the difference between Azure Data Factory V2 Odata- connector (Copy data tool) and Fabric Azure Data Factory dataflow gen 2 Odata- connector?? (Connection via selfhosted integration runtime in both cases)

Answer 1

Hello @Ville Ristilä

The main difference between the two is that Azure Data Factory V2 is a cloud-based data integration service that allows you to create, schedule, and manage data integration pipelines, while Azure Data Factory Data Flow Gen 2 is a serverless data integration service that allows you to visually design, build, and manage data transformation at scale.

Regarding the OData connector, both Azure Data Factory V2 and Azure Data Factory Data Flow Gen 2 support the OData connector, but there may be differences in the implementation of the connector between the two services.

It's possible that the OData connector in Azure Data Factory V2 may not support the specific authentication type or version of OData that you are using.

To troubleshoot the issue, I would recommend checking the version of OData that you are using and the authentication type that you have configured in Azure Data Factory V2.

You can also try using a different authentication type or version of OData to see if that resolves the issue.

I hope this helps.