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

April 7 2017

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).

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.

More about Rahul Mohta


NeilDWright's picture

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?

mohtarahul's picture

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

DimanC's picture

Hi 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!