Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Azure Synapse LInk For...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Azure Synapse LInk For Dataverse Vs (LCS)` Export to Azure Data Lake

(0) ShareShare
ReportReport
Posted on by AhsanKhawaja 10

Hi,

There seems to be two approaches for customers to get data out of Dynamics 365 F&O as per our knowledge which are

1. Azure Synapse Link for Dataverse
learn.microsoft.com/.../export-to-data-lake

2. Export to Azure Data Lake
learn.microsoft.com/.../azure-data-lake-ga-version-overview


Keeping in mind the longevity and investments from Microsoft for new functionality going forward, which option should we chose to get data out of our Dynamics 365 F&O given the choice?

Is this true that Microsoft is making investment predominantly on "Azure Synapse Link for Dataverse" instead of "Export to Azure Data Lake" and should be go to solution if we have a choice ?


Many Thanks,
Ahsan
ahsan.khawaja@abagri.com

  • Suggested answer
    Adam A Profile Picture
    Adam A 75 on at
    Azure Synapse LInk For Dataverse Vs (LCS)` Export to Azure Data Lake
    Hi,
     
    In the same position and based on this post it looks like Azure Synapse Link for Dataverse is the way to go having the "future proof" in mind. Here is a quote from the post:
     
    "The Export to Data Lake feature in finance and operations apps is being combined with Azure Synapse Link for Dataverse. We will announce deprecation of Export to Data Lake service and transition existing customers to Azure Synapse Link for Dataverse.
    If you're planning to adopt the Export to Data Lake feature in finance and operations apps, you should consider adopting Azure Synapse Link with finance and operations data support instead. We will provide guidance and tools for existing customers to transition to Azure Synapse Link for Dataverse. If you're currently using the Export to Data Lake feature in finance and operations apps, you can continue to use both services in parallel until the transition"

    One thing to keep in mind this is still quite a new feature (10.34) which I can see as a risk.

    /Adam

  • Suggested answer
    Siopold Profile Picture
    Siopold 30 on at
    RE: Azure Synapse Link For Dataverse Vs (LCS)` Export to Azure Data Lake

    HI,

    Export to Data Lake is from D365FO while Azure Synapse Link to Dataverse is taking data from Dataverse to a data lake.

    Your F&O data is not in dataverse do you mean your CE data? Unless you are moving data to dataverse from F&O.

    Export to Data Lake from F&O I consider to be a replacement for Export Entity Store to Data Lake.

    You can now take tables or  entities from F&O and use Azure Synapse Analytics to build views, join tables etc. generally curate them and prep for PowerBI consumption via Azure Synapse endpoint

    Azure Synapse Link takes data from Dataverse and allows Synapse to work on the data and PBI to consume usually in m experience CE or model driven app data over an app that you have built

    D

  • AhsanKhawaja Profile Picture
    AhsanKhawaja 10 on at
    Azure Synapse Link For Dataverse Vs (LCS)` Export to Azure Data Lake

    Hi,

    There seems to be two approaches for customers to get data out of Dynamics 365 F&O as per our knowledge which are

    1. Azure Synapse Link for Dataverse
    learn.microsoft.com/.../export-to-data-lake

    2. Export to Azure Data Lake
    learn.microsoft.com/.../azure-data-lake-ga-version-overview


    Keeping in mind the longevity and investments from Microsoft for new functionality going forward, which option should we chose to get data out of our Dynamics 365 F&O given the choice?

    Is this true that Microsoft is making investment predominantly on "Azure Synapse Link for Dataverse" instead of "Export to Azure Data Lake" and should be go to solution if we have a choice ?


    Many Thanks,
    Ahsan

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans