5.1.2 Editing a Connection

  1. Click Connections in the navigation pane.

  2. In the connections list, click the edit (pencil) icon next to the connection that you want to edit.

    Alternatively,

    Click the connection name from the connections list, to display the Connection Details and Connection Configuration sections.

To edit the Connection Details:
  1. Click Edit in the Connection Details section, to edit the description, Agent or Datasource connection details.
  2. Click Save to save your edits.
To edit the Connection Configuration:

This tab modifies the behavior of the agent.

Properties Tab

  • Agent Message Timeout: Specifies a time interval, in seconds, after which the Server abends, if it has not received a message from the Agent.

  • Truncate Trailing Spaces When Comparing Values: Space (U+0020) and Ideographic Space (U+3000) are the truncate targets. This parameter works only for String or Binary columns. You can configure the truncated length with the truncate_spaces_len entry in the veridata.cfg file of the Oracle GoldenGate Veridata Server. This parameter also truncates the column padding character if the padding character is one of the targe spaces. This parameter does not trim trailing spaces on LOB data.

  • Compare Fetch Size: Sets the number of rows that are fetched at once for the initial comparison and for the confirm out of sync using batch or join. Increasing the batch size may increase throughput, as compared to standard database access.

    Exclusively, for the Oracle and PostgreSQL databases, the default value is 1000 and it fetches a batch size of 1000 rows; the minimum value that you can enter is 100. Any lesser value that you enter automatically changes to 100. The maximum value is 100000. For databases other than Oracle and PostgreSQL (SQL Server, Sybase, or DB2), the default value is 0, minimum is 0, and maximum value is 1000.

To change a setting:

Toggle the Use Default button to set the parameter to the default value.

The current setting is shown under Value.

  1. Toggle the Use Default button.
  2. Edit Value.
  3. Click Save.

Data Types

This tab defines rules for how each data type in the underlying database is interpreted and mapped if compared to data from a different type of database. This tab sets global values for all instances of a data type.

To override the format mapping of a specific column in any given table, go to the Groups and Compare Pairs page, click the Group name, then click the Compare pair name, and in the Column Mapping tab, select the User Defined column mapping method.

The supported data types are displayed with default mappings to Oracle GoldenGate comparison formats. In cases where the automatic mapping is not sufficient, you can select another supported format.

To change a format setting:

  1. Toggle the Use Default button.

  2. Make a selection under Comparison Formats.

  3. Depending on the data type and format that you specified for Comparison Formats, you might need to supply or select additional information in the Precision, Scale, and Timezone columns.

  4. Click Save.

Note:

If there's a need to treat NULL values and spaces as same then, the comparison format string_en can be used if listed in the supported formats for the selected datatype. This works only when either the Source or the Target database is Oracle.

Parent topic: Connections