D365 integration with Ignition Perspective

I'm looking into different methods of accessing data from the Dynamics 365 ERP system to bring into Ignition (as well as writing back to D365 eventually). The ideal approach would handle large datasets (10k+ records) well.

I'm curious if anybody has done something similar before with Dynamics 365 - I've integrated with ERPs but usually that was through JDBC drivers and APIs, not using any of the Microsoft/Azure services. From a quick Google search, I see one approach being to pull D365 data into an Azure Data Lake and then access the ADL from Ignition.

Any feedback / guidance would be appreciated!

1 Like

I'm curious if someone as done this in the past year. We have work with a solution using a third party ETL to link the cloud to a local DB on a periodic update. But i've not been able to link directly Ignition connector to the azure service.