Unanswered

How to sync the data between Dynamics 365 "Sales" and "Common Data Service"?

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I want to validate the working of the CDM(Common Data Model) that manages the common data across various platforms.
I have referred the below links and tried to establish the connections as facilitated in power apps:

https://www.gigxp.com/powerapps-data-integration/
https://community.dynamics.com/365/b/dynamics365bysandeepchaudhury/archive/2017/07/20/common-data-services-cds-data-integrator-and-dynamics-365-what-will-you-do

But, the issue is, I don't find any template to sync the data between Sales and CDS when I tried to create the new project.

Please let me know how to validate the working of the Common Data Service provided by Microsoft.

Also, where it keeps the data if I've integrated data from "Sales" to "CDS" AND from "CDS" to "Fin ops"? Does it keep all the data in the CDS only? OR it keeps redundant data on all platforms.

Any help would be much appreciated.

Thank you.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

CWesener on at

Like (1)

Report

Hi @Anonymous - if you're using Dynamics 365 for Sales V9 or above, your data is already available in the Common Data Service, it's the same platform - so there is no need to perform any data integration. If you log into web.powerapps.com, you can select your environment from the drop down in the top right corner. Then you can use PowerApps and the Common Data Service with your Dynamics data.

If you're not able to see your environment in the PowerApps portal, your environment might not yet be enabled. If you send me a message with your environment URL and we can make sure it's connected.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@CWesener, thank you for your response.

->As per I have understood the concept of CDS, it is the common database for all the platforms.
If I require the additional entities or fields, I can create my custom ones if not present in CDS. I can make use of Microsoft Flows to sync the data among multiple platforms using CDS. Also, I can generate the power BI reports using CDS environment. MS keeps redundant data for customers (their common fields/attributes) in CDS, Dynamics 365 sales (CE), and Dynamics 365 Finance and Operations, if I talk about 365 sales and FinOps integration for an example.
Is this understanding correct?

->I am able to select the environment in the PowerApps portal. No issue with that.

Can I still get clarified with the below issues I got?

->How to see the data in CDS? I am not able to see the same data in the CDS trial instance like that in Sales instance.
->How to create the customer in Finance and operations, if an account is created in Dynamics Sales.
->I have created the trial instance for Finance and Operations. But I am not able to select the environment of the created instance during data integration as in the attached snapshot. How to get the trial instance for Finance and operations?
->Most of the templates provided make use of Finance and operations while creating the project.
What can be the way if I want to sync data between other platforms? For example - between outlook
web and D365 sales?
→ Can I create my custom template for a project?

SalesToOperations...

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Can we create our own project template other than the predefined templates?

Was this reply helpful? Yes No