Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Is it possible to replicate Dynamics 365 Business Central Saas to either Azure SQL or On-Prem SQL

Posted on by 25

Hi

We are planning on moving to cloud BC but we currently connect directly to our On Prem SQL backend for quite a few operations.

Is it possible to replicate the Dynamics BC Saas onto Azure SQL or On prem SQL to be able to make use of the raw data table in the same way?

Thanks

Warric

  • RE: Is it possible to replicate Dynamics 365 Business Central Saas to either Azure SQL or On-Prem SQL

    You can use the following solution microsoft/bc2adls: Exporting data from Dynamics 365 Business Central to Azure data lake storage (github.com)

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: Is it possible to replicate Dynamics 365 Business Central Saas to either Azure SQL or On-Prem SQL

    Mr Inge provided all out of the box solutions.

    The other ways is to use app such as below or services like the second link. Or vote for the Direct SQL access (third link)

    appsource.microsoft.com/.../PUBID.efoqus-5058796|AID.replicator|PAPPID.18a4d438-88d1-44ee-a38d-3c0ea0d77338

    lyftron.com/.../

    experience.dynamics.com/.../

  • Suggested answer
    Rob F. Profile Picture
    Rob F. 483 on at
    RE: Is it possible to replicate Dynamics 365 Business Central Saas to either Azure SQL or On-Prem SQL

    Hi Warric,

    This third-party app called Cloud Replicator on AppSource can do what you are looking for.

    Rob

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Is it possible to replicate Dynamics 365 Business Central Saas to either Azure SQL or On-Prem SQL

    Hi Warric!

    The easiest way to get your data out is using API's there are many standard API's you can use to access your data. You can also create custom API's for data that is not covered by the standard API's.

    So using API's to extract data and store them in a local DB og Azure DB is not very hard. The API is used by the standard system for reporting in Power BI.

    You can also sync your data with Dataverse (common data service) i would recommend that way if you are working with really large amount of data that needs to be frequently updated.

    Some documentation on the API's

    docs.microsoft.com/.../

    And some on Business Central an dataverse:

    docs.microsoft.com/.../admin-common-data-service

    You can also export your online database and set it up on prem - but that is a manual process for each time and not very good for regular sync

    docs.microsoft.com/.../tenant-admin-center-database-export

    I hope this helps you further.

  • Warric Profile Picture
    Warric 25 on at
    RE: Is it possible to replicate Dynamics 365 Business Central Saas to either Azure SQL or On-Prem SQL

    Hi Inge

    Thanks for the response.

    Yes we currently are using the On Prem DB to connect to and report on directly (via SSIS/PBI).

    My thoughts where that one way would be to replicate the Online DB to Azure SQL/On Prem SQL daily (or specific tables) and then report on those tables via Azure Synapse etc.

    What are the various possibilities to access our data on a similar level e.g GL table, Item Ledger Table etc. if our data was stored on BC Saas for granular level reporting and customization similar to what is available with direct table access?

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Is it possible to replicate Dynamics 365 Business Central Saas to either Azure SQL or On-Prem SQL

    If you are looking at a way to actually replicate the data in a way that you can use the BC online data as a BC on-prem database then there is no solution for that.

    If you just want to store local data for reporting purpose and so on that is possible in various ways depending of your need.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

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

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans