I am trying to understand a couple of things surrounding how CDS works with other traditional DBs (SQL Server, Orcale, etc.). Also, I am trying to wrap my head around data sources for Model-Driven Apps
A few questions:
1. It seems that Model Driven Apps can only use CDS as the datasource. Is this true?
2. Given that my data in is a traditional DB, it would be required to move the data to CDS if wanting to build a Model-Driven App?
4. Is it true if moving to a CDS as the data source, the traditional DB receives the same CRUD actions when the CDS updated? Or does the traditional DB die?
5. If using CDS, does Microsoft assume the user to stop using the traditional DB? What is the expected practice around all of this?
I greatly appreciate any and all help understanding this subject. I cannot seem to find clear Microsoft documentation on topic.
Solved! Go to Solution.
Can someone give an answer to these questions? In particular 4. & 5.?
We are about to build a PowerApp and need to read/write data to a DB2 database and have realized things would be a lot simpler if we could simply mirror the DB2 tables to a CDS and then read/write to the CDS. But the changes to fields in the CDS then have to sync back to the DB2 database for us otherwise it would be pointless. We can unfortunately not abandon the DB2 database either since other systems use it to retrieve data as well.
Is there a way to set up two-way sync for a DB2 database and a CDS?