Oracle Database Integration

Connect TDK to Oracle databases for data masking, generation, and subsetting.

Overview

TDK supports:

  • Oracle Database 11g, 12c, 18c, 19c, 21c

  • Oracle Autonomous Database

  • Amazon RDS for Oracle

Connection Configuration

data_sources:
  input:
    url: jdbc:oracle:thin:@//localhost:1521/ORCL
    username: tdk_user
    password: ${vault:secret/oracle#password}
    driver_class_name: oracle.jdbc.OracleDriver

TNS Names Configuration

Alternative using TNS:

data_sources:
  input:
    url: jdbc:oracle:thin:@mydb_tns
    username: tdk_user
    password: ${vault:secret/oracle#password}
    tns_admin: /path/to/tnsnames.ora

Required Permissions

-- Read-only (recommended for source)
GRANT CONNECT TO tdk_user;
GRANT SELECT ANY TABLE TO tdk_user;

-- Read-write (for target database)
GRANT CONNECT, RESOURCE TO tdk_user;
GRANT CREATE TABLE TO tdk_user;
GRANT UNLIMITED TABLESPACE TO tdk_user;

Oracle-Specific Considerations

Character Sets

Ensure UTF-8 compatibility: * Database: AL32UTF8 * National Character Set: AL16UTF16

Large Objects

TDK supports: * CLOB * BLOB * NCLOB

See Also