Skip to main content
Dynamics 365 Community / Forums / Finance forum / Integrate Dataverse w...
Finance forum
Suggested answer

Integrate Dataverse with F&O 365D

editSubscribe (1) ShareShare
ReportReport
Posted on by 40

Hello developers!!

Can anyone help me with how we can integrate the dataverse with F&O 365D? 

  • Hana Xue Profile Picture
    Hana Xue on at
    Integrate Dataverse with F&O 365D
    Hi,
    Based on a lot of people responding to this, if the answer below is helpful, please mark it as verified to help more people.
    Best Regards,
    Hana
  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 1,168 on at
    Integrate Dataverse with F&O 365D
    Hi, 
     
    Dataverse can be integrated with D365 FO in the below mentioned ways:
    1. Dual write in D365 FO 
        Only recommended for master data integration with D365 FO. Not recommended for heavy data lifting like General Journal transactions or Vendor transactions etc. 
        (References:  https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/dual-write/dual-write-overview)
     
    2. Azure Synapse link for FO:
         Alternative for export to data Lake, however for transactional data in our current implementation we tested this piece and its not working as expected, so the recommendation is to go with  master data or low transactional implementation tables in this
         case. This framework resides in the PowerApps environment and pushes data into virtual entities that resides in the Dataverse platform. 
     
        image
     
    Hope this helps. Happy to answer questions, if any.
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue on at
    Integrate Dataverse with F&O 365D
    Hi,
    You need to first understand your needs and confirm that you have a certain understanding of the components and functions of the Power Platform, as it may involve using tools such as Power Automate and Power Apps. There are two options. If you need to achieve real-time data synchronization, you can configure the dual write function. If you want to access data in F&O in the Dataverse without copying it, consider creating virtual entities. You can find installation and configuration details in the documentation:
    1.dual-write: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/dual-write/dual-write-overview
    2.virtual entities:https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/power-platform/virtual-entities-overview
    Best Regards,
    Hana
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 3,556 UG Leader on at
    Integrate Dataverse with F&O 365D
    Hi,
     
    I hope this can help you.
     
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • Suggested answer
    Anthony Blake Profile Picture
    Anthony Blake 749 on at
    Integrate Dataverse with F&O 365D
    Depends what your requirements are, there are multiple options. Dual Write, Virtual Entities, etc
     
    Start by checking what's available an which best fits your scenarios:

     

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans