•  Introduction to Oracle Connector
  •  Oracle Connector assets
  •  Oracle Connector example
•  Connections for Oracle
  •  Prerequisites
    •  SSL configuration
    •  Kerberos authentication
  •  Connect to Oracle
    •  Before you begin
    •  Connection details
    •  Authentication types
    •  Advanced settings
    •  Related links
  •  Configuring SSL with the serverless runtime environment
  •  Oracle connection rules and guidelines
•  Synchronization tasks with Oracle Connector
  •  Oracle sources in synchronization tasks
  •  Oracle targets in synchronization tasks
    •  Configuring an update override for the target
  •  Advanced properties for Oracle sources and targets in synchronization tasks
  •  Oracle lookups in synchronization tasks
  •  Data filters
    •  Simple data filters
    •  Advanced data filters
  •  Rules and guidelines for data filters
•  Mappings and mapping tasks with Oracle Connector
  •  Oracle sources in mappings
  •  Key range partitioning
    •  Configuring key range partitioning
  •  Oracle targets in mappings
    •  Configuring an update override for the target
    •  Enabling array update and upsert operations for an Oracle target
  •  Oracle lookups in mapping
  •  SQL ELT optimization
    •  Full SQL ELT optimization
    •  Source SQL ELT optimization
    •  SQL ELT optimization functions
    •  Supported functions for Expression transformation
    •  Configuring SQL ELT optimization
    •  Cross-schema SQL ELT Optimization
  •  Rules and guidelines for Oracle sources and targets in tasks
•  Replication tasks
  •  Oracle sources in replication tasks
  •  Oracle targets in replication tasks
  •  Full load
  •  Rules and guidelines for Oracle sources and targets in replication tasks
•  Troubleshooting
  •  Troubleshooting an Oracle connection
  •  Troubleshooting a synchronization task
  •  Troubleshooting a replication task
•  Data type reference
  •  Oracle and transformation data types
    •  Rules and guidelines for data types

Introduction to Oracle Connector

Oracle and transformation data types

REL_ORACLE_CONN

REL_ORACLE_CONN-CONN_NAME

REL_ORACLE_CONN-CONN_DESC

REL_ORACLE_CONN-CONN_TYPE

REL_ORACLE_CONN-AGENTGROUPID

REL_ORACLE_CONN-ORACLESUBTYPE

REL_ORACLE_CONN-AUTHENTICATIONTYPE

REL_ORACLE_CONN-USERNAME

REL_ORACLE_CONN-PASSWORD

REL_ORACLE_CONN-HOST

REL_ORACLE_CONN-PORT

REL_ORACLE_CONN-DATABASE

REL_ORACLE_CONN-SCHEMA

REL_ORACLE_CONN-CODEPAGE

REL_ORACLE_CONN-ENCRYPTIONMETHOD

REL_ORACLE_CONN-CRYPTOPROTOCOLVERSION

REL_ORACLE_CONN-VALIDATESERVERCERTIFICATE

REL_ORACLE_CONN-TRUSTSTORE

REL_ORACLE_CONN-TRUSTSTOREPASSWORD

REL_ORACLE_CONN-HOSTNAMEINCERTIFICATE

REL_ORACLE_CONN-KEYSTORE

REL_ORACLE_CONN-KEYSTOREPASSWORD

REL_ORACLE_CONN-KEYPASSWORD

REL_ORACLE_CONN-CONNECTION_RETRY_PERIOD

REL_ORACLE_CONN-METADATA_ADVANCED_CONNECTION_PROPERTIES

REL_ORACLE_CONN-RUN-TIME_ADVANCED_CONNECTION_PROPERTIES