Creating a PostgreSQL Connection

You must create a PostgreSQL connection before you can use this connector. The PostgreSQL connection contains all the parameters required to connect to the PostgreSQL database. This connection is used by all the activities in the PostgreSQL category.

Note: By default, the PostgreSQL database listens for connections on port 5432, although that is configurable as port is the connection property on the PostgreSQL Connector.

To create a PostgreSQL connection, perform the following steps:

  1. Click the Connections tab and perform one of the following actions:
    • To add a connection for the first time, click the PostgreSQL Connector card. You can search for a connector by typing the connector name in the search field.
    • If you have existing connections and want to add a new connection, click the Add Connection link.
  2. In the PostgreSQL Connector dialog box, enter the connection details. For field descriptions, see PostgreSQL Connection Details.
  3. Click Save Connection.
Related concepts
Related reference