cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
xx
Level: Powered On

Connecting to a SQL Server database on AWS from PowerApps

I have a virtual machine on Amazon cloud (AWS) with a SQL Server.  When I try to connec to a database on it using PowerApps web editor I get a message saying the SQL Server is not found.

I'm sure this is related to the inbound rules on the virtual machine, but does anyone know what inbound rules I need to allow PowerApps to connect to a database on AWS? 

 

thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
PowerApps Staff cherie
PowerApps Staff

Re: Connecting to a SQL Server database on AWS from PowerApps

Hi,

 

I've not used AWS with SQL server before, but I'm wondering if this article might help you out?

 

https://powerapps.microsoft.com/en-us/tutorials/limits-and-config/

 

Thanks

Cherie

View solution in original post

8 REPLIES 8
PowerApps Staff cherie
PowerApps Staff

Re: Connecting to a SQL Server database on AWS from PowerApps

Hi,

 

I've not used AWS with SQL server before, but I'm wondering if this article might help you out?

 

https://powerapps.microsoft.com/en-us/tutorials/limits-and-config/

 

Thanks

Cherie

View solution in original post

xx
Level: Powered On

Re: Connecting to a SQL Server database on AWS from PowerApps

Yes that's exactly what I needed. Thank you.

giot
Level: Power Up

Re: Connecting to a SQL Server database on AWS from PowerApps

Dear XX,

I saw that this problem was solved.

I am very new to PowerApps and would need to connect to MySql (on AWS).

You used a custom connector, I'm sure.

Could you share more about it please?

Thank you!

Giovanna

 

xx
Level: Powered On

Re: Connecting to a SQL Server database on AWS from PowerApps

I don't think these are related.  I'm using SQL Server.

As far as I know, MySQL connector currently does not support cloud but supported only when using On-premises data gateway. So you cannot get direct connection on cloud services such as Amazon.  I think your choises are 1) install an on-prem gateway, 2) change to a data source that PowerApps connects via cloud (try Azure SQL), 3)  create a web service to do the read write operations and connect your app to it directly.  The web service route is quite involved, but if you are stuck with MySQL I can't think of any other way.

giot
Level: Power Up

Re: Connecting to a SQL Server database on AWS from PowerApps

Thank you. Option 2 seems the most viable option indeed.

thank you for taking the time to answer!

hayden
Level: Powered On

Re: Connecting to a SQL Server database on AWS from PowerApps

Very soon I'll be working on a project with has a Powerapp connecting to SQL Server on AWS. Is there a specific data connector to use? Or did you have to create a custom connector? Any lesson learned info you have would be appreciated.
xx
Level: Powered On

Re: Connecting to a SQL Server database on AWS from PowerApps

You can use the SQL Server connector, but you need to makesure you have configured the inbound rules.  Take a look at the source IPs for the PowerApp servers on the link in the answer post.  You just need to allow the Powerpp servers to see your DB server.  In the end I went with Azure SQL, because the architecture is much simpler and cheaper as I don't need to configure and manage VMs.

 

However, PowerApps has some serious limitations when working with SQL Server directly (instead of your own API).  If your database has triggers for example then PowerApps won't read/write to that.  It really needs a simple database.

There is a record limit, so if you are pulling a lot of data to show as a list, check what your requirements are.  If you want to pull more than 500 rows then you need to look into delegable data sources.  It is worth looking at this link.

 

https://docs.microsoft.com/en-us/connectors/sql/#known-issues-and-limitations

 

giot
Level: Power Up

Re: Connecting to a SQL Server database on AWS from PowerApps

thank you! I'll check it out!

Helpful resources

Announcements
thirdimage

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,360)