IP Whitelisting

If you're using Direct Connection method, you might need to whitelist Holistics' IP addresses in order to connect properly.

NOTE

Please consult with your SysOps, DBA to help you to whitelist our IP addresses. Doing so ensures that only specific, trusted hosts can have access to your database.

IP Addresses to whitelist

You can find the 2 IP addresses in your Data Source Connection Form. Or, you can check your Data Center and then whitelist the compatible IPs:

• APAC:
  • 188.166.198.14
  • 188.166.196.151
• EU:
  • 157.245.16.185
  • 157.245.16.186
• US:
  • 143.244.210.106
  • 143.244.209.90

IP Whitelisting Guide

Using normal web servers

sudo ufw allow from 188.166.198.14
sudo ufw allow from 188.166.196.151

Using Amazon Web Services (AWS)

If your database is hosted on Amazon AWS, but not on a VPC, you can set up a security group and whitelist Holistics' IP addresses. See the UI below (remember to change the IP address to Holistics IP, with /32 as the suffix). E.g:12.12.12.12/32

(see Redshift Documentation here)