Configuring the Oracle Advanced Security Options in an Oracle Connection in Cloud Data Integration

Configuring the Oracle Advanced Security Options in an Oracle Connection in Cloud Data Integration

Create an Oracle Connection in Cloud Data Integration

Create an Oracle Connection in Cloud Data Integration

Create an Oracle connection and configure the required Oracle properties, including the Oracle advanced security options in Cloud Data Integration.
  1. On the
    Connections
    page in Data Integration, click
    New Connection
    .
    The
    New Connection
    page appears.
  2. Configure the connection properties.
    The following table describes the connection properties that you must configure:
    Property
    Description
    Connection Name
    Name of the Oracle connection.
    Description
    Description of the connection.
    Type
    Type of the connection.
    Select the type of the connection as
    Oracle
    .
  3. Configure the Oracle connection properties:
    The following table describes the Oracle connection properties that you must configure:
    Connection property
    Description
    Runtime Environment
    Runtime environment that contains the Secure Agent used to access Oracle.
    User Name
    User name for the database login. The user name cannot contain a semicolon.
    Password
    Password for the database login. The password cannot contain a semicolon.
    Host
    Name of the machine that hosts the database server.
    Port
    Network port number used to connect to the database server. Default is 1521.
    Service Name
    Service name or System ID (SID) that uniquely identifies the Oracle database.
    Specify the SID in the following format to connect to Oracle databases:
    SID:<ORACLE_SID>
    Schema
    Schema used for the Oracle connection.
    Code Page
    The code page of the database server.
    Encryption Method
    The method that the Secure Agent uses to encrypt the data exchanged between the Secure Agent and the database server.
    Crypto Protocol Version
    Cryptographic protocols to use when you enable SSL encryption.
    Validate Server Certificate
    Validates the certificate that is sent by the database server. If you specify the
    HostNameInCertificate
    parameter, Secure Agent also validates the host name in the certificate.
    Trust Store
    The location and name of the trust store file.
    Trust Store Password
    The password to access the contents of the trust store file.
    Host Name in Certificate
    Host name of the machine that hosts the secure database.
    If you specify a host name, the Secure Agent validates the host name included in the connection with the host name in the SSL certificate.
    Key Store
    The location and the file name of the key store.
    Key Store Password
    The password for the key store file required for secure communication.
    Key Password
    The password for the individual keys in the key store file required for secure communication.
    Connection Retry Period
    Number of seconds the Secure Agent attempts to reconnect to the Oracle database if the connection fails. If the Secure Agent cannot connect to the database in the retry period, the operation fails.
    Used for all operations. Default is 0.
    Metadata Advanced Connection Properties
    The optional properties for the JDBC driver to fetch the metadata. If you specify more than one property, separate each key-value pair with a semicolon.
    To connect to an Oracle database enabled for advanced security, specify the advanced security encryption options.
    Runtime Advanced Connection Properties
    The optional properties for the ODBC driver for running mappings. If you specify more than one property, separate each key-value pair with a semicolon.
    To connect to an Oracle database enabled for advanced security, specify the advanced security encryption options.


Updated August 20, 2020