Forum Discussion
Business Central Data to Fabric
Hii All, Has anyone explored the BC connection to it's underlying SQL database? Is there limitation to this approach? I need to get data from BC to fabric, is SQL database of BC worth exploring?
Olufemi7
Super User
Super UserHello Saum02,
If you're on BC Online, I will look at the Business Central APIs first rather than building the Fabric connection around the underlying SQL database.
Microsoft recommends the REST API stack for Business Central integrations.For BC Online, I will start with the Business Central APIs rather than building the Fabric solution around the underlying SQL database.
If this is an on-premises deployment, SQL access is another route to consider, depending on what you need to extract.
Is your BC environment Online or on-premises?
Microsoft docs:
Integration overview for Business Central (for architects and developers)
Introduction to Microsoft Fabric and Business Central