4.2.1.5 Creating a GoldenGate Data Stream

Prerequisites:
  • A GoldenGate connection.
  • A database connection to Oracle DB.
  • Ensure that the GoldenGate Extract process is running and capturing data into trail files.
  • Ensure GGSA can connect to GoldenGate endpoints over HTTPS/WSS.
  • Ensure that the Distribution Service APIs are enabled and accessible, to create and manage Data Streams.

To create a GoldenGate Data Stream:

  1. On the Catalog page, click Create New Item.
  2. Hover the mouse over Stream and select GoldenGate Data Stream from the submenu.
  3. On the Type Properties screen, enter the following details:
    • Name: Enter a unique name for the stream. This is a mandatory field.
    • Display Name: Enter a display name for the stream. If left blank, the Name field value is copied.
    • Description
    • Tags
    • Stream Type: The selected stream is displayed.
  4. Click Next.
  5. On the Source Details page, enter the following details:

    • Connection: Select a GoldenGate connection from the drop-down.

    • Select Deployment: Select a GoldenGate deployment from the drop-down. The drop-down lists the deployments of the chosen GoldenGate connection.

    • Create a Data Stream: Select this option to create a new stream on GoldenGate as well as the GGSA UI.
      1. Table Mode: Choose a Single Table or a Multi Table mode
      2. Enter New Stream Name
      3. Select DB Connection: Select a DB connection from the drop-down.
      4. Select Trail: Select a Trail that is existing on GoldenGate. A trail contains the Extract information.
      5. Select Table: Select a table or multiple tables according to the table mode you have selected earlier.
    • Select Existing Stream: Select exisiting stream from the drop-down.
  6. Click Next.
  7. On the Data Format screen, select Flattened JSON to split the shape into the selected table column fields: (before_columnname, after_columnname. Select JSON format to retain raw JSON format.

    Note:

    Flattened JSON format option is available only the Single Table mode.
  8. Click Next.
  9. On the Shape screen, select one of the methods to define the shape:

    • Select Existing Shape: Select one of the existing shapes from the drop-down list.

    • Manual Shape: Select this option to manually infer the fields from a stream or file. You can also update the datatype of the fields.

    • Detect Shape from Table: Select this option to detect the shape automatically from the database table.

  10. Click Save.