Google Cloud Database

indavidjool · 02-03-2020 11:33 PM

It appears to me that to authorize my app to connect to my Google Cloud Database, I have to add a long list of IP addresses individually to the authorized networks section on my Cloud Account. Given the changing relationship between Appsheet and Google have there been any chances in this regard?

Aleksi

No, you still need to add those IP addresses.

TDhers

Hi Ray, While this might evolve in the future for the next few months things are unchanged and you still need the IP Whitelisting.
Thierry

indavidjool

Thanks for that.

JonStrong

Hi - I know this is a year old topic. I’m revisiting it, as I’m running into the same question. I’ve got a PostgreSQL server “in the cloud” and would like to connect AppSheet to it - but as expected, the DBaaS host firewall is blocking AppSheet. It looks like I’ll need to something like 40 IP addresses to the firewall rules. Is this really the case? I’m assuming the list on the following page is correct:

Just feels a bit cumbersome to have to do this. I was hoping that perhaps a more streamlined approach was developed over the last year.

Thanks,
Jon

Steve

Unfortunately, that’s still the process.

JonStrong

Thanks Steve. Unfortunately the “database as a service” platform we use today requires each each new whitelisted IP to be entered via their web interface one at a time. No way to submit a group of rules, add comments indicating what stakeholder groups are associated with the IPs (we have to track that separately ourselves), etc. Great price and high availability / performance as the actual hosting is on our choice of AWS, Azure, GCP, Dreamhost at a fixed price, but we’re stuck with a very basic set of configuration controls – reasonable trade off at our stage of development, but as we can see, this will be really cumbersome for managing the whitelisted IPs for AppSheet.