Navigator User Guide

Back Next

CAPXRT Advanced Parameters Dialog Box - Oracle Tab

On the

Oracle

tab of the

CAPXRT Advanced Parameters

dialog box, define optional overrides for the database row test of real-time access to Oracle source data.

Oracle Instance: Overrides the Oracle instance in the second positional parameter, oracle_sid, in the ORACLEID statement in the dbmover.cfg configuration file.

ORACLEID=(coll_id,oracle_sid,connect_string,cap_connect_string)

This parameter is used in conjunction with the
Oracle Connection String
parameter to enable the use of a single set of capture registrations for capturing data from multiple Oracle instances.

If you specify an
Oracle Instance
value but no
Oracle Connection String
value, PowerExchange uses the Oracle connection string value that you define in the ORACLEID statement in the dbmover.cfg file.
Oracle Connection String: Overrides the Oracle connection string value in the third positional parameter, connect_string, in the ORACLEID statement in the dbmover.cfg configuration file.

This parameter is used in conjunction with the
Oracle Instance
value to enable the use of a single set of capture registrations for capturing data from multiple Oracle instances.

If you specify an
Oracle Connection String
value but no
Oracle Instance
value, PowerExchange uses the Oracle connection string value that you define in the ORACLEID statement in the dbmover.cfg file.
Oracle Schema: Overrides the Oracle schema that is specified in the registration group to enable the use of a single set of capture registrations for capturing data from multiple schemas, which might exist in the Oracle instance.

Click

to save changes. The source database connection closes. In the

Database Row Test

dialog box, click

to establish the database connection again and perform the database row test with the updated advanced properties.