Bring your own database (BYOD) to Dynamics 365 for Finance and Operations

Home  ›  BI  ›  Bring your own database (BYOD) to Dynamics 365 for Finance and Operations
Bring your own database (BYOD) to Dynamics 365 for Finance and Operations
September 21, 2018 No Comments BI,BYOD,data warehouse,Dynamics 365 Yuriy Raskazov

This feature was released with platform update 2 and allows export data (via data entities) into another Azure SQL Database where denormalised and agregated data can be easily accessed for reporting, BI or integration purposes. Export can be done via full push (all data) or incremental push (only changed records). Recommended scenarios to BYOD would be:

  • build own data warehouse
  • analytical tools which require direct sql
  • batch integration with another systems
  • legacy integration solutions which need to be upgraded to support D365

 

Learn more, how you can export data from Microsoft Dynamics 365 for Finance and Operations to an external Microsoft Azure SQL database from this Microsoft video

Tags
About The Author
Yuriy Raskazov Microsoft Certified Professional, experienced in application development, solution design and consulting for business solution implementations based on Dynamics 365 Finance and Operations
Posts You might like
D365 F&O Connector for Time Tracking, Expense management (Part II) May 19, 2020
D365 F&O Connector for Time Tracking, Expense management May 14, 2020
D365 F&O Integration Features (Part2) May 5, 2020
D365 F&O Integration Features May 5, 2020
Security Architecture in D365 F&O May 5, 2020
How to setup legal entities and organization hierarchies in D365 F&O May 5, 2020
Lifecycle Services for D365 Finance & Operations (LCS) May 5, 2020
Enable Business Transformation with Integration November 2, 2018
How to restore D365 F&O cloud-hosted environment October 17, 2018

Leave a reply