Authorize FlyData on Amazon Redshift

First, you will need to provide information to FlyData regarding your Amazon Redshift account for the two systems to be able to interact. This will require you also to change the security settings on Amazon Redshift to authorize FlyData. This is particularly necessary for FlyData to be able to upload data to your Amazon Redshift cluster.

The IP addresses shown on FlyData Settings will be used to connect to your cluster.

You will have to provide these IP addresses so that FlyData’s servers can access to your cluster’s endpoint. How this is set, though, depends on whether you’re using Amazon’s Virtual Private Cloud. You can accomplish this by doing one of the following, whichever one applies to your situation.

With Virtual Private Cloud (VPC)

If you are using Amazon’s Virtual Private Cloud, you will need first to identify the security group to which you would like to add the FlyData IP addresses. On your Amazon Redshift Cluster AWS Console, select the VPC Dashboard, then the link labeled VPC Security Groups. When there, search for the security group by entering its group ID in the search box (e.g., sg-8cde8f18). When you locate it, click on the box to the left of it to highlight. That will show you the details for that security group, as shown in the screenshot below:

Next you will need to authorize the FlyData IP addresses. Click on the Inbound Rules tab in the middle of the page for the selected security group, and then the Edit button. A dialog box will open: click on Edit Inbound Rules in that box and then on Add Rule to add the first IP address, and again to add another when done with the first. Set the parameters for these two rules as follows:

Type: Custom TCP Rule

Port Range: port

Source: [IP Addresses on FlyData Settings Page]

The type is the same for both rules. For the port range, you would use your Amazon Redshift Cluster (e.g., 5439). For the source enter the first IP address for the first rule and the second address for the second rule. When you’re finished, click Save.

That’s all you need to do at this stage to authorize FlyData access to your cluster. Skip to the section below called, Preparing MySQL.

Without Virtual Private Cloud(VPC)

If you’re not using Amazon’s Virtual Private Cloud, you will still need to register FlyData’s IP addresses with Amazon Redshift. To do this, go to your Amazon Redshift Cluster AWS Console page, and click on the Security Groups table. Then select the security group specified as the Cluster Security Groups. At this point you will be able to enter the needed parameters (see screenshot below).

Set the parameters for the two IP addresses as follows, clicking Authorize after adding the first IP address, and again to add the second:

Connection Type: CIDR/IP

CIDR/IP to Authorize: [IP Addresses on FlyData Settings Page]

That’s all you need to do at this stage to grant FlyData access to your Amazon Redshift cluster.