Data Loading and IP Whitelisting

A common data loading use case involves extracting data from your local database and uploading it to your GoodData project. This can be impacted by firewalls in place to protect your internal database.

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.

For general information about IP whitelisting on the GoodData platform, see IP Whitelisting.

Contents:

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.

DatacenterIP addressNotes

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

108.171.171.238*
23.253.9.202*
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

  • The two IP addresses, 108.171.171.238 and 23.253.9.202 (they are marked with an asterisk), are deprecated (see IP Addresses Used for Data Loading). We will be using them till May 16, 2020. After that date, you can (but do not have to) delete them from your whitelist.
  • The IP addresses from 161.47.43.128 to 161.47.43.159 inclusive will start functioning on May 16, 2020.
  • 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 address 107.22.195.240 is no longer in use.
US-2 - United States, Dallas, TX
secure-na3.na.gooddata.com
148.62.70.170*
148.62.70.171*
148.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
  • The two IP addresses, 148.62.70.170 and 148.62.70.171 (they are marked with an asterisk), are deprecated (see IP Addresses Used for Data Loading). We will be using them till May 16, 2020. After that date, you can (but do not have to) delete them from your whitelist.
  • The IP addresses from 148.62.70.64 to 148.62.70.95 inclusive will start functioning on May 16, 2020.
  • 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.
EU -  European Union
secure.eu.gooddata.com
78.136.2.250*
134.213.186.151*
94.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
  • The two IP addresses, 78.136.2.250 and 134.213.186.151 (they are marked with an asterisk), are deprecated (see IP Addresses Used for Data Loading). We will be using them till May 16, 2020. After that date, you can (but do not have to) delete them from your whitelist.
  • The IP addresses from 94.236.99.32 to 94.236.99.47 inclusive will start functioning on May 16, 2020.
  • 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.
CA - Canada
secure.ca.gooddata.com
209.151.86.32
209.151.86.33
209.151.86.34
209.151.86.35
209.151.86.36
209.151.86.37
209.151.86.38
209.151.86.39
209.151.86.40
209.151.86.41
209.151.86.42
209.151.86.43
209.151.86.44
209.151.86.45
209.151.86.46
209.151.86.47
209.151.86.48
209.151.86.49
209.151.86.50
209.151.86.51
209.151.86.52
209.151.86.53*
209.151.86.54
209.151.86.55
209.151.86.56
209.151.86.57
209.151.86.58
209.151.86.59
209.151.86.60*
209.151.86.61
209.151.86.62
209.151.86.63
  • The two IP addresses, 209.151.86.53 and 209.151.86.60 (they are marked with an asterisk), have already been in use, and we will continue using them. You may already have these two IP addresses whitelisted.
  • Except for 209.151.86.53 and 209.151.86.60 that are already in use, the IP addresses from 209.151.86.32 to 209.151.86.63 inclusive will start functioning on May 16, 2020.
  • Instead of whitelisting all the IP addresses from 209.151.86.32 to 209.151.86.63 inclusive, you can whitelist the IP range 209.151.86.32/27.


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 / EndpointPort
Amazon Redshift JDBC driver5439
Firebird3050
Interbase3050
Microsoft SQL Server1433, 1434
MySQL3306
Oracle1521
PostgreSQL5432, 5433
SFTP22

GoodData Connection Ports

See Ports Used to Connect to GoodData.