Built-In MySQL repository database as a non-root Operating System user

Veridata now supports built-in MySQL as repository database to be configured as a non-root OS user. However, this option is available with complete install of 23.5.0.0.0 and not when applying patch, because repository database would already have been configured with prior version.

Filter option on the Run Jobs page

A Filter option is added on the Run Jobs page, to select and run subset of Compare Pairs in the Job. This feature is useful to re-run comparison for only the tables that failed or were Out-of-Sync in the previous run.

Support for Snowflake

Support for Snowflake is now available, including key functionalities such as data comparison, data repair, and the generation of Repair SQL. This enhancement enables seamless data comparison between Snowflake databases, as well as between Snowflake and other heterogeneous database systems, whether as a source or as a target.

Comparison by Row Count

Ability to create auto partitions for subset of a table

You can now create auto partitions for a table subset. Subset of table is selected by setting Row partitions in the compare pair. If you create auto partitions for a table and specify Row partition for any auto partition, then it is reflected in all auto partitions as it represents the same table.

Additional preference option for default view for Monitor Jobs page

A new option for the default view for Monitor pages is added in the User Preferences on the Home page. You can set either Completed Jobs or Running Jobs as the default page to display when you open the Monitor Jobs page on the navigation menu. The default is set to the Completed Jobs page.

Oracle GoldenGate Veridata Release 23c (23.3.0.0.0) includes the following new and changed features:

Support 2-way SSL between Veridata Server and NSK C-agent

2-way SSL support between Veridata Server and NSK C-agent has been added.

Oracle GoldenGate Veridata Release 23c (23.2.0.0.0) includes the following new and changed features:

Extend support to display approximate total row number to non-Oracle databases

Support has been extended to display approximate total row numbers to non-Oracle databases, such as SQL Server, MySQL, PostgreSQL, DB2 LUW, and DB2 I.

Support for Oracle Database 23ai

Oracle GoldenGate Veridata now supports Oracle database 23ai.

Rest API now retrieves available logs

REST APIs for retrieving logs based on log level, log type (api, perf, or both) and last lines from logs have been added.

Oracle GoldenGate Veridata Release 23c (23.1.0.0.0) includes the following new and changed features.

New Modernized User Interface

Oracle GoldenGate Veridata 23c comes with a newly designed modernized user interface which is more intuitive. See the Oracle GoldenGate Home page in Oracle GoldenGate Veridata Documentation.

New Built-In Repository Database

You do not have to maintain a separate repository database for Oracle GoldenGate Veridata. Oracle GoldenGate Veridata 23c comes with built-in repository database which is MySQL. For more information, see Oracle GoldenGate Veridata Architecture in Oracle GoldenGate Veridata Documentation.

No more dependency on Oracle Fusion Middleware

Oracle WebLogic was the application server used in Oracle GoldenGate Veridata. Starting from Oracle GoldenGate Veridata 23c, there is no more dependency on Fusion Middleware, as Oracle WebLogic has been replaced with a light-weight Helidon application server. For more information, see Oracle GoldenGate Veridata Architecture in Oracle GoldenGate Veridata Documentation.

Simplified Installation

Export/Import Utility

Starting from Oracle GoldenGate Veridata 23c, the Export and Import utilities are also available in Oracle GoldenGate Veridata UI. For more information, see Utilities in Oracle GoldenGate Veridata Documentation.

REST API

Oracle GoldenGate Veridata 23c is supported with REST APIs. For more information, see REST API for GoldenGate Veridata.

User Management

There are various roles in Oracle GoldenGate Veridata and these roles are categorized into various User Groups. The users can be assigned to these User Groups accordingly. For more information, see User Management in Oracle GoldenGate Veridata Documentation.

Single command to start Oracle GoldenGate Veridata

Start from Oracle GoldenGate Veridata 23c, you need just a single command to start Oracle GoldenGate Veridata. You do not have to start the Application server and Veridata Server separately.

