cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jmars
Level: Power Up

Power Apps as an OLTP front end?

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?

 

Thanks!

3 REPLIES 3
Community Support Team
Community Support Team

Re: Power Apps as an OLTP front end?

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:

https://docs.microsoft.com/en-us/power-platform/admin/data-integrator

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jmars
Level: Power Up

Re: Power Apps as an OLTP front end?

Thanks for the reply.

Could you elaborate on "could not save data"? I seem to be able to get data into Power Apps easily. It's getting it out that seems tricky...
C_Chrisstov
Level: Powered On

Re: Power Apps as an OLTP front end?

Have you tried constructing the relevant statement with the Patch formula to update back to the sql table?

There is a myriad of threads on this topice here. 

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,281)