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:
Keep your eyes open for our upcoming T-shirt design contest!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020