Need a help to import D365 FinOps data into Azure SQL using ADF or Logic App ?

Question

Hello Team,

I'm looking for a way to import D365 FinOps Data into Azure SQL (PaaS) using either ADF or Logic Apps. I had done wider search to get some guidance to achieve this, but couldn't figure out anything (there may not be such discussions so far in any forum). Requesting a help from any one of the expert here to guide me which approach is efficient and cost effective out of choosing ADF or Logic Apps. Also, help me the guidance/steps, what all are needed in order to achieve the Data import from D365 FinOps to Azure SQL.

Note: Data size is more than 1.5TB and it's growing on a daily basis. So, we need to do Full import at first and then incremental.

Many Thanks in advance.

Answer 1

Hello VisvanathanK,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

Azure Data Factory (ADF) is the best choice for your scenario due to its scalability, flexibility, and better cost management for large datasets. It supports both full and incremental data loads efficiently and that's what you need for your scenario.

On steps for Data Import from D365 FinOps to Azure SQL (using ADF), use the followings links for more details:

• To set up your Azure SQL Database as the destination for data imported from D365 FinOps- https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
• Guide on using the Dynamics 365 connector to extract data from D365 FinOps - https://learn.microsoft.com/en-us/azure/data-factory/connector-dynamics-crm-office-365
• Guidance on setting up incremental data loads using time stamps or delta queries to avoid full imports - https://learn.microsoft.com/en-us/azure/data-factory/tutorial-incremental-copy-overview

I hope this is helpful! Do not hesitate to let me know if you have any other questions.

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful.