Change Data Capture Service for Oracle by Attunity

Change Data Capture Service for Oracle by Attunity

 

The CDC Service for Oracle is a Windows service that scans Oracle transaction logs and captures changes to Oracle tables of interest into SQL Server change tables. The SQL change tables where the changes captured from Oracle are stored are the same type of change tables used in the native SQL Server Change Data Capture feature. This makes consuming these changes as easy as consuming changes made to SQL Server databases.

The Microsoft® Change Data Capture Designer and Service for Oracle by Attunity for Microsoft SQL Server® 2016 are part of the SQL Server 2016 Feature Pack. Download components of the Feature Pack from the SQL Server 2016 Feature Pack web page.

The CDC Service for Oracle can be installed on any supported Windows computer with access to the source Oracle database(s) being captured and the target SQL Server instance where the target CDC database resides. The CDC Service does not need a local installation of the Oracle database or the SQL Server database, only their supported clients. For information about where to install the required database components, see Database Prerequisites in this topic.

The installation of the SQL Server CDC Service for Oracle places the service configuration UI and the service program in the selected location. The CDC Service for Oracle is configured separately using the Oracle CDC Service Configuration Console. For more information on configuring the Oracle CDC Service, see Change Data Capture Service for Oracle by Attunity F1 Help.

The CDC Service for Oracle can be installed on any supported Windows computer where the SQL Server 2016 Native Client is installed; it does not need to be installed on the same computer where the target SQL Server is installed.

The Change Data Capture Service for Oracle by Attunity can run in the following Windows environments:

  • Windows Vista with Service Pack 2

  • Windows 7

  • Windows 8 and 8.1

  • Windows 10

  • Windows Server 2008 R2

  • Windows Server 2008 with Service Pack 2

  • Windows Server 2012

To work with the CDC Service for Oracle you must install the SQL Server 2016 Native Client Oracle software. This is a prerequisite that should be obtained from Oracle and installed before installing the Oracle CDC Service. Additionally, you need to install the SQL Server ODBC Client using SQL Server Setup.

The CDC Service for Oracle supports the following versions:

Source Oracle Database

  • Oracle Database 11x, any version

  • Oracle Database 10x, any version

  • Oracle Database 10g Release 2: 10.2.0.1-10.2.0.5 (patchset as of April 2010)

  • Oracle Database 11g Release 1: 11.1.0.6-11.1.0.7 (patchset as of September 2008)

  • Oracle Database 11g Release 2: 11.2.0.1-11.2.0.3 (patchset as of September 2011)

  • Oracle Database 12c in classic installation. (Multitenant installation is not supported.)

Target SQL Server Database

For a list of features that are supported by the editions of SQL Server, see Features Supported by the Editions of SQL Server 2016.

To install the CDC Service for Oracle, open the installation wizard for the Windows platform you are using (32/64-bit) and follow the directions on the screen.

You uninstall the CDC Service for Oracle using Control Panel, Programs and Features.

Uninstalling the CDC Service does not delete the SQL Server databases created. For complete removal of the tool, you must remove the MSXDBCDC database and the specific CDC databases that were created in the target SQL Server instance you worked with.

If you uninstall the CDC Service software from one machine and install it on another computer, you only need to provide the following definitions:

  • Service account

  • SQL Server connect string and credentials

  • The master password

All the other definitions are stored in SQL Server and are available from the previous installation on another computer.

Working with the Oracle CDC Service

Community Additions

ADD
Show:
© 2016 Microsoft