Allow Inbound Access

In order for Etleap to load data to your Redshift cluster, the cluster must allow inbound access for Etleap. If you have an account in Etleap’s hosted environment, the easiest way to setup the access is to allow connections from the Etleap IP addresses. This article explains how to do so.

This article does not cover other options such as running Etleap in your own VPC environment or using VPC peering or SSH tunnels. Contact Etleap Support for guidance for those setups.

Prerequisites

To allow Etleap access to Redshift, you must have:

an existing Redshift cluster
an IAM role that has the AuthorizeSecurityGroupIngress permission on the Redshift cluster.

Set Inbound Firewall Rules

Step 1. Expose Cluster

1.1 From your AWS Redshift Console , select the cluster you wish to expose from the Cluster overview tab

1.2 Select the Properties tab for your cluster

1.3 From your cluster’s property management page, scroll down to the Network and security settings tab select Edit publicly accessible

1.4 Enable and Save

Leave Elastic IP address as None

Step 2. Edit Security Group

Warning

To set up allowed inbound connections, you will update your cluster’s security group. In Amazon Redshift, one security group may be associated with many clusters. Ensure you wish to make global changes or define a new security group and associate it with your cluster before proceeding.

2.1 From your cluster’s Network and security settings tab, select the VPC security group you wish to update

2.2 From the drop-down menu Actions, select Edit inbound rules

2.3 The Edit inbound rules form offers various options:

Note

Customize these settings to suit your requirements; at a minimum, enter the IP addresses as shown below:

Type: Redshift
Leave as default
- Protocol
- Port
(Optional) Description
Source
- Leave as Custom
- Enter the appropriate IP address from the IP Whitelisting article

2.4 Click Save rules

Congratulations! Etleap now has access to your Redshift Cluster.

Next Steps

Add Etleap as a user on your AWS database.

Create a connection from Etleap to your Redshift Cluster.

For further assistance, see the AWS documentation or contact Etleap Support.