Step 4 (RDS): How to connect Amazon RDS PostgreSQL as Data Warehouse Integration

This guide will explain how to connect your Amazon RDS Postgres instance to Blendo in order to send your data.

Not a database yet? Read how to setup an Amazon RDS Postgres Database

If you have problems connecting check again your access permissions by reading how to setup the Amazon RDS Postgres permissions in our documentation.  

It will take only a few minutes to connect and send your data to Amazon RDS Postgres. Blendo makes it easy to send your customer, product, transactional, marketing and sales data to any data warehouse like Google BigQuery, Amazon Redshift or MS SQL.

Add Blendo Output (Destination)

A Blendo Output is any destination that you want to send your data to.

Permissioning Blendo: In order to ensure Blendo will have access to your Amazon RDS Postgres please make sure to white list and allow connection from these two IP addresses: 52.18.126.160/32, and 52.213.36.20/32If you need help go here.

Add Amazon RDS PostgreSQL as Destination Output

1. Go to your Blendo Dashboard.

2. If it is the first time you login to Blendo you will see the screen bellow. Click on the box with Postgres.

ETL data into your data warehouse

If it is not the first time, you will see the screen bellow. Click the drop-down arrow and then click on Add database.

Load data into Google BigQuery

On the next screen, click on the box with Postgres.

3. Add your credentials to connect to Amazon RDS Postgres. Here is where you will need the settings from the Amazon RDS Console Instances visited earlier.

The Postgres Host is the Endpoint if you click the DB Instance in the RDS console. NOTE: You do not need to copy/paste the port part.

AWS RDS Postgres Setup

Get your Endpoint to use as Host

The Port is what you chose at the setup of your Postgres instance.

Postgres database is the name of your Postgres instance.

Username and Password of your Postgres instance.

If you want you may add a prefix for the tables that will be created.

4. Copy the relevant settings into the text fields on this page.

Send data to RDS postgres

6. Click Validate & Save.

Schema Selection

You can also select the Schema where the data will be stored to. This is something that is done during the setup of your data warehouse but instead during the creation of a pipeline. There you can select at which Schema the data from source will be stored at (with public schema as default).

Permissioning Blendo: In order to ensure Blendo will have access to your Amazon RDS Postgres please make sure to white list and allow connection from these two IP addresses: 52.18.126.160/32, and 52.213.36.20/32
If you need help go here.

Done that! Now What?

You may now connect data sources with it. Blendo will sync all your data from these data sources into your data warehouse.

Questions? Contact us!

in PostgreSQL