cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jmars
New Member

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
Community Support

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
New Member

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
Frequent Visitor

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
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,921)