Requirements
Your Redshift cluster must allow inbound traffic from our Authorized Static IP Addresses. You can maintain a 'Deny All' firewall policy and only grant access to our specific IPs to ensure the connection remains private and secure
Create unique Redshift credentials, using password authentication for Vitally's access to the database and grant the user permission to the required tables.
Safe-list Vitally's Authorized IP address in any relevant security groups:
For US-hosted Vitally customers: 52.2.105.119, 34.198.95.164, 54.225.45.200, 3.233.54.92, 44.197.82.135, 44.205.137.47, 3.231.135.245, 34.234.2.125, 18.117.45.34, 18.118.174.158, 3.128.104.4, 3.128.39.40, 3.137.39.224, 3.20.73.62
For EU-hosted Vitally customers: 13.50.117.250, 13.48.176.93, 13.48.142.17, 13.53.227.107, 16.171.90.148, 16.170.120.57, 16.171.215.121, 16.171.156.82
Step 1 - Connect
We'll need these values to connect to your Redshift warehouse:
Host: The public hostname of your Redshift cluster, which you can find under 'connection details' in the AWS Redshift console.
Port: The port your Redshift cluster is configured to use. By default, it is 5439.
Database: The name of the database that you want to connect to (e.g. production).
Username: A unique Redshift user that you've created for Vitally.
Password: That user's password.
Step 2 - Configure Sync