PostgreSQL

PostgreSQL is an advanced, enterprise class open source relational database that supports both SQL (relational) and JSON (non-relational) querying. It is a highly stable database management system, backed by more than 20 years of community development which has contributed to its high levels of resilience, integrity, and correctness.

What is required

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.

How to connect PostgreSQL

Follow the steps for adding a Data Source to open the new data source dialog and choose PostgreSQL from the list of available connectors.

You will be presented with the screen to configure your PostgreSQL connector:

To configure the connector:

1. Enter your PostgreSQL username and password.
2. Enter the host name, port number, and the database name.
3. Set TLS to on if required.