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

Leave a reply

Your email address will not be published. Required fields are marked *