Step 3 (RDS): Permissioning Blendo to Amazon RDS

This guide considers that you already have a PosgreSQL instance setup in Amazon RDS. Let’s set up our Amazon RDS permissions for PostgreSQL.

Permissioning Blendo: In order to ensure Blendo will have access to your PostgreSQL please make sure to white list and allow connection from the following IP addresses: 52.18.126.160/32, and 52.213.36.20/32
For more instructions please continue bellow.

Amazon RDS permissions

Let’s see how to setup Amazon RDS permissions to allow Blendo to write into your PostgreSQL instance. You will need to configure Amazon RDS to allow Blendo to write into it. We will have to add two (2) rules.

1. Go to your Amazon RDS console, at the Instances tab.

2. Find your Instance and click on the arrow in front of it. Then click on the magnifying glass and then click on your Security Group.

Amazon RDS permissions

 

3. Then you will get to a page to configure your security group and click on Inbound tab.

Setup security group in Amazon RDS

4. It will show you a page like the following.

Setup Inbound connections in Amazon RDS

Setup Inbound connections in Amazon RDS

5. Click on Edit. This will get you add a new Inbound rule.

Setup Inbound rule in Amazon RDS

Setup Inbound rule in Amazon RDS

6. In the Type drop-down select PostgreSQL. At Source type 52.18.126.160. In case you need the CIDR version then you may add: 52.18.126.160/32.

7. Click Save.

8. Let’s add rules for the rest of the IP addresses. Repeat steps 5,6 for the following IP addresses:

  • 52.213.36.20/32

9. Click Save.

Next Steps:

With Amazon RDS permissions done, Blendo will be able to connect and send your data to the PostgreSQL  instance.

READ NEXT: Step 4: How to connect Amazon RDS PostgreSQL as Data Warehouse Integration

Questions? Contact us!

in PostgreSQL