Oracle connector

Oracle Database (also known as Oracle RDBMS) is a multi-model relational database management system developed and marketed by Oracle Corporation.

Supported platforms

  • Unix

  • Linux

  • Widows

  • AWS RDS

  • OCI DBaaS on Bare Metal

  • OCI DBaaS on VM

Supported versions

  • 11.2

  • 12c

  • 12cR

  • 18c

  • 19c

  • 21c

Supported features

Mode

Feature

Availability
Security

TLS/SSL

Available

Password Vault

Available

Kerberos

Available
In-place masking

Multi-tenant

Available

Streams/Threads

Available

Batch Update

Available

Drop Indexes

Available

Disable Triggers

Available

Disable Constraints

Available

Identity Column Support

Available
On-the-fly masking

Truncate

Available

Disable Triggers

Available

Disable Constraints

Available
Profiling

Multi-tenant

Available

Streams

Available

TLS/SSL setup instructions

To enable TLS/SSL connectivity with an Oracle connector:

  1. Add the database’s certificate to the setup application. Follow instructions in the Adding a Certificate section under the TrustStore settings page.

  2. Restart the Delphix Continuous Compliance engine.

  3. Create an Oracle connector in Continuous Compliance Engine with JDBC URL, similar to below examples, depending upon the Oracle database and certificate configuration.

    SSL connection with BASIC Oracle connector is not supported.
    jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=servername)(PORT=2484))(CONNECT_DATA=(SERVICE_NAME=servicename)))
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=servername)(PORT=2484))(CONNECT_DATA=(SID=SID_NAME)))
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=servername)(PORT=2484))(CONNECT_DATA=(SID=SID_NAME))(SECURITY=(SSL_SERVER_CERT_DN="CN=<certificate cn_name>")))