cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FLOWPA
Advocate I
Advocate I

Gateway needed for MySQL connector? even if the MySQL database is in the cloud?

When installing the MySQL database connector, I am told that a gateway is needed, and I am prompted to download a 300mb+ file
The MySQL database is not stored locally, it's a remote database within a managed hosting service. 


I know it's a premium connector, but I don't mind the licensing cost. I just need to understand it.

 

The terminology 'on-premises gateway' is confusing me. Do I still need to install the gateway to use the remote MySQL database connector? Please, could anyone clarify? 

2 ACCEPTED SOLUTIONS

Accepted Solutions
rizkyaditya
Resolver III
Resolver III

Hello @FLOWPA ,

 

Maybe you can refer to this video : Powerapps on premise data gateway 

 

I hope this helps.

View solution in original post

timl
Super User
Super User

Hi @FLOWPA 

Yes, what you're saying is correct. It's not possible to connect directly to MySQL, in the same way that you could connect to an instance of Microsoft SQL Server Azure that's hosted in the cloud.

Any connection to MySQL must go through the on-premises gateway, even for cloud hosted MySQL instances (such as MySQL that's hosted in the Amazon RDS).

View solution in original post

4 REPLIES 4
rizkyaditya
Resolver III
Resolver III

Hello @FLOWPA ,

 

Maybe you can refer to this video : Powerapps on premise data gateway 

 

I hope this helps.

View solution in original post

timl
Super User
Super User

Hi @FLOWPA 

Yes, what you're saying is correct. It's not possible to connect directly to MySQL, in the same way that you could connect to an instance of Microsoft SQL Server Azure that's hosted in the cloud.

Any connection to MySQL must go through the on-premises gateway, even for cloud hosted MySQL instances (such as MySQL that's hosted in the Amazon RDS).

View solution in original post


@timl wrote:

Hi @FLOWPA 

Yes, what you're saying is correct. It's not possible to connect directly to MySQL, in the same way that you could connect to an instance of Microsoft SQL Server Azure that's hosted in the cloud.

Any connection to MySQL must go through the on-premises gateway, even for cloud hosted MySQL instances (such as MySQL that's hosted in the Amazon RDS).


@timl I love clear explanations like yours. Thanks, I understand it now.

(I accepted the wrong solution, how do I change it? This was supposed to be the solution)

timl
Super User
Super User

Thanks @FLOWPA - I'm glad that helped you 🙂
I think it might be possible to unaccept solutions by using the menu items though the elipses icon against the post.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (951)