Native connection with Fabric in Business Central


Business Central now offers a native connection with Microsoft Fabric, as announced at FabCon in Barcelona. This integration eliminates the need for API calls, bc2adls, and endpoints, providing direct sync from the SQL database with support for deletions. All tables in the database, up to 500, are supported with company and table selection available. The sync process does not impact the NST and only committed records are sent to Fabric, happening within minutes. An open mirroring database in Fabric is required, alongside a Fabric SKU license. Inside Business Central, users can select their workspace, open mirroring, companies, and tables to export. The setup process involves Business Central, and APIs can handle operations. With this integration, bc2adls will enter maintenance mode, with no new features expected but continued support for upcoming BC releases. Users are encouraged to transition to the new integration for exporting data.


Article 2w

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time