1. Help Center
  2. Getting started

Connect Amazon Redshift to DataRow Using Proxy

DataRow can connect to your Amazon Redshift database even it’s behind a firewall or publicly not available.

First, create an Amazon EC2 in your private network. Use our installer to install proxy service ( HAProxy ) and assign a security group to all.

  1. Open the Amazon EC2 console at console.aws.amazon.com/ec2.
  2. Allocate an Elastic IP. For more information see AWS User Guide.
  3. Create a security group with the DataRow inbound rules. See AWS User Guide for more information.
  4. Launch an instance into your VPC where your Amazon Redshift instance is located.
  5. Assign the security group that you've created, and the Elastic IP you've allocated to the instance.
  6. Connect to your Linux instance using SSH that you've launched. See Connecting to Your Linux Instance Using SSH for more information.
  7. Install DataRow Proxy (HAProxy).
  8. Add connection on DataRow entering the Elastic IP (the public IP of your Instance) to the host input.

DataRow inbound rules

Type: Redshift

Protocol: TCP

Port Range: 80

Source: 3.86.119.54/32 and 50.19.197.58/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 allow 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.

Installing DataRow Proxy (HAProxy)

Use the command below:

wget https://s3.amazonaws.com/com.datarow.files/install.sh
chmod +x install.sh
sudo ./install.sh your-redshift-instance-host

Add a new connection

Add connection on DataRow entering the Elastic IP (the public IP of your Instance) to the host input, and make sure that the port number is 80.