Skip to main content

Connecting to PostgresSQL

Promethium integrates with PostgresSQL to enable metadata discovery and distributed querying. Once connected, Promethium will crawl PostgresSQL schemas, tables, and columns, and make them available for query and exploration. Data can also be materialized to PostgresSQL if required.

This guide walks you through the steps to securely connect your Oracle account to Promethium using read-only access.

Prerequisites​

To connect PostgresSQL to Promethium, you’ll need the following:

  • Host Name The hostname for your PostgresSQL database. For example: db.company.com
  • DB Port Enter the port number that PostgresSQL communicates on
  • User Name The username associated with your PostgresSQL account
  • Password The password associated with your PostgresSQL account
  • Database Name The database containing the data you want to access