A common data loading use case involves extracting data from your local database and uploading it to your GoodData workspace. This can be impacted by firewalls in place to protect your internal database.
IP whitelisting is a security feature often used for limiting and controlling access only to trusted users. IP whitelisting allows you to create lists of trusted IP addresses or IP ranges from which your users can access your domains. To connect to resources behind enterprise firewall systems, GoodData's data loading tools include a secured proxy so that all external traffic is passed through a consistent set of IP addresses that you can easily whitelist.
Using IP Whitelisting with the GoodData Platform
You can set IP whitelisting for either individual users or domains. IP whitelists set for users override domain whitelisting.
- To set up IP whitelisting for a user, use the REST API (see the
effectiveIpWhitelistparameters). Only domain administrators can set IP whitelisting for users.
To set up IP whitelisting at the domain level, contact GoodData Support.
Obtaining IP Addresses
To find the current IP addresses of your hosted workspaces (for example,
secure.eu.gooddata.com, or your custom domain), use a command such as
As IP addresses can change on occasion, we strongly recommend that you not use them to connect to the GoodData platform.
Whitelisted IP Addresses
Depending on the datacenter that holds your data, add the following IP addresses to your firewall:
To find out at what datacenter your data is stored, see GoodData Datacenters.
US-1 - United States, Chicago, IL
|US-2 - United States, Dallas, TX|
|EU-2 - Germany, Frankfurt|
|EU-1 - United Kingdom, London|
To preserve naming convention continuity, the UK-based datacenter retains its "EU" moniker in the domain URL and may be referred to as EU-1 in related documents.
|CA-2 - Canada, Montreal|
Common Database Ports
|Database / Endpoint||Ports|
|Amazon Redshift||From 1024 to 65535|
|Microsoft SQL Server||From 1024 to 65535|
|Microsoft Azure SQL Database||From 1024 to 65535|
|Microsoft Azure Synapse Analytics||From 1024 to 65535|
|MySQL||From 1024 to 65535|
|PostgreSQL||From 1024 to 65535|
GoodData Connection Ports