How-to: Bring your own data warehouse to Microsoft Dynamics 365 for Operations

Many customers have an existing data warehouse where Microsoft Dynamics AX ERP data constitutes a fraction of the share and non-ERP data constitutes a larger share. In such situations re-architecting the whole data warehouse may be infeasible. Customers would need AX data in their own data warehouse, which is why Dynamics 365 for Operations supports the option to bring your own data warehouse (or BYODw - not yet an industry acronym, but it will be).

When would a D365 for Operations customer opt for BYODw, when the customer can leverage the entity store (AXDW) out of box for all reporting based on AX data? If they have their own data warehouse and need information from D365 Operations, then they need to choose BYODw.

Using D365 for Operations (AX), you can export data to an Azure SQL database and then pull the information from there to your own data warehouse.


Requires FREE Membership to View

Become a Member Joining gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more, and it’s all FREE. You’ll also receive periodic email newsletters with the latest relevant articles and content updates.
About Rahul Mohta

Rahul Mohta is a value advisor for Microsoft Dynamics 365. He has solid techno-functional experience in Microsoft Dynamics 365 for Finance and Operations for Dynamics platform evaluation, end to end implementations, strategic initiatives, mergers and acquisitions, roll outs, training and advisory.

Read full bio...

Entities for multiple companies

Apparently, entities have to be published per company (legal entity). Is this the case? If so, is there a work-around to publish multi-company entities?

BYODw Dynamics 365 Operations AX

Data entities in "D365 Operation" are global in their behavior and one can access data across companies using them.

only Staging tables?


Could anyone explain me - why only staging tables (as it can be seen on the last picture of this article) are present in the BYOD database? I was expecting to see tables with structure "Target table" there, but it's not the case.

Thank you!