Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Integrate Dataverse with F&O 365D

Posted on by 60

Hello developers!!

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

  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee 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,439 Super User 2024 Season 2 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 Microsoft Employee 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 9,439 Super User 2024 Season 2 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 2,147 Super User 2024 Season 2 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:

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,101 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,908 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans