Manage an Oracle CDC Service
Important
Change Data Capture for Oracle by Attunity is deprecated now. For details, refer to the announcement.
You can use the CDC Service Configuration Console to manage a specific CDC Service.
To select the CDC service you want to work with
From the left pane in the CDC Service Configuration Console, expand Local CDC Services.
Select the CDC service you want to work with.
You can also right-click the CDC service you want to work with and select the desired action. See What can you do with a CDC Service.
OR
Select Local CDC Services from the left pane in the CDC Service Configuration Console.
From the middle section of the CDC Service Configuration Console, select the service you want to work with.
You can also right-click the CDC service you want to work with and select the desired action. See What can you do with a CDC Service.
What can you do with a CDC Service
You can carry out the following actions when working with a CDC service.
Delete the service
From the Actions pane on the right side of the CDC Service Configuration Console, click Delete to delete the service.
You can also right-click the CDC service you want to delete and select Delete.
Note: If the service is running when deleting the service, the service is stopped before being deleted.
To delete the Oracle CDC Windows Service definition, the program needs update access to the MSXDBCDC database in the associated SQL Server instance. When you click OK to delete the service, the program attempts to delete the Oracle CDC Service registration in the MSXDBCDC database. If the program cannot delete the Oracle CDC Service registration because it does not have the proper permissions, it prompts the user to enter a SQL Server login with update permissions to the MSXDBCDC database.
For information about the data you must enter in the Connect to SQL Server dialog box, see Connection to SQL Server for Delete.
Edit the CDC Service Properties
From the Actions pane on the right side of the CDC Service Configuration Console, click Properties.
You can also right-click the CDC service where you want to edit the properties and select Properties.