Skip to main content

Connecting to Oracle

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

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

Prerequisites​

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

  • Host Name The hostname for your Oracle database. For example: db.company.com
  • DB Port Enter the port number that Oracle communicates on
  • User Name The username associated with your Oracle account
  • Password The password associated with your Oracle account