Access to Legacy Applications and Data

Flexible Processing and Filtering

HDR flexibly reproduces host data in whole or in part according to selection criteria determined by the user:

Replication of selected columns (“vertical partitioning”)
Replication of selected rows (“horizontal partitioning”)
Replication of selected columns from selected rows (combined vertical and horizontal partitioning)

HDR can either replace entire tables or merge replicated data with existing tables that are located in the target database. Changes may be made in format or data values in several ways:

Construction of destination columns calculated (“derived”) from source data
Use of SQL expressions in order to alter data in destination tables before or after replication
Change in column names, column data types, or column order between source and destination