How to integrate business central data to fabric onelake

[pavannarani]

Hello,

We have been working on a requirement to connect and pull the Business central data to Fabric. Can any one list out the steps to be followed how to setup the integration between these two systems:

1. How to built a datawarehouse solution for business central database in fabric onelake architecture

2. How to load historical data 

3. How to setup incremental refresh once we have the data in fabric

Regards

Pavan kumar

[Jerome22 · Accepted solution]

Hi

I'm using bc2adls

Releases · Bertverbeek4PS/bc2adls (github.com)

ibnitially developped by Microsoft, the code was maintained by another developper.

this is working fine.

this extension create a copy of all the tables tou want and do the incremental process for you with no effort.

this saved us days of development, also it's way faster and cost effective than using dataflow v2 

part of the other advantages, this support deleted rows (which is very hard to support using dataflows or other tools outside an application).

so do a try.

until Microsoft release a mirroring feature for BC, this tool is the best option (at least for us)

[pavannarani]

@Jerome22 Hi ,

I have gone through the BC2ADLS GITHUB documentation and implemented the feature as suggested its completely working fine for me. I am able to pull any table data from BC into Fabric lakehouse without any hassle. I want to know one thing one of our senior asked me as this extension is open source and maintained by other developers, can we use it for our customers to integrate BC data into fabric will there be any issues in future or did you faced any issues after implementing it with customers data. Do suggest me can i move forward with this approach to make sure.

Thanks in Advance

[pavannarani]

@Jerome22 Can you help me understand how to configure the setup process to download the tables from BC to ADLS, i have setup the oauth2.0 authentication to connect to BC, how to publish that code repository to business central online i need some assistance if you can give few steps it will be greatly helpful

[Jerome22]

well, it will be hard for me to help you.

but the documentation on the github repository is very detailed and explains all the configurations you have to do.

try to follow the steps, if you have issues, the guy in charge of this extension may help you.

[pavannarani]

Yes am following the documentation and am trying to point my instance to vs code getting the below error not finding how to do that, any idea did you face similar issue while implementing it

Error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. (api.businesscentral.dynamics.com:7049)

Error: An error occured while processing the request

[pavannarani]

@Jerome22  ok its nice feature so does it charge to implement it or can we download it and see how its working is it possible

[v-kaiyue-msft]

Hi @pavannarani ,

With Microsoft Fabric, there is only one source for all data. So you don't have to move data to another data warehouse or data lake. It's based on OneLake.

You can extract Business Central data into OneLake. you must create a Lakehouse in MS Fabric. You have to create a Lakehouse in MS Fabric. for Business Central you have to get the data from Dataflow Gen2:

Here you can select the tables you want to have in OneLake. After publishing, you can set the refresh rate and see all your data stored in your OneLake.

More detailed information can be found at the link:

Let’s flow your Business Central data into Microsoft Fabric - Discover Microsoft Business Central (b...

Fabric decision guide - choose a data store - Microsoft Fabric | Microsoft Learn

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[MircoPallotta]

With this method actually you dont have access to BC tables but to BC Web services. So if for example you need more columns than the ones provided by the standard APIs you need to write your own custom webservices, which is not a difficult task but for sure time consuming and costly to maintain.

[pavannarani]

@collinq Thank you for the link i will go through the related articles and see how to setup connection between two systems and extract data. 

[collinq]

Hi @pavannarani ,

That is not really something that can be answered in a forum with any degree of certainty or "correctness".  These are the questions that a consulting firm can help with in setting this up as the variables are almost endless and each decision begets another decision.

As far as a technical how to connect, you can start with this article: Introduction to Microsoft Fabric and Business Central - Business Central | Microsoft Learn  and then read all of the related articles and take the e-learning modules.