PostgreSQL

Overview

Use this connector to extract metadata from PostgreSQL databases.

Create User & Grant Permissions

Run the following SQL commands to create a dedicated user and grant the required read-only permissions:

• CREATE USER connetra PASSWORD '<password>';
• GRANT CONNECT ON DATABASE <database_name> TO connetra;
• GRANT USAGE ON SCHEMA <schema_name> TO connetra;
• GRANT SELECT ON ALL TABLES IN SCHEMA <schema_name> TO connetra;
• ALTER DEFAULT PRIVILEGES IN SCHEMA <schema_name> GRANT SELECT ON TABLES TO connetra;

Connection Setup in Connetra

When adding a data connector in Connetra, provide the following details. When connecting to PostgreSQL in Connetra, use the username/password you’ve created here.

• Configuration name: A user-friendly label for this connection. It helps team members identify and select the connector within Connetra
• Host/server: The network address or domain name of the database server where your data is stored.
• Port: The communication port used to connect to the database
• User: The database account Connetra will use to connect and retrieve metadata. This user should have read-only permissions.
• Password: The password associated with the user account above, used to authenticate the connection.

Before you can save the data connector you must first test the connection.