Microsoft is piloting Azure Data Lake export use cases for Dynamics 365 Business Central

April 20 2022

Microsoft is piloting a new way for Dynamics 365 Business Central customers to host their ERP data in an Azure Data Lake for data warehouse and analytics needs.

“Our solution opens up some interesting possibilities for organizations using Business Central,” wrote Microsoft’s Soumya Dutta and Henri Schulte. Their proof of concept is available here

Source: Microsoft

The solution is based on a Business Central extension that provides configurable ways to incrementally push data inserts, updates, and deletions into an Azure data lake with an Azure Synapse pipeline that reconstructs the data from the increments in the data lake in the Common Data Model format.

About Jason Gumpert

As the editor of, Jason oversees all editorial content on the site and at our events, as well as providing site management and strategy. He can be reached at

Prior to co-founding, Jason was a Principal Software Consultant at Parametric Technology Corporation (PTC), where he implemented solutions, trained customers, managed software development, and spent some time in the pre-sales engineering organization. He has also held consulting positions at CSC Consulting and Monitor Group.

More about Jason Gumpert