PostgreSQL

How to Add a PostgreSQL Connector

1. Access Connectors Page

- Go to the application menu and navigate to the Connectors section.

2. Configure Connection

- Click the button to add a new connection.

3. Enter Connection Details

- Connection Name: Provide a name for the connection, e.g., PostgreSQL.

- Host: Enter the host IP or server name. Example: tabula-stage.cluster-cxgn5xpb8h.

- Port: Specify the port, usually 5432.

4. Authentication

- User Name: Enter your PostgreSQL user name.

- Password: Enter the corresponding password.

5. Database Information

- Database: Enter the database name you wish to use. Example: dev_env.

- Schema (Optional): Provide a schema if needed. You can leave it empty and select a schema later.

6. Test Connection

- Click the Test connection button to ensure all details are correct and the connection can be established.

7. Save Configuration

- Once the test is successful, click the Save and test button to save your connector settings.

8. FAQs and Troubleshooting

- Make sure your host allows connections from your local IP.

- Verify that the database user has the necessary privileges: SELECT, USAGE, CONNECT.

- If the schema field is left empty, a default will be used but can be changed later.

By following these steps, you will successfully add and configure a PostgreSQL connector within your application.