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
Depending on the database that you use, enable the ports for communication between the GoodData's data loading tools and your database:
|Database / Endpoint||Port|
|Amazon Redshift JDBC driver||5439|
|Microsoft SQL Server||1433 or a custom port (see GoodData-Microsoft SQL Server Integration Details)|
|PostgreSQL||5432 or a custom port (see GoodData-PostgreSQL Integration Details)|
GoodData Connection Ports