Adding a PostgreSQL Connector

Adding a PostgreSQL Connector

How to add a PostgreSQL Connector

1. Select Connectors from the left navigation to open the Connectors page.

Main menu in Popdock with Connectors highlighted.

2. Under Actions, select Add connector.

Connector settings menu with Add connector highlighted.

3. Select the PostgreSQL Connector from the list of connectors.

4. On the Add connector – PostgreSQL page, use the available fields to enter in the appropriate information regarding your PostgreSQL database.

Server – The hostname of the PostgreSQL server. Following the Server name, add a comma and the port the PostgreSQL database listens on. By default, this is port 5432. For example, YourPostgreSQLServer,5432

Database – The name of the PostgreSQL system database.

Username – A PostgreSQL user with read access to the system database.

Password – The password for the PostgreSQL user.

Add connector - PostgreSQL settings.

5. After you have entered the information, select Validate under the left Actions menu.

Action menu with Validate highlighted.

6. After the validation has completed, select Connect.

Actions menu with Connect highlighted.

7. You will be directed to the Select lists page. Check the box to the left of the individual lists to select your lists or you can check Select all to select all the lists from within the PostgreSQL database. After you have selected your lists, select Add lists.

Select lists screen showing the available lists.  Select All is checked and all lists have checkmarks next to them.

8. You will be taken to the list of your connectors where your PostgreSQL connector will begin installing with the lists you added. After this has completed, your PostgreSQL connector will be available within your list of connectors and available to use.

Connectors screen showing the PostgreSQL connector added.

Having trouble adding this connector? Email support at support@eonesolutions.com

Content
How to add a PostgreSQL Connector

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

Reset Filters