DataRow can connect to your Amazon Redshift database even it’s behind a firewall or publicly not available. Just create an Amazon EC2 in your private network, use our installer to install proxy service ( HAProxy ) and assign a security group that allows inbound requests from DataRow Public IPs.
1- Allocate an Elastic IP. See “Allocating an Elastic IP Address” for more information.
2- Create a security group and add following inbound rules:
|Redshift||TCP||5439||184.108.40.206/32||DataRow Public IP|
|Redshift||TCP||5439||220.127.116.11/32||DataRow Public IP|
See “Creating a Security Group” for more information.
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: 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.
3- Launch an Instance into your VPC that your Amazon Redshift Instance is located. Assign the security group that you created, and the Elastic IP you allocated to the Instance.
4- Connect to your Linux Instance using SSH you launched. See Connecting to Your Linux Instance Using SSH for more information.
5- Install DataRow Proxy (HAProxy)
wget https://s3.amazonaws.com/com.datarow.files/install.sh chmod +x install.sh sudo ./install.sh your-redshift-instance-host
6- Add your connection; enter the Elastic IP (the public IP of your Instance) to the host input.