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

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 IP Addresses Used for Data Loading).
US-2 - United States, Dallas, TX
secure-na3.na.gooddata.com
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
  • 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 IP Addresses Used for Data Loading).
EU-1 - United Kingdom, London
secure.eu.gooddata.com
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
  • 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 IP Addresses Used for Data Loading).
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


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

GoodData Connection Ports

See Ports Used to Connect to GoodData.

Powered by Atlassian Confluence and Scroll Viewport.