Skip to main content
Community site session details

Community site session details

Session Id : dFQhJuiDdGimn9gDtDpO6X
Power Apps - Building Power Apps
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 6 Jul 2020 14:19:01 by

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! 

Categories:
  • danielbazetto Profile Picture
    on 20 Jul 2020 at 13:06:12
    Re: PostgreSQL Google Cloud Platform (7/6): How to Connect?

    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

  • Community Power Platform Member Profile Picture
    on 08 Jul 2020 at 15:48:14
    Re: PostgreSQL Google Cloud Platform (7/6): How to Connect?

    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? 

  • danielbazetto Profile Picture
    on 08 Jul 2020 at 10:09:31
    Re: PostgreSQL Google Cloud Platform (7/6): How to Connect?

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading complete