Skip to main content

PostgreSQL

Category: Direct connection

PostgreSQL relational database. Direct connection.

Connection requirements​

  • Host
  • Port
  • Database name
  • Username
  • Password

Where to find these​

These values come from your database administrator (DBA) or from the existing JDBC/ODBC connection string.

  • Host / Port — Host is the server name or IP address where PostgreSQL runs; Port is the database's listening port (default 5432). Found in the server configuration or available from your DBA.
  • Database name — The name of the specific database/schema you want to connect to (visible via \l in psql or from your DBA).
  • Username / Password — Preferably use a dedicated service account with read-only rights (least privilege) on the relevant database, rather than a personal or admin account.

Is the database behind a firewall or on-premises? Then an Integration Runtime is needed to establish the connection — see Connecting a data source.

Official documentation: PostgreSQL — Connection Strings

See also: Integration catalog · All data source requirements · Integrations — overview