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.
For general information about IP whitelisting on the GoodData platform, see IP Whitelisting.
To connect to resources behind enterprise firewall systems, GoodData's data loading tools (such as CloudConnect Designer and Ruby Bricks) include a secured proxy so that all external traffic is passed through a consistent set of IP addresses that you can easily whitelist.
Whitelisted IP addresses
To enable data loading IP whitelisting, add the following IP addresses to your firewall:
To find out what datacenter your data is physically stored, see GoodData Datacenters.
188.8.131.52 is no longer in use. Ensure that you replaced it with
184.108.40.206 in your firewall settings.
Common Database Ports
The following table describes the specific ports that are used by common database engines. Depending on the installed database, these ports must be enabled for communication between the GoodData's data loading tools and your database:
|1433, 1434||Microsoft SQL Server|
|5439||Amazon Redshift JDBC driver|
For more information, contact GoodData Support.
GoodData Connection Ports
For more information on GoodData ports, see Ports Used to Connect to GoodData.