Create a connection for Oracle
Create a connection for Oracle as follows:
- From the drop-down list, select the application to be extracted.
- 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.
- 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.
-
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.