You’re offline. This is a read only version of the page.
45
Hello,
Has anybody any experience of, or resources on connecting Business Central data to a data warehouse?
The warehouse would be a standard Kimball design, bringing together historic data from a previous ERP and new data from BC into a common model.
With this:
I've been failing at the first hurdle. Normally I'd do the load in SSIS but the component fails. It also fails on Azure Data Factory with an OData data source (the error message is different, but it occurs with the same conditions).
This is BC15 in the cloud so no on-prem straight to the SQL Server goodness...
I'm close to falling back to tried and test python / airflow but I'd like to be able to do this on the MS stack.
Any help much appreciated.
#1
Sumit Singh
2,727
#2
Sohail Ahmed
2,681
Super User 2025 Season 2
#3
YUN ZHU
2,288
Super User 2025 Season 2
Share
Report
All responses (
Answers (