Generic PostgreSQL: Permissioning Blendo

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.

Generic PostgreSQL permissions

There may be the case that you host PostgreSQL in a different service than AWS or Azure, In that case you will still need to configure your firewall ports or access rules to allow Blendo to write into it. f

Allow incoming connections from:

• 52.18.126.160. In case you need the CIDR version then you may add: 52.18.126.160/32.
• 52.213.36.20/32. In case you need the CIDR version then you may add: 52.213.36.20/32.

Add Generic 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 below. Click on the box with Postgres.

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

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

3. Add your credentials to connect to your Postgres. 

• The Postgres Host is the Host Endpoint.
• The Port is the port 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.

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).