Common Data Model sync with external system

[bz3361]

Is there a way to sync data between Common Data Model and an external data source? For example, I build a PowerApp with CDM. The data in CDM sync with an external data source. Thanks

[v-monli-msft]

Hi bz,

I think you cannot "Sync" data between Common Data Model and an external data source, but you can import and export them as per the article says:
https://powerapps.microsoft.com/en-us/blog/announcing-powerapps-common-data-model/

Data import can be used for both initial bulk data migrations into CDM from external source or for ad hoc import of data where CDM platform can intelligently insert or update data.

Export data, on the other hand, enables user to output data in an asynchronous fashion for integration or quick analysis. You can also bulk edit the exported data in excel and then import the data back.

Regards,

Mona

[bz3361]

Thank you.

I am aware of the import and export function.

I was looking for some automated way to sync data so that manual intervention is not required. 

If it's not avialable as of today, what's happening regarding this on the product roadmap?

Thank you again

[Vicky_Song]

@bz3361, currently there is no public news on whether PG team considers enabling data sync between CDM and external data sources. However, you can submit one feature request in the PowerApps Ideas forum: https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas, and our engineers will evaluate it. 

[Beuferd]

Would a FLOW be usefull in this matter?

I used a flow that I set to:  Everytime I added a new record to a my CDM table --> copy that record to my SPO list.

Anyway, it worked for me.

Good luck.

[bz3361]

Very good point.

I have two scenarios to support. May I have your opinion in terms of the best flow action to use?

1. from external system to CDM: I have a rest (could be servlet) endpoint built my own. Invoke the endpoint to push some data into CDM. Is this possible? 

2. from CDM to external system: when CDM has a record update event happens, it invokes a rest service by passing all the attribute values of the record in json format. 

Thank you

[Beuferd]

I'm sorry, but I'm not the guy to answer your questions.

I'm happy I figured out the FLOW Sharepoint routine.

Good luck to you-as I am no help.

[DaveB]

The roadmap shared in one of the recent webinars indicated that CDS Office 365 data sync and a Data API

are estimated to be available in the first half of 2017.

Unfortunately I cannot access the recordings to verify the details:

US-PowerBI-WBNR-FY17-10Oct-27-Managing-data-and-applications-just-got-easier-267380_Registration.htm...US-PowerBI-WBNR-FY17-11Nov-03-AnnouncingPowerAppsgeneralavailability271671.html

These pages are not sending out links in emails as indicated.