GoldenGate Change Stream

Getting a GoldenGate Change Stream into a Kafka Topic

To create a GG Change Data:

  1. On the Catalog page, click Create New Item and select GG Change Data from the drop-down list.

  2. On the Type Properties screen, enter the following details:
    • Name
    • Description
    • Tags
    • GG Type: Select Change Data from the drop-down list.
  3. Click Next.
  4. On the GG Deployment Details page, enter the following details:
    • Connection: Select a GG connection form the drop-down list.
    • Deployments: Select a deployment from the drop-down list.
    • Deployment Username: Enter the GoldenGate username of the deployment.
    • Deployment Password: Enter the GoldenGate password of the deployment.

    Note:

    The GoldenGate username and password of the deployment should be of the user with access to create a new distribution path from the Goldengate instance.
  5. Click Next.
  6. On the GG Change Data Details page, enter the following details:
    • GG Extracts: Select a GG stream from the drop-down list.
    • Target Trail: Enter a two character name for the Goldengate trail file.
    • Kafka Connection: Select a Kafka connection from the drop-down list.
    • GG Change Data name: Enter a name for the goldengate stream (maximum 8 characters). This name will be used for the replicat process that puts the change data from trail file to Kafka topics.
  7. Click Save.

Note:

The following template parameter files for the replicat process are located at osa-base/etc/:
  • kafka.props.template
  • replicat.prm.template
  • custom_kafka_producer.properties.template
You can modify these template files to customize the replicat process before proceeding to the next step.