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
You can use the following solution microsoft/bc2adls: Exporting data from Dynamics 365 Business Central to Azure data lake storage (github.com)
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)
Hi Warric,
This third-party app called Cloud Replicator on AppSource can do what you are looking for.
Rob
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
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.
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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,277
Super User 2024 Season 2
#2
Martin Dráb
228,135
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (