•  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 modes
    •  Advanced settings
  •  Oracle connection rules and guidelines
•  Mappings and mapping tasks with Oracle Connector
  •  Oracle sources in mappings
  •  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
  •  Rules and guidelines for Oracle sources in tasks
•  Troubleshooting
  •  Troubleshooting an Oracle connection
•  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-AUTHENTICATIONTYPE-NATIVE

REL_ORACLE_CONN-USERNAME

REL_ORACLE_CONN-NATIVE-USERNAME

REL_ORACLE_CONN-PASSWORD

REL_ORACLE_CONN-NATIVE-PASSWORD

REL_ORACLE_CONN-AUTHENTICATIONTYPE-KERBEROS

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