Connecting to PostgreSQL

PostgreSQL is an advanced, enterprise class open source relational database that supports both SQL (relational) and JSON (non-relational) querying.

• Step 1: Navigate to your instance of Publisher and select menu "Data Sources" in the side navigation bar.

• Step 2: On the Data Sources page, click "Connect Data Source" button.

connect to aws s3 storage - step 2.jpeg

• Step 3: Click on the "PostgreSQL Database" option.

connect to postgreSQL - step 3.jpeg

• Step 4: Click "Next"

connect to postgreSQL - step 4.png

• Step 5: You will require the following in order to create a connection to PostgreSQL:

  1. Your PostgreSQL database username.

  2. Your PostgreSQL database password.

  3. The host name for the database.

  4. The port number of the database.

  5. The name of the database.

• Step 6: Type username, password, hostname, port number, database name. Set TLS on if required. Click "Next"

connect to postgreSQL - step 6.png

• Step 7: Type a name for the data source and click "Done"

screen shot 2022-09-28 at 1.41.53 Pm.Png

• Step 8: Once the data source has been connected, you may optionally publish a collection containing the data on Networks by clicking "Share Collection"

advanced sharing settings.jpg