PostgreSQL

PostgreSQL is the most efficient general purpose database for creating Data Warehouses and Data Lakes due to its efficiency in complex joins and high availability during insertions of high volumes of information.

Click here to access the tutorial on how to connect to your visualization tool:
Looker Studio
Power BI

In this article, we will show how to register a PostgreSQL database as a destination on the Kondado platform.

Before adding the database, make sure that the database's username and server are accessible to our IPs that are listed here and then follow the steps below:

1) On the Kondado platform, go to the add new destinations page and select the PostgreSQL data destination

2) Fill in your database information as shown below:

Name: This is the internal description of your destination on the Kondado platform
Address: Your database server address (IP or DNS)
Port: Your database port (usually 5432)
Database: the name of the database
User: the username that Kondado will use to enter data into your database. This user must have permissions to DROP, INSERT, CREATE, ALTER, SELECT and DELETE tables and schemas
Password: the user's password
Schema: inform a schema or leave the default “public” [1]

Click save and your new destination will be created!

[1] Kondado will try to create the schema with the value informed in the “schema” parameter and if this is not possible (for example, due to lack of permission), the public schema will be used. Even if the schema already exists, Kondado must have permission to create schemas (“GRANT CREATE ON DATABASE db TO user”) if you do not want to use the public schema. For existing schemas, it is also important that the user registered at Kondado has permission to use the schema (“GRANT USAGE ON SCHEMA schema_name TO user;”)