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?
2 Replies
- Olufemi7
Super User
Hello 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 - NandanHegde
You cannot directly access the underlying database
similar thread : Accessing BC Data
