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.

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.

Contents:

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.

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.

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-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.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).

To assure 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
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.