Skip to main content

Oracle

The Oracle connector for Rudol allows you to connect your Oracle Autonomous Database.

Connection parameters​

NameTypeDescription
UsertextOracle user name
PasswordpasswordOracle user password
Connection StringtextOracle Database connection string

User permissions​

To grant Rudol the necessary permissions to fetch your database metadata we recommend you to create a new Oracle user with access restricted.

Here is a sample code to create a new user for Rudol with minimal permissions:

CREATE USER rudol_user IDENTIFIED BY StrongPassword123;

GRANT CREATE SESSION TO rudol_user;
GRANT SELECT ANY TABLE TO rudol_user;
GRANT SELECT_CATALOG_ROLE TO rudol_user;

This permissions allows Rudol user to:

  • Inspect the database structure to build your Data Catalog(SELECT_CATALOG_ROLE).
  • Query the database to execute Data Quality Validations(SELECT permission).
  • Create temporary tables to execute Data Quality Validations (CREATE SESSION).

How to find your Connection String?​

  1. Log in to your Oracle Cloud Console.
  2. Navigate to the “Autonomous Database” section.
  3. Select the Autonomous Database instance for which you want to retrieve the connection string.
  4. Find the section labeled Database Connection.
  5. You will see several connection strings listed; choose TLS authentication and copy one of the availables connection string.

Example Connection String​

Below is an example of what an Oracle connection string might look like: 

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=your_host)(PORT=your_port))(CONNECT_DATA=(SERVICE_NAME=your_service_name)))

Additional Notes​