HPE Shadowbase Data Mapping Facility (SBMAP)

Flexibly Transform Data

HPE SBMAP gives the user the capability of defining and applying data mappings in replication without the need to write C, C++, or COBOL code to implement custom Shadowbase User Exits. With the SBMAP scripting syntax, the user can intuitively define data transformations and filters. The syntax and statements used in SBMAP are based on existing SQL/MP features.

Hewlett Packard Enterprise

Create Custom User Exits

Define and Apply Data Mappings in Shadowbase Software without Coding

Before SBMAP, all User Exits had to be programmed by hand. Now, use SBMAP to automatically transform data mappings from one database to another.

Data Transformation Features

SBMAP flexibly allows the user to choose from multiple commands and operations to ensure that data is transformed and delivered in just the right format.

Add, Drop, Rename Columns, and Apply Event Filtering
  • Set the values of new columns
  • Use the SBWHERE statement (a conditional trigger that specifies when SBMAP will execute and what data it will replicate), similar to “WHERE” in standard SQL.
Use Built-in Functions (for SQL/MP)
  • Arithmetic operations
  • Build “IF…THEN…ELSE” and “SWITCH…CASE” statements
  • CAST function (for casting between common SQL/MP datatypes; includes date-time support)
  • Numeric manipulation
  • String manipulation (substrings, concatenation, etc.)
String Processing
  • Concatenate column data
  • Create custom strings
  • String-based functions
    • IF-CASE statement
    • SUBSTRING expressions
    • TRIM
Reference and Utilize External Tables

An “external table” is a table that is not a part of the Database Specification (DBS) where the current mapping event belongs. The external table is like a “third-party” table: one that is neither the source nor the target in the replication architecture.

This capability enables event- and streaming-types of operations to occur based on values in tables on other platforms, environments, and systems.

  • Conditional formatting (based on external table data values)
  • Extract and read data
  • Perform DML operations
Replicate Before and After Image Values
  • Enables easier management of active/active architectures
  • Simplifies data verification and debugging
Supports Parallelism
  • Allows for even more fine-grained replication threading by hashing individual tables and partitioning multiple consumers by attaching each mapping to a specific Consumer