cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Joel_Hill
Frequent Visitor

PowerApps Data Integration vs Connection

This might be a dumb question, but I am trying to figure out when to use a data integration vs a connection within PowerApps.  Is one a subset of the other?  A data integration seems to allow data filtering and manipulation before the data reaches the app.  A connection seems to allow triggers and actions using Flow based on what is happening with the data. 

 

However:

- Both seem to allow loading of data to PowerApps

- Both seem to allow saving data from PowerApps back to the source

 

Can someone clarify and my apologies again if this is a dumb question.

1 ACCEPTED SOLUTION

Accepted Solutions
kheiman
Frequent Visitor

Assuming I'm understanding your question correctly, a 'connection' is used for ad-hoc queries directly to the data source. So, for example, I can have a SQL 'connection' that lets me directly query SQL data in my Powerapp, etc.

 

Using Data Integration actually physically copies the data into my CDS environment's 'local' database, so we actually have a copy of the data. So, using the SQL example, we would use the SQL 'connection' in a data integration that brings down some of the data to our app environment. Then our app accesses that local data instead of directly accessing CDS, and the Data Integration takes care of refreshing our data. (although we have to handle updates back to the source database in our powerapp if desired)

 

Typically we will often use connections in apps UNLESS

- We want to build model-driven apps instead of canvas apps (data needs to be stored in CDS)

- There is some issue (load/performance/etc) associated with 'live' access via a connection.

- There is some reason to operate against a 'copy' of the data instead of directly in production (external processes, etc)

 

View solution in original post

1 REPLY 1
kheiman
Frequent Visitor

Assuming I'm understanding your question correctly, a 'connection' is used for ad-hoc queries directly to the data source. So, for example, I can have a SQL 'connection' that lets me directly query SQL data in my Powerapp, etc.

 

Using Data Integration actually physically copies the data into my CDS environment's 'local' database, so we actually have a copy of the data. So, using the SQL example, we would use the SQL 'connection' in a data integration that brings down some of the data to our app environment. Then our app accesses that local data instead of directly accessing CDS, and the Data Integration takes care of refreshing our data. (although we have to handle updates back to the source database in our powerapp if desired)

 

Typically we will often use connections in apps UNLESS

- We want to build model-driven apps instead of canvas apps (data needs to be stored in CDS)

- There is some issue (load/performance/etc) associated with 'live' access via a connection.

- There is some reason to operate against a 'copy' of the data instead of directly in production (external processes, etc)

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (2,200)