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.
In this article, we will show how to register a PostgreSQL database as a destination on the Kondado platform.
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;”)
Add PostgreSQL as a Data Destination on Kondado
Register a PostgreSQL database as a destination on the Kondado platform to store your integrated data.
Whitelist Kondado IPs on your database server
Before adding PostgreSQL, ensure your database username and server are accessible to Kondado's IPs. Check the IP list in the article and configure your firewall rules accordingly.
Navigate to the destinations page on Kondado
On the Kondado platform, go to the add new destinations page and select the PostgreSQL data destination to begin registration.
Enter your database connection details
Fill in the required fields: Name (internal description), Address (IP or DNS), Port (usually 5432), Database name, User with DROP/INSERT/CREATE/ALTER/SELECT/DELETE permissions, Password, and Schema (default is "public").
Save and verify your new destination
Click save to create your destination. Kondado will attempt to create the specified schema; if permissions are insufficient, the public schema will be used. Ensure your user has proper schema permissions as noted in the article.
Connect to your visualization tool
After setting up PostgreSQL as a destination, you can connect it to your preferred BI tool. See options like Looker Studio or explore other data visualization integrations.
