Required. The connection type. Select PWX Oracle.

The description of the connection. The description cannot exceed 255 characters.

Required. The database user name.

Required. The password for the database user name.

The owner of the connection. Default is the user who creates the connection. You can change the owner of the connection.

The code page that the Integration Service uses to extract data from the source database.

SQL commands to set the database environment when you connect to the database. The PowerCenter Integration Service runs the connection environment SQL each time it connects to the database.

Number of seconds the Integration Service attempts to reconnect to the data source or target if the connection fails. If the Integration Service cannot connect to the database in the retry period, the operation fails.

Select to compress source data during the PowerCenter session.

The type of encryption that the Integration Service uses. Select one of the following values:

None.
RC2.
DES.

Default is None.

The level of encryption that the Integration Service uses. If you select RC2 or DES for Encryption Type, select one of the following values to indicate the encryption level.

1. Uses a 56-bit encryption key for DES and RC2.
2. Uses a 168-bit triple encryption key for DES. Uses a 64-bit encryption key for RC2.
3. Uses a 168-bit triple encryption key for DES. Uses a 128-bit encryption key for RC2.

Ignored if you do not select an encryption type.

Interprets the pacing size as rows or kilobytes. Select to represent the pacing size in number of rows. If you clear this option, the pacing size represents kilobytes.

Convert character fields to string fields so that embedded nulls in data are processed as spaces.

Mode in which the Integration Service sends data to the PowerExchange Listener. Configure one of the following write modes:

Confirm Write On. Sends data to the PowerExchange Listener and waits for a response before sending more data. Select if error recovery is a priority. This option might decrease performance.
Confirm Write Off. Sends data to the PowerExchange Listener without waiting for a response. Use this option when you can reload the target table if an error occurs.
Asynchronous With Fault Tolerance. Sends data to the PowerExchange Listener without waiting for a response. This option also provides the ability to detect errors. This provides the speed of Confirm Write Off with the data integrity of Confirm Write On.

Overrides the default prefix of PWXR for the reject file. PowerExchange creates the reject file on the target machine when the write mode is asynchronous with fault tolerance. To prevent the creation of the reject files, specify PWXDISABLE.

Specifies PowerExchange connection override values, separated by semicolons, including the following overrides:

TCPIP_OP_TIMEOUT= network_operation_timeout ;
TCPIP_CON_TIMEOUT= connection_timeout

Amount of data that the source system can pass to the PowerExchange Listener. Configure the pacing size if an external application, database, or the Integration Service node is a bottleneck. The lower the value, the faster the performance. Enter 0 for maximum performance. D

Required. Location of the PowerExchange Listener node. The location is defined in the first parameter of the NODE statement in the PowerExchange dbmover.cfg configuration file.

Oracle SID (instance name).