Data replication is at the center of the HPE Shadowbase product portfolio. However, HPE Shadowbase solutions include additional utility products to manage, monitor and, if necessary, correct that data in order to detect and resolve anomalous behavior, ensure continuation of proper business operations, and meet audit compliance.
Click on a link below to learn more:
Shadowbase Compare is an essential tool to support your business continuity operations for HPE NonStop environments. It allows the user to compare a target NonStop Enscribe file or NonStop SQL table to its source, and reports on any discrepancies found between them, and may be helpful in satisfying regulatory and audit requirements. Applications can remain active on both the source and target, even for updating, while the comparison takes place.
HPE Shadowbase Repair is a feature in the HPE Shadowbase Compare for SQL NonStop Utility to assist with correcting or repairing SQL/MP or SQL/MX database discrepancies between two tables. Shadowbase Repair works on any two tables in these databases, provided they are both of the same type (MP or MX). It does not require a Shadowbase replication configuration, and can be used in any environment where a source and target table need to be verified.
The HPE Shadowbase Data Definition Language Utility (SBDDLUTL) provides a powerful interface to convert and map the Enscribe DDL data structures (records, fields) into their SQL equivalents (tables, columns). SBDDLUTL supports a variety of target SQL databases, including NonStop SQL/MP, NonStop SQL/MX, Oracle, Microsoft SQL Server, IBM DB2, Oracle MySQL, SAP HANA, and SAP Sybase.
Shadowbase Audit Log is available for the HPE NonStop Server platform as a source, and creates a searchable archival database of transactional activity (e.g., inserts, updates, and deletes) on a reporting database for application change data auditing purposes.
HPE Shadowbase Audit Reader (SAR) — Show what and when application transactions occurred
Shadowbase Audit Reader analyzes and displays all TMF-audited database activities on HPE NonStop server systems. It shows what application transactions did, and when they did it, to database files and tables, enabling investigation of how and when data (and the database) is being changed.
Shadowbase Online Loading provides online loading of a source database into a target database, meaning that the source and/or target databases can be open for reading and updating while the load (or copy) occurs. It can perform the load while regular replication is also taking place, consuming the source database changes and merging them with the data being loaded, to keep the target fully synchronized with the source.
The Shadowbase Extract, Transform, and Load Toolkit is used to extract database changes or initial load data into flat files for subsequent ETL loading into a data warehouse using comma-separated value (CSV), fixed-position, and tab-delimited formats. For certain applications, an existing vendor’s ETL loading utility can then be used to load the Shadowbase ETL flat file(s) into a data warehouse.
Help enable the use of HPE Shadowbase data replication
Shadowbase File Chaser reads non-audited application-created-and-maintained log files/tables and injects those events into the Shadowbase replication stream to be applied into the target environment.
Shadowbase SOLV Snapshot Loading is a technique for reading and replicating HPE NonStop TMF-audited or non-audited source Enscribe files and SQL tables to a target environment.
HPE NonStop AutoTMF, a separate HPE product, enables Shadowbase replication of non-audited HPE NonStop Enscribe file changes. It is required if Shadowbase software needs to replicate the individual Enscribe file changes from the source to the target environment.
HPE NonStop AutoSYNC, a separate HPE product, enables replication of non-database objects (e.g., program object code, TACL scripts, edit files, etc.) from a NonStop source to a NonStop target environment. Shadowbase software does not replicate these object types.
Shadowbase UNDO restores a corrupted database by undoing corrupting database changes while retaining correct database changes, thus leaving the database in a known, consistent, and current state. Shadowbase UNDO allows the database to stay online for application processing while the rollback of the corrupted data occurs.
HPE Shadowbase REDO — Roll database changes forward to a current and correct state
Shadowbase REDO maintains a Redo Queue of all changes that were made to a database. If the database subsequently becomes corrupted, Shadowbase REDO can be used to roll forward these changes against a restored copy of the database by deleting corrupting changes from the Redo Queue and applying only the valid database changes to roll forward to a current and correct state.
The Shadowbase Queue Manager allows HPE NonStop data to queue to disk while it is being replicated in order to separate the data’s extraction and delivery from the replaying of that data into the target environment.
Shadowbase Enterprise Manager is a Windows-based GUI command and monitoring interface that controls and monitors Shadowbase replication on the platforms that Shadowbase software supports.