Creating a PostgreSQL Connection
You must create a PostgreSQL connection before you can use this connector. Use the PostgreSQL connection to connect to the PostgreSQL, Redshift, or Greenplum database. This connection is used by all the activities in the PostgreSQL category.
Note: By default, the
PostgreSQL and Greenplum databases listen for connections on port 5432 and Redshift database on port 5439, although that is configurable as the port is the connection property on the
PostgreSQL Connector.
- Procedure
- On the global navigation bar, click the
Connections and perform one of the following actions:
- To add a connection for the first time, click the Create connection link and then select the PostgreSQL Connector card. You can search for a connector by typing the connector name in the search field.
- To create subsequent connections, click the Create button.
- In the PostgreSQL Connector dialog box, enter the connection details. For field descriptions, see PostgreSQL Connection Details.
- Click Save Connection.
Subtopics