Using Data Factory via OData connector

[Pawel_Gorski]

I am researching options of automating Advanced Analytics queries ingestion using Azure tools. The most obvious choice would be Data Factory, however fist attempts were not successful. Do you know of any limitations or special settings required? Has any of you used Data Factory to connect to custom queries?

[Dazza]

Hi @Pawel_Gorski, 

I don't have anything to contribute to this at the moment, but very keen on exploring these options as well - hence joining the thread...

[Jake_Caddes]

Hi @Pawel_Gorski, sorry we haven't answered this question yet. I sent the post/question to the PM who owns connectors and am waiting on their response. I pinged them again this morning so hopefully we should get an answer soon.

Thanks for your patience.

[Pawel_Gorski · Accepted solution]

As usual, the answers were out there. It was about finding them 🙂 So here's quite comprehensive manual: Automate query data exports | Microsoft Docs. I hope it will help you @Dazza Our client's engineers work on enabling the application so no tangible outputs yet but now I know the requirements.

[Dazza]

Thanks @Pawel_Gorski!

[Pawel_Gorski]

There is also a similar material for connecting from Python: python automatic download flexible queries (microsoft.com)