You’re offline. This is a read only version of the page.
Announcements
2
Hi everybody,
For some time now I’m trying to sync my CDS with my Azure SQL database. The progress I have made so far is that i get the data from my azure SQL database in my CDS by connecting them through a dataflow. However this connection only works one way so I only get data from SQL to The CDS. I can’t find out how to keep them completely I’m sync. I was wondering of somebody of you could help me with this problem. I want to achieve this so that I can sync the data that is mutated through a powerapp or even a Powerappsportal with azure where I connect with all the api’s.
Let me know you need some more information. Thank you in advance!
One way to sync data (at the entity level) from CDS to Azure SQL is the use the Data Export Service. However, if you want a 2 way sync, whatever technology you use you will have to work out how to stop recursive syncs. Ideally, you'd be able to designate a master system (CDS or SQL Azure) where all data changes occur, and they are then synched to the other system. It is viable to have different data sets mastered in different systems - e.g. you might master the account entity in CDS, and a custom entity in SQL Azure
Share
Report
All responses (
Answers (
