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 one of the advisory members of Real Dynamics.  He has cultivated diverse and rich experiences working with global Dynamics AX customers and partners, enabling them to realize the full value of their ERP platforms. Rahul's 15 years of experience spans across multiple geographies (Americas, Europe, Asia, India) and multiple domains - Financials, Supply Chain, Distribution, Manufacturing, Warehousing, Retail and Professional Services. Prior to joining Real Dynamics, he played consulting roles for Microsoft and Infosys. For more information on Real Dynamics services, please contact us at

To learn more about the author, visit:

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!