Enhanced Report

Oracle GoldenGate Veridata 23c comes up with new enhanced way of displaying the Job reports.

Behavioral Changes

VGPP Utility

Starting from Oracle GoldenGate Veridata 23c, the GoldenGate Parameter Processing for Veridata (VGPP) has been deprecated. It has been integrated with the Import utility. The Import utility can accept both the file formats .xml and .prm as inputs to perform the Oracle GoldenGate Veridata configurations.

User Management

Oracle GoldenGate Veridata 23c comes with enhanced User Management. You can now create, delete, edit, users, and user groups from the Oracle GoldenGate Veridata User Interface itself. For more information, see User Management in Oracle GoldenGate Veridata Documentation.

Bug 38586984 - Unable to clone a group having compare pair(s) with Row Count comparison type

If a group has one or more compare pairs, with comparison type set to Row Count, user will not be able to clone the group.

Workaround: This issue has no workaround.

Bug 38582341 - Status in the Connection page shows UNKNOWN on mouse-hover

Status in the Connection page shows UNKNOWN on mouse-hover on the Up/ Down arrow icons.

Workaround: This issue has no workaround.

Bug 38580647 - Latest comparison status is not shown for previously executed compare pair in some cases

On running a job for a subset of compare pairs within a group, excluding some CPs, the Latest comparison status on the run job page will display only for the CPs included in the current run. For the CPs that were excluded, their Latest comparison status will be left empty.

Workaround: This issue has no workaround.

Bug 38580356 - Preference page throws blank screen on page refresh

Preference page throws blank screen on page refresh.

Workaround: This issue has no workaround.

Bug 38570288 - Cannot create compare pair between sqlserver tables with period in table name

Error when trying to create compare pair between sqlserver tables having period (.) in table name.

Workaround: This issue has no workaround.

Bug 38324822 - Repair is never ending for BLOB and CLOB Columns

Repair is taking longer to repair just a few rows.

Workaround: This issue has no workaround.

Bug 38297729 - Importing xml that contains compare pair with delta enabled using custom comparison format resets the format

Workaround: This issue has no workaround.

Bug 38268134 - Unable to exclude columns from comparison by unchecking 'Use' column when columns as mapped

User is unable to exclude columns from comparison by Unchecking the 'Use' column and saving the compare pair when the source column is mapped to an appropriate target columns.

Workaround: Unmap the column by selecting an empty target. This results in 'Use' column being disabled and hence the columns are excluded from comparison.

Bug 38627139 - Not able to update Row Partitions of a Compare Pair

For a compare pair, user is not able to delete or disable row partition even after the Save action is successful. However, user can create new row partition or update SQL predicate of an existing partition.

Workaround: This issue has no workaround.

Bug 38268134 - Unable to exclude columns from comparison by unchecking 'Use' column when columns are mapped

Workaround: To remove column from comparison, change target to empty value from dropdown and save. This will remove the column from comparison.

Bug 38097790 - Overall repair status shows OutOfSync when repaired in multiple iterations (Partial repair)

Workaround Do a complete repair in place of a partial one, by selecting Repair from the More Actions dropdown or by selecting the Repair from the Compare pair table.

Bug 38027246 - Group and Compare Pairs stuck when creating 2500 partitions for single table

Workaround: This issue has no workaround. You have to wait on Group and Compare Pairs creation page, as it takes longer to load. It appears to be hung, whereas it is just slowed.

Bug 37666767 - Repair fails for MariaDB:FLOAT.

The issue occurs when an update query is unable to locate a row due to the inclusion of the existing value in the WHERE clause. This behavior is also present in the MySQL instance.

Workaround: Navigate to the user's profile Repair category and set the Check changed values option to No instead of Use System Default.

Bug 37666738 - Repair fails for MariaDB:TIME

The issue occurs when an update query is unable to locate a row due to the inclusion of the existing value in the WHERE clause.

This behavior is also present in the MySQL instance.

