HPE Shadowbase Online Loading (SOLV)

Load Audited and Non-audited HPE NonStop Data

The HPE Shadowbase SOLV utility can load HPE NonStop Enscribe source files and HPE NonStop SQL tables into any target environment and database combination supported by the Shadowbase line of data replication products. (Please see Supported Databases and Platforms.)

iStock

Perform Loading Activity During Replication

Keep the Target Database Synchronized During the Load

The SOLV utility can perform the load while regular replication is also taking place, consuming the source database changes and merging them with the data being loaded, and keeping the target fully synchronized with the source as the load proceeds.

Key Features

Allows for extract, transform, filter, and cleanse of the data being loaded
Use the same or different conversion routines as replication
Dynamically adjusts loading activity to efficiently utilize available resources
Initial and refresh target data-loading utility
Integrates with the Shadowbase replication engine to keep target synchronized during and after the load completes
Replicated events can optionally be consumed/merged with the loading activity, so there is no queue of changes to drain after the load completes
SOLV optionally can bypass writing data to interim disk queues during the load, making the loading process much more efficient than other loading methods
Source and target can be opened for read-write activity while the load or refresh occurs
Supports point-in-time bulk loading of source to target

Techniques for Online and Offline Database Loading

Bulk Loading

The source database may be online, but the target database remains offline while the load occurs.  Data is extracted from the source in large blocks, and is applied into the target as large blocks.

Hybrid Bulk (& Shadowbase Replication) Loading

The source database is usually online, the target database is offline during the bulk load, but is online afterwards for the change data synchronization.

SOLV Merged Loading

The source and/or target databases are online during the load.  Data is extracted from the source in record or row batches, and applied into the target merged with change data so that the target is fully synchronized when the load completes.

SOLV Block Loading

The source and/or target databases are online during the load. Data is extracted from the source in record or row batches, and applied into the target as transactions containing one or more records or rows.