Integrating Dynamics 365 ERP and CRM – Using Microsoft Flow and Common Data Service

 Why can’t we just sync data between CRM and ERP using Microsoft Flow only? why do we need to use Common Data Service?

Dynamics 365 unifies CRM and ERP capabilities into applications that work seamlessly together across different areas of a business. Two main components of Dynamics 365 are CRM and ERP applications.

For customers who use both CRM and ERP applications (for example, Dynamics 365 for Sales and Dynamics 365 for operations), it is important that these applications integrate and work together and one option for customers/partners is to use Microsoft Flow and Common data service(CDS)

In most cases, mapping of data between these products cannot be done directly. Same data may be stored in different ways or formats in these applications.

A simple example is, how Currency is used: In Dynamics 365 for Sales, Customer’s currency is stored with currency name as US Dollar whereas, in Dynamics 365 for operations, same data is stored with currency code as USD. In such cases, we can have a staging database in CDS to map as required in the destination application.

Very well explained, full article is here

https://suvidhablogpost.wordpress.com/2017/03/29/integrating-dynamics-365-erp-and-crm-using-microsoft-flow-and-common-data-service/