I want to setup a remote DB connection through the corporate firewall. How do I figure out the source IP address of the Anvil backend as it tries to connect to my DB?
If this is not a static IP, is there a range of IP addresses I could get for my fw rule?
There is a set number of IP’s, iirc Anvil is not going to post it on the forum. You should email support@anvil.works and give them the reasoning / use case for why you need them and I’m sure they will be happy to oblige.
Have you considered using Uplink for this? It’s what we do for our database apps.
Have the query code run locally (or in a secure server which is permitted access to your database) and use Uplink to access the local code. @anvil.server.callable is all you need for decoration once you set up the Uplink code value in your local software.
We typically pass the SQL query to the local code and return the response to the calling function within the Anvil app framework.
No need for firewall adjustments or knowing source IP addresses!
Thank you both for the suggestions!