PostgreSQL is one of the most well-known systems for managing relational databases. The data integration from PostgreSQL to the Data Warehouse created by Kondado allows you to access PostgreSQL data in your analytical cloud.

Adding the data source

To automate the ETL from PostgreSQL with Kondado to your database, follow the steps below:

1. Whitelist the Kondado IPs on the database server (and on your VPC) for the port that will be used to connect with PostgreSQL
2. Have the address, port, database, user and password data to access your bank at hand
3. On the Kondado platform, go to the page to add data sources and select the PostgreSQL data source
4. Give a name to your data source and enter the information from step (2)

The value provided in the "schema" parameter will only serve as a reference. We will consider all existing schemas when listing and integrating the tables and views of the data source.

Now just save the data source and start integrating your PostgreSQL data into the Data Lake or Data Warehouse.

Tables and Views

With our integration, you will be able to integrate tables and also views

If your table has a datetime/timestamp type column that marks when a record was changed/inserted, your integration can be incremental

It will be necessary to define the primary key, which can be defined by several columns and refers to the column (or set of columns) that define a record as being unique

The table created will have a similar format to the one below:

Field   Type
col_x   text
col_y   date
col_z   float