First, create an Amazon EC2 in your private network. Use our installer to install proxy service ( HAProxy ) and assign a security group to all.
Port Range: 5439
Source: 18.104.22.168/32 and 22.214.171.124/32
Description: DataRow Public IP
Don’t forget to update security group of your Amazon Redshift cluster to give inbound/outbound access to the EC2 that you just created.
Important Note: If your VPC’s Network ACL rules allows inbound/outbound connections from only specific IP addresses, you should add DataRow public IP addresses to the network ACL too, otherwise you won’t able to connect to your Amazon Redshift cluster from DataRow.
Use the command below:
chmod +x install.sh
sudo ./install.sh your-redshift-instance-host
Add connection on DataRow entering the Elastic IP (the public IP of your Instance) to the host input. See also How to create a new connection on DataRow.