Connecting to PostgreSQL

This section contains details for PostgreSQL connections.

General information

FieldDescription
Data sourcePostgreSQL
Supported versions42.5.1
Connection stringjdbc:postgresql://
Packaged?

Yes

Certified?

Yes

Supported features
Estimate job

Yes

Analyze data

Yes

Schedule

Yes

Processing capabilities
Pushdown

No

Spark agent

Yes

Yarn agent

Yes

Parallel JDBC

Yes

Java Platform version compatibility
JDK 8

Yes

JDK 11

Yes

Minimum user permissions

In order to bring your PostgreSQL data into Collibra Data Quality & Observability, you need the following permissions.

  • Read access on your PostgreSQL database tables.
  • ROLE_ADMIN assigned to your user in Collibra DQ.

Recommended and required connection properties

RequiredConnection PropertyTypeValue

Yes

NameTextThe unique name of your connection. Ensure that there are no spaces in your connection name.

Yes

Connection URLString

The connection string path of your PostgreSQL connection.

When referring to the example below, replace the ${value} sections of the connection URL with your actual value.

Example jdbc:postgresql://${host}/template1

Yes

Driver NameString

The driver class name of your PostgreSQL connection.

org.postgresql.Driver

Yes

PortInteger

The port number to establish a connection to the datasource.

The default port is 5432

No

Source NameStringN/A

No

Target AgentOptionThe Agent that submits your Spark job for processing.

Yes

Auth TypeOption

The method to authenticate your connection.

Note The configuration requirements are different depending on the Auth Type you select. See Authentication for more details on available authentication types.

No

PropertiesString

The configurable driver properties for your connection. Multiple properties must be comma delimited. For example, abc=123,test=true

Authentication

Select an authentication type from the dropdown menu. The options available in the dropdown menu are the currently supported authentication types for this data source.

RequiredFieldDescription

Yes

UsernameThe username of your PostgreSQL account.

Yes

PasswordThe password of your PostgreSQL account.

Yes

Script

The file path that contains the script file that the password manager uses to interact with and authenticate a user account.

Example /tmp/keytab/postgresql_pwd_mgr.sh

No

Param $1Optional. An additional parameter to authenticate your PostgreSQL connection.

No

Param $2Optional. An additional parameter to authenticate your PostgreSQL connection.

No

Param $3Optional. An additional parameter to authenticate your PostgreSQL connection.