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.

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

  • Step 4: Click "Next"

  • 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"

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

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

Last updated

© DNAstack. All rights reserved.