X hits on this document

418 views

0 shares

1 downloads

0 comments

71 / 131

  • 3.

    Select the model, right-click then select Changed Data Capture > Subscriber > Subscribe. Add subscribers for this model.

  • 4.

    Select the model, right-click then select Changed Data Capture > Start Journal. The JKM creates the CDC infrastructure and generates the configuration for Oracle GoldenGate.

You can review the result of the journal startup action:

The Oracle GoldenGate configuration files, as well as a Readme.txt file are generated in the directory specified in the LOCAL_TEMP_DIR KM option. You can use these files to Configuring and Starting Oracle GoldenGate Processes.

CDC infrastructure is set up correctly. The journalized datastores appear in the model tree view with

a

(Journalizing Active) flag. You can use the Changed Data Capture > Journal Data…

contextual menu option to access the journalized data for these datastores.

Notes:

See “Changed Data Capture” in the Oracle Data Integrator 10g Release 3 (10.1.3) User's Guide for more conceptual information and detailed instructions on CDC.

See the Knowledge Module Options Reference

for a list of all KM options

Although this CDC configuration supports consistent set journalizing, it is not required to order datastores in the Journalized Table tab of the model after adding them to CDC.

Configuring and Starting Oracle GoldenGate Processes

T h e J K M g e n e r a t e s i n t h e L O C A L _ T E M P _ D I R a f o l d e r n a m e d a f t e r t h e s o u r c e a n d t a r g e t o b j e c t g r o u p s . T h i folder contains the following: s

The Readme.txt file that contains detailed instructions for configuring and starting the Oracle GoldenGate processes.

The src folder that contains configuration files to upload on the source server, in the Oracle GoldenGate installation directory.

The stg folder that contains configuration files to upload on the staging server, in the Oracle GoldenGate installation directory.

The detailed instructions, customized for your configuration, are provided in the readme file. These instructions include:

  • 1.

    Uploading or copying files from the src folder to the source server.

  • 2.

    Uploading or copying files from the stg folder to the staging server.

  • 3.

    Running on the source server the OBEY file generated by the JKM for starting the Extract process, using the ggsci command line.

  • 4.

    Generating on the source server definition file using the defgen command line.

  • 5.

    Copying this definition file to the staging server.

  • 6.

    If the initial load option is used:

    • a.

      Running on the staging server the OBEY file generated by the JKM for the initial load, using the ggsci command line.

    • b.

      Running on the source server the OBEY file generated by the JKM for the initial load, using the ggsci command line.

Knowledge Modules Reference Guide

71/131

Document info
Document views418
Page views421
Page last viewedSat Dec 10 04:22:07 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments