web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / BYOD/Data Lake/Synapse...
Finance | Project Operations, Human Resources, ...
Suggested answer

BYOD/Data Lake/Synapse Link which one is better

(1) ShareShare
ReportReport
Posted on by Hisham Alsayed 750
Hi All,
 
    We're currently facing challenges with BYOD, encountering issues like getting stuck and requiring multiple workarounds, including entity deletion and republishing. We're exploring more stable alternatives, such as Data Lake or Synapse Link. I'm interested in your thoughts on which one might be better suited for our needs and why, considering any deprecated options.

Thanks,
Hisham
I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 235,243 Most Valuable Professional on at
    BYOD/Data Lake/Synapse Link which one is better
    Synapse Link isn't an alternative to Data Lake. It's a way how to get data from F&O to Data Lake (among other options).
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia 4,033 Microsoft Employee on at
    BYOD/Data Lake/Synapse Link which one is better
    Hi,

    Based on your specific challenges with BYOD and the need for a more stable alternative, here's an overview of Data Lake and Synapse Link:
    Data Lake:

    • Data Lake integration in Dynamics 365 F&O allows you to store and manage large volumes of data from different sources. It provides a centralized repository for structured and unstructured data, enabling advanced analytics and reporting capabilities.
    • With Data Lake, you can leverage Azure Data Lake Storage Gen2, which offers features like limitless scalability, security, and powerful analytics.

    Synapse Link:

    • Synapse Link is designed to provide seamless and real-time analytics by connecting Dynamics 365 F&O data with Azure Synapse Analytics. It enables near real-time insights and decision-making with integrated data analytics and AI capabilities.
    • Synapse Link simplifies data warehousing and processing, offering enhanced performance and cost efficiency.

    Both options offer robust capabilities for handling and analyzing data from F&O.

    Best regards,
    Kevin
  • Hisham Alsayed Profile Picture
    Hisham Alsayed 750 on at
    BYOD/Data Lake/Synapse Link which one is better
    Thanks, but I am still having confusion a little is Data Lake and Synapse link different tool to get reporting data or Synapse link build on top of Data Lake, and it is required to enable it from LCS first. please note is getting deprecated (life till 1 Nov 2024)
  • JBLOZZA Profile Picture
    JBLOZZA 9 on at
    BYOD/Data Lake/Synapse Link which one is better
    Hello,
     
    To complete the question of the original poster, I'd like to say that the export to ADL is supposed to be deprecated in Nov 2024.

    Microsoft new solution seems to be   Synapse Link for Dataverse service built into Power Apps.
    What I fail to understand is how is it really different ? The new solution seems to be based on Azure Data Lake exports anyway (in the context of D365F&SCM).

    I guess that original poster wanted to know the difference between the 3 solutions provided by Microsoft :

    We are currently using the BYOD solution, but it has some flaws (development costs, nightly export lasts for more than 3 hours).
     
    We were supposed to migrate to the Export to Data Lake, so I'm having the same question and I wonder if the last version isn't just a renaming of the Data Lake+ forced used of Synapse.

    Thanks,
  • Suggested answer
    DanielBoston Profile Picture
    DanielBoston on at
    BYOD/Data Lake/Synapse Link which one is better
    Great question. I actually just finished a Synapse Link implementation with Goal to replace our BYOD. First thing to note. BYOD you extract Entities from D365FO. Synapse Link you are extracting tables (yes you can select entities as dataverse virtual tables, but they are slow and basically worthless if your goal is to get data from D365FO into your internal systems.) So with Synapse link you have to build the entities yourself from the raw table. Which is considerable investment in both time, infrastructure, to process all the raw data. To do that you are also going to need a Tier 1 Env to use as a reference. So yes you can replace BYOD with Synapse Link, is it easy to replace it absolutely not. Microsoft should have spent the effort to allow for the publishing of Entities to parquet file format.

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans