Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Integrate D365 F&O dat...
Finance forum
Suggested answer

Integrate D365 F&O data with Azure SQL database

editSubscribe (1) ShareShare
ReportReport
Posted on by CU07051604-0 35
I have a requirement to push data in the D365 to land in Azure SQL database.
 
The data is coming from data entities out of D365 Finance & operations. I was considering using the BYOD data management feature within dynamics 365 instead to schedule incremental exports from D365 to Azure DB directly. I came across some other methods online such as using Azure data factory instead to push data from Dataverse (which we have enables) to Azure DB. I also saw that the data lake storage account may be required for this.
 
Can you please suggest me the best way to accomplish this? I would like to optimize for simplicity, efficiency, and cost-efficiency. At first, it seemed to me that BYOD would be the simplest and best option, but I have seen conflicting opinions online. Please let me know what you suggest and how you would go about it.
 
Thanks in advance!
Categories:
Integrations
Data Integration
  • Suggested answer
    Sankar.R Profile Picture
    Sankar.R 62 on at
    Integrate D365 F&O data with Azure SQL database
    Both BYOD and Synapse-Link can be used. From cost perspective, its more or less similar because BYOD uses Azure SQL and Synapse-Link use Storage account and Synapse serverless SQL pool. The advantage of using Synapse-Link is sync is near-real-time and table level data can be used
     
    Please consider explore and use Azure Synapse-Link. This will export D365 tables & data entities to Azure storage account and  Synapse serverless SQL pool. Ref: Fast track TechTalk series videos: https://community.dynamics.com/blogs/post/?postid=9d78569b-b08f-ee11-8179-000d3a4fe8f7&WT.mc_id=DX-MVP-5000413
  • CU07051604-0 Profile Picture
    CU07051604-0 35 on at
    Integrate D365 F&O data with Azure SQL database
    Thanks Anthony,
     
    Would it be possible to use Azure Data Factory alone and not need Azure Synapse Link? I haven't been able to find any resources online, but I am wondering if it is possible to construct an Azure Data Factory pipeline to copy data from D365 F&O (source) and write it to Azure SQL Database (target) on an incremental update scheduled job. the goal is to insert new rows, edit ones currently there, and delete ones based on operations that occur in D365.
  • Anthony Blake Profile Picture
    Anthony Blake 862 on at
    Integrate D365 F&O data with Azure SQL database
    The main reasons for me would be on demand data vs the weaker performance of refreshing from BYOD, the table level access rather than being restricted to data entities, and then the future possibilities of synapse link once setup. It depends on your scenarios too, how many entities, data volumes, etc. If these are low BYOD might be sufficient.
  • CU07051604-0 Profile Picture
    CU07051604-0 35 on at
    Integrate D365 F&O data with Azure SQL database
    Thanks Anthony,
     
    Is there a reason I shouldn't use the BYOD feature in D365 data management? It seems a lot more simple and with no added set up or costs.
  • Suggested answer
    Anthony Blake Profile Picture
    Anthony Blake 862 on at
    Integrate D365 F&O data with Azure SQL database
    Synapse link is the new method designed for you scenario, for accessing your D365 Finance data and data warehousing:
     
     
    Once in Synapse, you have all the tools available to process your data downstream.
     
    If replaces export to data lake, see the first note here:
     
     
     

Helpful resources

Quick Links

Take the Community feedback survey!

Answer this brief 15-question survey about your Community experience…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,375 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,308 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans