Edit

Edit the Oracle Database Properties

  • Article

Important

Change Data Capture for Oracle by Attunity is deprecated now. For details, refer to the announcement.

Use the Oracle tab in the Properties editor to make changes to the description you provided in the Create CDC database page in the New Instance wizard and to make changes to the Oracle Log Mining database connection information.

The following describes the information in the Oracle tab.

Name
The name of the CDC Instance that you entered in the Create CDC Database page in the New Instance wizard. This field is read only and you cannot edit this information.

Description
You can edit the description of the new instance or add one if you did not do so when creating the CDC Instance.

Oracle Connect String
The Oracle connect string to the computer with the Oracle database you are using. This field is read only and you cannot edit this information. This is because some changes to the connect string may point the Oracle CDC Instance to another Oracle database entirely, corrupting the CDC Instance state as stored in the cdc.xdbcdc_config table. If minor changes are needed, you can change the connect string directly in the configuration table using SQL Server Management Studio.

Oracle Log Mining Authentication
To enter the authentication credentials for the Oracle database that contains the log miner, select one of the following under Authentication:

  • Windows Authentication: Select this to use the current Windows domain credentials. You can use this option only if the Oracle database is configured to work with Windows authentication.

  • Oracle Authentication: If you select this option, you must type the User Name and Password for the user in the Oracle database you are connecting to.

You can view the Oracle database properties in the viewer. When using the viewer the information is read only. The viewer also includes a list of the captured columns in the table. For information on how to access the viewer, see How to Manage a CDC Instance.

See Also

How to Manage a CDC Service from the CDC Designer Console
Connect to an Oracle Source Database
Connect to Oracle