GoodData IP Addresses and IP Whitelisting

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 ipWhitelist and effectiveIpWhitelist parameters). 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.gooddata.com, secure.eu.gooddata.com, or your custom domain), use a command such as dig, host, or nslookup.

Whitelisted IP Addresses

Depending on the datacenter that holds your data, add the following IP addresses to your firewall:

DatacenterIP addressNotes

US-1 - United States, Chicago, IL secure.gooddata.com

161.47.43.128 161.47.43.129 161.47.43.130 161.47.43.131 161.47.43.132 161.47.43.133 161.47.43.134 161.47.43.135 161.47.43.136 161.47.43.137 161.47.43.138 161.47.43.139 161.47.43.140 161.47.43.141 161.47.43.142 161.47.43.143 161.47.43.144 161.47.43.145 161.47.43.146 161.47.43.147 161.47.43.148 161.47.43.149 161.47.43.150 161.47.43.151 161.47.43.152 161.47.43.153 161.47.43.154 161.47.43.155 161.47.43.156 161.47.43.157 161.47.43.158 161.47.43.159

  • Instead of whitelisting all the IP addresses from 161.47.43.128 to 161.47.43.159 inclusive, you can whitelist the IP range 161.47.43.128/27.
  • The IP addresses 107.22.195.240, 108.171.171.238, and 23.253.9.202 are no longer in use (see Deprecated IP Addresses).
US-2 - United States, Dallas, TX secure-na3.na.gooddata.com148.62.70.64 148.62.70.65 148.62.70.66 148.62.70.67 148.62.70.68 148.62.70.69 148.62.70.70 148.62.70.71 148.62.70.72 148.62.70.73 148.62.70.74 148.62.70.75 148.62.70.76 148.62.70.77 148.62.70.78 148.62.70.79 148.62.70.80 148.62.70.81 148.62.70.82 148.62.70.83 148.62.70.84 148.62.70.85 148.62.70.86 148.62.70.87 148.62.70.88 148.62.70.89 148.62.70.90 148.62.70.91 148.62.70.92 148.62.70.93 148.62.70.94 148.62.70.95
  • Instead of whitelisting all the IP addresses from 148.62.70.64 to 148.62.70.95 inclusive, you can whitelist the IP range 148.62.70.64/27.
  • The IP addresses 148.62.70.170 and 148.62.70.171 are no longer in use (see Deprecated IP Addresses).
EU-2 - Germany, Frankfurt

54.93.65.197 3.64.46.116 3.64.30.232 3.64.102.77 3.123.67.62 3.121.51.86 18.198.61.210 18.198.253.203 18.198.248.79 18.198.237.52 18.198.185.157 18.198.183.175 18.198.163.227 18.194.68.247 18.192.52.107 18.192.188.68 18.159.81.154 18.159.186.41 18.157.170.41 18.156.43.200

 
EU-1 - United Kingdom, London secure.eu.gooddata.com94.236.99.32 94.236.99.33 94.236.99.34 94.236.99.35 94.236.99.36 94.236.99.37 94.236.99.38 94.236.99.39 94.236.99.40 94.236.99.41 94.236.99.42 94.236.99.43 94.236.99.44 94.236.99.45 94.236.99.46 94.236.99.47
  • Instead of whitelisting all the IP addresses from 94.236.99.32 to 94.236.99.47 inclusive, you can whitelist the IP range 94.236.99.32/28.
  • The IP addresses 78.136.2.250 and 134.213.186.151 are no longer in use (see Deprecated IP Addresses).
CA-2 - Canada, Montreal secure.ca.gooddata.com

15.223.20.1 15.223.90.109 15.223.55.128 15.223.60.231 35.182.54.143 3.96.236.251 3.96.237.166

 
SYD-1 - Australia, Sydney secure.syd1.gooddata.com

13.210.174.251 13.210.212.90 13.236.42.100 13.237.180.140 13.239.153.8 13.54.252.222 3.105.53.7 3.24.21.18 3.25.15.205 52.62.115.252 52.62.60.208 52.63.247.255 52.64.200.121 52.65.98.126 54.206.133.52 54.252.2.171 54.252.206.157 54.252.83.250 54.253.150.177 54.253.84.66    

 

Common Database Ports

Database / EndpointPorts
Amazon RedshiftFrom 1024 to 65535
Firebird3050
Interbase3050
Microsoft SQL ServerFrom 1024 to 65535
Microsoft Azure SQL DatabaseFrom 1024 to 65535
Microsoft Azure Synapse AnalyticsFrom 1024 to 65535
MySQLFrom 1024 to 65535
Oracle1521
PostgreSQLFrom 1024 to 65535