IP Whitelisting
If you're using Direct Connection method, you might need to whitelist Holistics' IP addresses in order to connect properly.
warning
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 (click New Data Source to open the form). They are:
- 188.166.198.14
- 188.166.196.151
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)