Workaround: Navigate to the user's profile Repair category and set the Check changed values option to No instead of Use System Default.

Bug 37666690 - Repair fails for MariaDB:VARCHAR

For both MySQL and MariaDB, Oracle GoldenGate Veridata's repair currently works only when the VARCHAR value is less than 32,767 bytes (fewer than 32,767 characters for single-byte character sets, latin1).

Bug 37888195 - NSK: Dictionary & record structure not fetched in Enscribe compare pair column mapping

Dictionary and table structure not saved and fetched in Enscribe Compare Pair column mapping.

Bug 37457241 - postgres : Array To Vector Comparison shows same data as different

Array To Vector Comparison shows same data as different. Even though the values are identical, the underlying format is different. Therefore, it is always be shown as out-of-sync. Repair doesn't work as well from Array to Vector Data Type.

Bug 36287277 - Singlestore - Run repair failed for Date and Timestamp datatypes

Repair fails for DATE and TIMESTAMP column data.

Bug 36285419 - Job execution failed for singlestore to oracle blob column

Comparison failed for BLOB column while performing comparison between Singlestore (Source) to Oracle (Target).

Bug 36279870 - Singlestore to Oracle Run repair failed for Insert with warning

Repair fails when primary key column has space (' ').

Bug 36276833 - Run Repair failed for Singlestore DateTime type

Repair fails for DATETIME Datatype.

Bug 35605136 - Run Repair failed for Text (Singlestore) to XML (Oracle) Datatype

Repair fails for Singlestore TEXT Datatype to Oracle XML Datatype.

Bug 35542455 - Singlestore - Comparison after successful Run Repair shows OOS

Comparison after successful repair shows Out-Of-Sync rows, when the column data has space (' ').

Bug 37507723 - Postgres Array to Vector Comparison and repair does not work.

Array To Vector Comparison shows same data as different. Even though the values are identical, the underlying format is different. Therefore, it is always be shown as out-of-sync. Repair doesn't work as well from Array to Vector Data Type.

Bug 37466943 - Oracle to Postgres- Hetero Vector Comparison shows incorrect result

Comparison of Oracle Vector with Postgres Vector does not show appropriate results.

Bug 37502398 - Oracle Vector : Float Values are not repaired correctly ( precision issue)

For a few float values in Oracle 23ai Vector datatype, the row value does not get repaired as expected because of precision issue(s).

Bug 37515829 - Unable to edit Row Partitions

In the Groups and Compare Pairs page, the Row Partitioning is disabled by default, though it is enabled.

Workaround: Disable the Row Partitioning toggle switch and enable it again.

Bug 37507078 - Postgres: 42.7.4 (default) connector shows schemas as catalog

When you use postgresql-42.7.4.jar (the default jar in veridata Server) for postgres agent and then create a connection, schemas are shown as catalogs while creating Groups and Compare Pairs.

Bug 37084214 - Warning message is displayed while repairing Binary Double datatype

The Binary double datatype when found out-of-sync, does not get repaired because of the limitation in ojdbc11-23.2.0.0 driver.

Bug 37165991 - Repair monitoring API does not have all the repair row counts in the response

When a repair job is running, the API services has row counts for rows with different repair status (Pending, Successful, Failed, Skipped, and Running) and the repair types (insert, update, and delete) are set to zero.

This gets updated to correct values only when the entire job with all the compare pairs gets completed.

Bug 36813621 - First Login doesn't work at times

If you try to login for the first time after a long gap, then the login is not successful, at times. This can happen when VPN is disconnected and then reconnected.

Workaround: Click the Login button again.

If you cannot find an answer to your question or problem in the Knowledge Base, you can open a support case with Oracle Support by following these steps:

1. Go to http://support.oracle.com.

2. Select your language and then log in with your email and Oracle password.

3. Click the Service Requests tab.

4. Click Create SR.

5. Complete the form, referring to the Help at the top of the application window if necessary.