cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

PostgreSQL Google Cloud Platform (7/6): How to Connect?

Dear Members,

 

Am new to this kind of connection - which is between Google Cloud Platform to PowerApps but using PostgreSQL to connect.

 

How do I connect the Google Cloud Platform gateway using the PostgreSQL type connection? Is there a sample to share and can I please have some guidance? Not too sure why the gateway reference continues to be greyed out or that there the button to "connect" didn't actually appear appropriately to allow to connect. Also, why is there a "preview" on the connector? 

 

GCP PostgreSQL PowerApps.PNG

 

Thanks in advance team! 

3 REPLIES 3
danielbazetto
Community Support
Community Support

Hello @Anonymous 

 

Regarding the question regarding preview, you can see it there because this connector was not fully shipped and it can have changes on the way it works, for more info regarding preview you can find it here:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-experimental-preview

 

The image you posted says you do not have a Gateway configured, that will be required. I found a link that might be helpful as well:
https://www.cdata.com/kb/tech/postgresql-cloudhub-powerapps.rst

Anonymous
Not applicable

Thanks @danielbazetto , I've read it and couldn't completely understand the difference between CData and Google Cloud Platform. Is not the gateway the same between all 3rd party databases or that I will have to check directly with Google Cloud Platform help centre to provide a gateway for this purpose? 

Hi @Anonymous ,

 

Apologies for the initial response, the direct access to Google Cloud platform is not supported by Postgresql connector, this connector is to access On-Prem data.

danielbazetto_0-1595250354156.png

https://docs.microsoft.com/en-us/connectors/postgresql/

 

So what you are trying to do is unsupported I believe, however I found a another thread replied by a colleague which is well documented.
https://powerusers.microsoft.com/t5/Building-Power-Apps/Can-Power-Apps-write-back-to-Cloud-SQL-google/td-p/340819

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (2,008)