I'm currently testing power apps for my organization as a potential UI point for users. Since we have a lot of departments that interface, and a large on premise footprint, I need to get data into PowerApps and out of PowerApps in an OLTP fashion.
In case you don't know how OLTP works essentially we can't use UPDATE or DELETE statements. Any UPDATE or DELETE statements sent back to the OLTP server need to be in the form of INSERT statements that contain the entire row of data to be updated or deleted. These INSERTED rows are then timestamped by the SQL Server on premise. Furthermore to select data from OLTP tables, Power Apps needs to filter the data by timestamp.
My OLTP Database is an on premise SQL server that I have set up with the Azure On-Premise Gateway.
Has anyone built anything like this before?
It seems difficult to get data out of PowerApps into On-Premise SQL Server, does anyone have experience with that?
Hi @jmars ,
Do you want to import data from SQL to PowerApps?
Firstly, powerapps could not save data.
I assume that you want to import data into CDS, one serivice of PowerApps.
If so, I suggest you kown more about data intergration, a good way to make this.
Here's a doc about it in details for your reference:
Watch Microsoft Business Applications Summit sessions on-demand.
The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!
Features releasing from April 2020 through September 2020