Create a connection for Oracle

Create a connection for Oracle as follows:

  1. From the drop-down list, select the application to be extracted.
  2. From the drop-down list, select the required Insight . Insights must be installed first on the IRC Portable Data Extractor before they can be viewed in the drop-down list.
  3. Provide the connection information to be used by the adapter. Unless the connection information is correct, connection creation will fail and an error message will be displayed.
  4. Click Next to save your changes and go to the next screen.
    The connection parameters for Oracle are as follows:
    FIELD DESCRIPTION
    Connection Name

    Provide a user defined connection name. This could be a combination of company name, the instance, (DEV, TEST, or PROD), and the Insight used, that is, Authorizations Insight (AI) or System Configuration Insight (SCI). For example, Approva PROD AI.

    Protocol

    Specify the Transmission Control Protocol (TCP).

    Host

    Provide the name of the machine or server where the application is installed. For example, server1.

    Port

    This is the port number in your tnsnames.ora file for sqlnet connections. For example, 1521.

    TNS Alias

    Provide the name that identifies the database, for example, proddb1.

    Note:  The service name or TNS Alias is defined during the database creation. It is a logical representation of a database. The service name comprises the database name and the domain name provided during the installation or database creation. If you are not sure what the global database name is, you can obtain it from the value of the SERVICE_NAMES parameter in the initialization parameter file.
    Connection Language

    Select the language for data extraction.