COVID-19 Update — We are available to assist you during these trying times. Please contact us for assistance.

HPE Shadowbase Online Loader (SOLV) and HPE Shadowbase ETL Overview

Before a database can be useful, it must first be loaded with data. HPE Shadowbase Online Loader (SOLV) and HPE Shadowbase ETL are utility products designed to perform this task, providing online and offline loading (or unloading) of a source database into a target database. Both of these products are included with each Shadowbase license. Shadowbase SOLV loading and Shadowbase ETL may also be licensed separately if the other data replication features of Shadowbase are not required.

Stock photo of two fingers on a puzzle piece being placed into a slotHPE Shadowbase (SOLV)

The HPE Shadowbase SOLV utility can load audited and non-audited 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 (e.g., HPE NonStop Enscribe or HPE NonStop SQL targets, or other server targets such as Oracle, SQL Server, DB2, and MySQL). The Shadowbase 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 to keep the target fully synchronized with the source while the load proceeds.

Key Features

Solution Brief: Shadowbase SOLV Product Suite
White Paper: HPE Shadowbase SOLV Product Suite — Online Database Loading, Copying, Synchronizing, and Unloading

HPE Shadowbase ETL Toolkit

Stock photo of small toolbox with handyman tools on a laptop

The HPE Shadowbase ETL toolkit uses and extends the SOLV loading capabilities to allow for reading and injecting events from flat files into the Shadowbase replication engine for processing It also produces flat files of database data or database change events that can then be subsequently processed by an ETL tool. The 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. It is particularly useful for feeding high-volume quantities of loading data into a data warehouse, and when feeding row-based data into columnar databases.

Key Features

 Case Study: Vodacom’s One Year Recovery
Zero Downtime Migrations Case Study: A Major ISP Migrates from Sybase to HPE NonStop with No Downtime
Use Case: Transform Inflight Data Using Shadowbase Mapping