Edit

Share via

How to Work with CDC Services

  • Article

Important

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

This procedure describes how to use the CDC Service Configuration Console to prepare a SQL Server instance to work with Oracle CDC Services and to create a new CDC service.

To work with CDC services

  1. From the Start menu, select the CDC Service Configuration for Oracle.

  2. From the left pane, select Local CDC Services (the root level).

  3. You carry out the one or both of the following tasks:

    • Prepare SQL Server

      Select this option from the Actions pane on the right side of the CDC Service Configuration Console.

      You can also right-click Local CDC Services and select Prepare SQL Server.

      The Preparing SQL Server Instance for Oracle CDC dialog box opens.

      To prepare the SQL Server instance for Oracle CDC services, the login must have a SQL Server login with the dbcreator fixed server role. This login is used to create the MSXDBCDC database that is required for adding Oracle CDC Services and, later on, Oracle CDC Instances.

      For information on how to use this dialog box, see Prepare SQL Server for CDC. For information on how to enable a SQL Server instance for CDC, see How to Prepare SQL Server for CDC.

    • Create a new CDC service

      Click New Service from the Actions pane on the right side of the CDC Service Configuration Console.

      You can also right-Click Local CDC Services and select New Service.

      The New Oracle CDC Service dialog box opens.

      For information on how to use this dialog box, see Create and Edit an Oracle CDC Service. For information on how to create or edit a CDC service, see How to Create and Edit a CDC Service.

      The SQL Server login used by the Oracle CDC Service only needs to be a member of the public fixed-server role, no other privileges are needed. However, to create the Oracle CDC Service, the login must have write permission to the MSXDBCDC database, for example the db_owner database role must be assigned to the login. When a login without write permission to the MSXDBDCDC database attempts to create a new Oracle CDC instance an error message is displayed. Click OK in that dialog box to display the Connect to SQL Server dialog box.

      For information on how to enter the credentials for a login that has write permission to the MSXDBCDC database, such the db_owner database role, see Create and Edit an Oracle CDC Service and Connection to SQL Server.

See Also

Work with CDC Services