Note: Although Attunity Stream is used to capture changes in source systems, it is used as a regular JDBC source (only an LKM is used). The Oracle Data Integrator journalizing framework (JKM) is not used for this technology.
The Oracle Data Integrator CDC knowledge module is certified on the following platforms and versions:
Oracle Change Data Capture Adapters version 10.1.3.4 and higher. Attunity Stream version 5.0.1 and higher.
Installation and Configuration
In order to use the Attunity Stream technology, you must first install the drivers for Attunity Stream/Oracle Changed Data Capture Adapaters in the oracledi/drivers/ directory of your Oracle Data Integrator installation and restart ODI. The driver files include the following: Navutil.class, nvjdbc2.jar, nvapispy2.jar, nvlog2.jar.
For more information on installing Attunity Stream/Oracle Changed Data Capture Adapters, please refer to the Oracle® Application Server - Changed Data Capture Adapter Installation Guide.
Working with the Oracle CDC KM
The Oracle Data Integrator CDC KM enables read access to Attunity Stream captured changes. To use Attunity Stream data in your Oracle Data Integrator integration projects, you must:
Define the Topology.
Create an Attunity Stream model
Set up the project
Design an Interface using the Oracle Data Integrator CDC KM.
Defining the Topology
The steps to create the topology in Oracle Data Integrator, which are specific to projects using the Attunity Stream KM, are the following:
Connect to your master repository using Topology Manager.
If the Attunity technology is not in Topology Manager, import the Attunity technology using Synonym Insert-Update mode.
Create a data server using the Attunity technology. This data server represents the server and workspace storing the Attunity Stream datasources. Set the parameters for this data server as follows:
JDBC Driver: com.attunity.jdbc.NvDriver
JDBC URL: jdbc:attconnect://<host name>:<port>/<workspace>[;AddDefaultSchema=1 ][;<parameter>=<value>]
The details of the JDBC URL are shown in the following table:
Name of the machine running the Attunity daemon
Port that the daemon listens to
Knowledge Modules Reference Guide