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

 

GoodData Connection Ports

See Ports Used to Connect to GoodData.