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 the Promethium Enterprise edition. The Oracle connector is currently not available for the Free or Professional editions.
If you don't have a Promethium account, get your free account now
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 details can be case-sensitive. Ensure that data is entered with the correct case for your Oracle.
|
Field |
Description |
|
Data Source Name |
Give the MySQL connection a unique name for easy identification. |
|
Description |
Optional. A meaningful description for this connection. |
|
Data Source Topic |
Optional. Categorize the MySQL connection. For example, Marketing. |
|
Host Name |
Enter the host name for your MySQL database. For example: db.company.com |
|
DB Port |
Enter the port number for your MySQL database. |
|
SID |
A unique name that uniquely identifies the database instance. |
|
User Name |
Enter the username associated with your MySQL account. |
|
Password |
Enter the password associated with your MySQL account. |
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 Data Cloud.
No. Your data stays in Oracle and isn't moved to Promethium.
Datasets can be published as a view, as a table in Oracle or as a dbt model.
Yes. The Oracle connector is designed for all-sized Datasets.