The Oracle connector allows data to be cataloged, queried, transformed and to create tables in Oracle. This can be used to quickly and easily join data between different systems like Oracle and Hive, or between different Oracle instances.

The Oracle connector is available for all Promethium editions, including Free, Professional, Premium and Enterprise.

Connect Oracle

Connecting to Oracle is fast and easy. Simply click Data Sources from the menu, then click + New Data Source. Select Oracle and enter the information for your Oracle.

Oracle Connection

Oracle connection details can be case-sensitive. Ensure that data is entered with the correct case for your Oracle.

Field

Description

Data Source Name

Give the Oracle connection a unique name for easy identification.

Description

Optional. A meaningful description for this connection.

Host Name

Enter the host name for your Oracle database. For example: db.company.com

DB Port

Enter the port number for your Oracle database.

SID

A unique name that uniquely identifies the database instance.

User Name

Enter the username associated with your Oracle account.

Password

Enter the password associated with your Oracle account.

Data Source Topic

Optional. Categorize the Oracle connection. For example, Marketing.

What Happens Next - Finish Oracle Connection

Click the Connect button then select schemas. After successful connection and schema selection Promethium will automatically crawl and catalog data in your Oracle, then make the data easily searchable and usable.

Click Data Explorer from the menu and begin exploring the data in your Oracle database.

Oracle Data Catalog Promethium

FAQs

  • Is my data moved or copied out of Oracle?

    No. Your data stays in Oracle and isn't moved to Promethium.

  • What options are available for publishing datasets?

    Datasets can be published as a view, as a table in Oracle or as a dbt model.

  • Is this a Production-level connector?

    Yes. The Oracle connector is designed for all-sized Datasets.

Watch how to video


Did this answer your question?