Script based extraction for Oracle for CDM

The configuration parameters for script-based extraction for Oracle for CDM are as follows:

FIELD DESCRIPTION
Project Name

Provide a unique name to identify the project. If a project with the same name already exists in the IRC Portable Data Scheduler, an message is displayed.

Script Path

Click Browse to search for the folder containing:

  • EXTRACTSCRIPT_ORCL12_ORACLE.cmd script file on the local machine for Oracle v12. Select this file as it is used to extract data from the Oracle v 12 database. The XI_ALL_ORCL12_ORACLEDB_EXT.sql must also be contained in this folder.
  • EXTRACTSCRIPT_ORCL11_ORACLE.cmd script file on the local machine, for Oracle v11. Select this file as it is used to extract data from the Oracle v11 database. The XI_ALL_ORCL11_ORACLEDB_EXT.SQL must also be contained in this folder.
User Name and Password

Provide a user name and password to connect to the Oracle server.

TNS Alias

Provide the Transparent Network Substrate (TNS Alias). This is the service name that is defined during database creation. The service name is the logical representation of a database.

Extracted Data Files Path

Provide the location where the extracted data files will be saved.

Connection Language

Specify the language code of the data extraction language.

The following table lists the supported languages and their codes:
LANGUAGE CODE

ENGLISH US

US

ENGLISH UK

GB

FRENCH

F

GERMAN

D

SPANISH

E

PORTUGESE

PT

LATIN AMERICAN SPANISH

ESA

BRAZILIAN PORTUGESE

PTB

CANADIAN FRENCH

FRC

Date Parameter

This field enables you to extract data for a specific period of time. For example, if you select Weeks from this drop-down list, and specify 2 in the Last X Weeks text box, data for the last 2 weeks till today is extracted.

Click Save to add the IRC Portable Data Scheduler. A message stating that the project is successfully created is displayed on the lower right corner of the window.

Note: See Infor Risk & Compliance Oracle - Configuration Settings Guide.