Your connection details will be encrypted in KAWA’s database and will be decrypted only to import data from your bases when an ETL runs (Manual trigger on the GUI or according to your schedule). It is NOT accessible to KAWA support team.
1. Create a PostegreSQL user
We strongly advise creating a dedicated user for KAWA to enhance tracking of usage and performance metrics with appropriate permissions. To set up this user, please refer to the following resources:
Creating a User Account:
Follow the instructions provided in the PostgreSQL documentation at this link: Create User in PostgreSQL.
Assigning Appropriate Roles:
Grant the necessary roles to the user to enable querying of your analytics data. Detailed guidance can be found here: Role Membership in PostgreSQL.
2. Configure the provider on KAWA
In the data source section:
- Click on “+” button and choose: “Connect to an external system” (#1 on schema)
- Then, click on “+ Connector ” button next to the data import section (#2 on schema)
- Pick the PostegreSQL provider (#3 on schema)
- Enter the required connection details for your PostgreSQL database:
- Hostname or IP address of the PostgreSQL server.
- Port number (default is 5432).
- Username and password for database access.
- Database name (the name of the PostgreSQL database you want to connect to).
Click on Test Connection then Create.