- Solutions
- Resources
- Support
- About
Shadowbase Essentials for HPE Nonstop software is a software package that includes several solutions for data transformation, management, compliance, monitoring, and controlling.
This package is sold separately from the main change data capture (CDC) replication engine.
Shadowbase Audit Log (SAL) for HPE Nonstop software[1] — Create and fill an archival, searchable database with the data changes made to the application database.
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 Nonstop-based archival (audit log) database for application change data auditing and reporting purposes.
If the target archival (audit log) database is hosted on a non-Nonstop system, this requires licensing Shadowbase Audit Log on that platform (in addition to the HPE Nonstop Essentials Bundle).
Shadowbase Audit Reader (SAR) for HPE Nonstop software[1] — Show what and when application transactions occurred.
Shadowbase Audit Reader analyzes and displays all TMF-audited database activities contained in the TMF audit trails on HPE Nonstop server systems. Using an SQL-like query syntax, 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) has been changed.
The Shadowbase Data Definition Language Utility (SBDDLUTL) for HPE Nonstop software provides a powerful interface to convert and map the Enscribe DDL data structures (records, fields) into their SQL equivalents (tables, columns), producing an editable CREATE TABLE statement for the target SQL environment.
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. It is a key utility for customers performing Shadowbase Data Integration replication from Nonstop source Enscribe files out to SQL target tables.
Without SBDDLUTL, the conversion work will have to be done by hand, which is a time-consuming and error-prone process.
The Shadowbase SQL/MP Schema Conversion Utility (SBCREATP) for HPE Nonstop software converts and maps SQL/MP table schema data structure definitions (columns, data types) into target SQL equivalents (columns, data types), and produces an editable CREATE TABLE statement for the target SQL environment.
SBCREATP supports a variety of target SQL databases, including NonStop SQL/MX, Oracle, Microsoft SQL Server, IBM Db2®, Oracle MySQL, PostgreSQL, SAP HANA, and SAP Sybase. It is a key utility for customers performing Shadowbase data integration replication from Nonstop source SQL/MP tables out to heterogeneous SQL target tables.
Without SBCREATP, the conversion work will have to be done by hand, which is a time-consuming and error-prone process.
The Shadowbase Extract, Transform, and Load Toolkit (ETL)[1] for HPE Nonstop software is used to extract database changes or initial load data from a Shadowbase source database or environment into flat files for subsequent ETL (or Extract, Load, and Transform, or ELT) loading into a target environment such as a data warehouse. Shadowbase Application Integration for HPE Nonstop software provides a suite of adapters to easily integrate the source data with the target environment. Available adapters include:
For certain applications, an existing vendor’s ETL (or ELT) loading utility can then be used to load the Shadowbase ETL flat file(s) into the target environment.
SB DCR Provides DDL Replication Support for HPE Nonstop Enscribe Files & SQL/MP Tables.
Shadowbase DCR for HPE Nonstop software replicates source system FUP or SQLCI DDL commands to a target system, reformatting the command and system name to ensure the target system is an exact copy of the source.
Shadowbase DCR can replicate and apply these commands while Shadowbase DML event replication is actively running. SB DCR uses file or table name mapping between the source and target so that source system commands have the same result when applied to the target system.
In particular, Shadowbase DCR for SQL/MP helps HPE RDF customers who use RDF/SDR (RDF SQL DDL Replicator) to migrate to a Shadowbase solution.
Shadowbase UNDO[1] for HPE Nonstop software — Selectively undo, or rollback, changes made to a database
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.
Shadowbase REDO[1] for HPE Nonstop software — 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 Lock Listing Tool (SBLSLock) is used to summarize all locks on a specific file or SQL/MP table. It also lists all the partitions, alternate key files/indexes, and associated locks for the specified file or table. It can be helpful to identify all the participants in the same transaction or locking operation.
The Shadowbase Transaction Listing Tool (SBLSTran) is used to list all transactions on a system that are currently monitored by TMF. It has an optional brief mode, which will only display the timestamp of the oldest transaction on a system and is useful for planned cut-over/fail-over scenarios. It is also often useful for getting a good picture of all TMF transaction activity on a system.
Shadowbase Utilities for HPE Nonstop software are separate from the Essentials Bundle and include additional tools for various uses, including managing, monitoring, and correcting data.
Shadowbase Essentials Bundle for HPE Nonstop includes several solutions (check with Gravic or your reseller as we are constantly adding more solutions to the bundle). Note that these solutions run solely on HPE Nonstop systems:
While some Solutions in the Essentials Bundle (such as Shadowbase Audit Reader) are standalone, others (like Shadowbase Map) require either Shadowbase BC Basic for HPE Nonstop software or Shadowbase DIAI Basic for HPE Nonstop software to be licensed.
Be sure to check with your Software supplier for clarification.
Copy link to clipboard
Email link
Print
