From Business Central to data warehouse

(1) Share

Report

Posted on by Maxime42

Greetings.

We need to export a lot of tables from Business Central to a data warehouse on SQL Azure.

What is the best way to achieve this?

We tried the dataverse approach but it seems to contain only CRM tables (we need to load alot of finance-related tables).

Any suggestions would be welcome!

I have the same question (1)

All responses (10)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (1)

Report

Hi

My suggestion is look into following app

https://appsource.microsoft.com/en-us/product/dynamics-365-business-central/PUBID.efoqus-5058796%7CAID.replicator%7CPAPPID.18a4d438-88d1-44ee-a38d-3c0ea0d77338

or

https://lyftron.com/source/data-migration-from-dynamics-365-business-central-to-snowflake-google-bigquery-amazon-redshift-and-azure-sql-database/

Or following topic

github.com/.../bc2adls

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (1)

Report

This blog is worth a review too: demiliani.com/.../

This is good too: www.cdata.com/.../d365businesscentral-sync-azure.rst

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,546 Super User 2025 Season 2 on at

Like (1)

Report

Hi, You can try standard APIs, or standard WebServices. If it is not enough, you can develop new API pages, or add new List pages, and then publish them to WebService.

For APIs:

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-api-pagetype

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-develop-custom-api

https://yzhums.com/6117/

https://yzhums.com/22845/

For WebService:

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/web-services

Hope this info also helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

Using datalakes can be an option and there is an open source app available for that here:

github.com/.../bc2adls

Was this reply helpful? Yes No
Maxime42 12 on at

Like (0)

Report

Thanks the app from Efoqus seems to be the solutions. Thanks for your help.

Was this reply helpful? Yes No
mishaln 15 on at

Like (0)

Report

Hello Maxime42

can you please share how did you configure cloud replicator? For some reason, I’m only getting errors when trying to run the replication.

Thanks,

Mishal

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

Have you followed this guideline? https://www.efoqus.ca/products/cloud-replicator/cloud-replicator-setup/

And what is the error message?

Was this reply helpful? Yes No
mishaln 15 on at

Like (0)

Report

Hello MahGah

I did follow the setup guide. I am trying to replicate to Cosmos DB - below error

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (1)

Report

Hi

I never saw that error before when I tested the app. Please send email to info@efoqus.ca and they are usually quick to answer and help.

Was this reply helpful? Yes No
Suggested answer

Community member 7 on at

Like (2)

Report

For anyone seeking to find an easy solution to this in the future, I recommend this app: Ecodel Exclusive - Datawarehouse Connector (microsoft.com)

Can be downloaded from AppSource.

Was this reply helpful? Yes No