Editing a Connection

Use the Edit Connection page to edit connection information. The settings on this page are applied globally to all comparisons that are run from the associated data source, unless an override is permitted elsewhere.

Edit the following connection information on this page:

Note:

You must have the Administrator or Power User role to edit a connection.

Connection Details

This tab captures the information that is required for the Oracle GoldenGate Veridata Agent to connect to a database.

Element	Description
Name	This name cannot be changed. This is the name that you had specified while creating the connection.
Description	A description is optional and can be edited as needed.
GoldenGate Connection	Enter the GoldenGate connection details.
Host Name or IP Address	The DNS (Domain Name Server) host name or IP address of the host where the Oracle GoldenGate Veridata Agent is installed. See the Oracle GoldenGate Veridata Administrator Guide for installation instructions, if needed.
Port	The port number that is assigned to the agent (or the Manager process, if a C-agent). To find out the port number of a Java agent, view the server.port parameter in the agent.properties file within the agent's installation directory. To find out the port number for a C-agent Manager, run the GGSCI program from the agent's installation directory, and then use the INFO MANAGER command.
Datasource Type	The type of database that is accessed by this connection. This attribute cannot be changed.
Datasource Connection	Enter more details for this connection.
User	A user name for connecting to the data source.
Password	A password for connecting to the data source (if required by the database). For required data source permissions, see the Oracle GoldenGate Veridata Administrator Guide.
Datasource Connection for Repair (Optional)	A separate user can be configured for executing repair operations at the target database. This user needs permission to update as well as to query the tables. More
Repair User	Specify a user name for connecting to the data source.
Repair Password	Specify the password for the above user name.

Connection Settings

This tab modifies the behavior of the agent.

A check mark under Use Default indicates that a parameter is set to the default value.

The current setting is shown under Value.

If the parameter is a toggle, a check mark under Value indicates that it is enabled.

To Change a Setting

Clear the Use Default box.
Make your change under Value.
Click Save.

You can set values for the following parameters:

Setting	Description
Agent Message Timeout (seconds)	Specifies a time interval, in seconds, after which Oracle GoldenGate Veridata Server abends if it has not received a message from the Oracle GoldenGate Veridata Agent.
Truncate Trailing Spaces When Comparing Values	Truncates trailing spaces when comparing string-type columns. If a column only contains spaces, the first space is kept. Truncating trailing spaces is useful when comparing columns that have different lengths. Trailing spaces are truncated from VARCHAR columns automatically, regardless of how this parameter is set. Trailing spaces on LOB data are not trimmed.
Initial Compare Fetch Batch Size	(Oracle Database only) Sets the number of rows that are fetched at once for the initial comparison. Increasing the batch size may increase throughput, as compared to standard database access. The default of 0 fetches a batch size of 1000 rows. Any other value that you supply will be the actual number of rows fetched. If used, a value of at least 100 rows is recommended. Values greater than 1000 usually are not productive and waste memory.
Use Secure Socket Layer (SSL) for agent-server communication	Select this check box for secure communication between the Veridata Agent and the server.

Connection Properties

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 Column Mapping Configuration page for the compare pair and then use 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:

Clear the Use Default check box.
Make a selection under Comparison Formats.
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.
Click Save.