Use HPE Shadowbase Compare and Repair Software for Data Validation and Verification

Data replication is at the center of the HPE Shadowbase product portfolio. It is important to monitor and correct data in order to detect and resolve improper behavior, ensure continuation of proper business operations, and comply with audit and regulatory requirements.


 

 

A backup database or second copy of data is worthless unless it is correct, consistent, and a complete replica of its source database or data.


 

 

The Shadowbase Compare and Repair software suite provides the capabilities necessary to meet these needs. Shadowbase Compare validates that a target database matches its source, and reports all discrepancies found between them.


 

 

For example, discrepancies may occur when an initial load of a target environment is not complete or a user accidentally misconfigures the replication environment or purges required audit trails or change logs.


 

Discrepancies can also occur due to employee misconduct, malware, or data tampering, or when the operations staff accidentally configures their application environment to update the target database copy instead of the source database copy.


 

Shadowbase Compare should be run when a database is created or loaded, and periodically afterwards.


 

 

These comparisons create multiple synchronization points where the data is confirmed to be correct, which creates a reference point that greatly simplifies subsequent data tracking, analysis, and resolution if future comparisons return a discrepancy.


 

 

Shadowbase Compare is easy to add into existing architectures, and can run while normal business operations occur, with no disruption to normal IT services.


 

 

Both source and target databases remain online for continuous application and data processing while the comparison and verification of database consistency occurs.


 

 

Shadowbase Compare includes special logic to manage temporary data discrepancies, called false positives, which occur due to replication latency.


 

 

Shadowbase Compare supports many replication architectures. For example, an application running against the backup database instead of the production database, or identifying any accidently omitted files or tables in an active/passive architecture.


 

 

Shadowbase Compare uses sophisticated data compression algorithms to reduce the total network traffic and improve the speed of comparisons. It also supports deselecting certain columns from the comparison, such as when comparing the original and new data for an SQL database schema change upgrade.


 

 

Shadowbase Compare is highly recommended for validating every replication environment – including like-to-like HPE NonStop Enscribe files and SQL tables. Validation provides confidence and certifies that the source and target databases match at all times and can be run on demand with minimal system overhead. Shadowbase Compare is a stand-alone product that works with any data replication engine, including environments without a data replication engine.


 

 

For SQL comparisons, it also includes the Shadowbase Repair function. When a discrepancy is found between the source and target databases, the repair function is used to correct these differences.


 

 

Use HPE Shadowbase Compare and Repair software to validate that your source and target data accurately match in any replication architecture for continuously running business operations.


 

Contact us today and learn how HPE Shadowbase Compare and Repair can benefit you!

 

Hewlett Packard Enterprise globally sells and supports Shadowbase solutions under the name HPE Shadowbase. Specifications subject to change without notice. Trademarks mentioned are the property of their respective owners. Copyright © 2022 by Gravic, Inc.

Author


  • Gravic, Inc. is a world leader in providing innovative data collection, transformation, and distribution solutions. For over 40 years, our software product groups have produced technologically advanced solutions that improve the businesses and personal lives of our over 100,000 customers and tens of thousands of OEM end-user licensees.