Data Transformation Solutions

HPE Shadowbase software can transform the data between source and target database formats either automatically or via Shadowbase User Exit customizations. Data may be aggregated, disaggregated, and/or transformed.

Getty Images

HPE Shadowbase Map (SBMAP)

A powerful, sophisticated, and extensible scripting “language” that can be used to inform Shadowbase software how to transform source data into target data formats. Using SBMAP avoids the needs to write Shadowbase User Exits or Adapters.

Related Content
Use Cases (with SKUs): Transform Inflight Data Using Shadowbase Mapping
Shutterstock/Darrin Loeliger

HPE Shadowbase Data Definition Language (DDL) and SQL Schema Conversion Solutions

 

Convert and Map Enscribe Data Structures into SQL equivalents (SBDDLUTL)

The HPE Shadowbase Data Definition Language Utility (SBDDLUTL) 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.

Convert and Map SQL/MP Schemas into Target SQL Equivalents (SBCREATP)

The HPE Shadowbase SQL/MP Schema Conversion Utility (SBCREATP) 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.

Related Content
Briefs: HPE Shadowbase Data Definition Language (SBDDLUTL) Technical Brief

HPE Shadowbase User Exits

Users have the option to write a Shadowbase User Exit for extending Shadowbase replication to perform additional processing with either scripting or via embedding custom code. These user exits allow Shadowbase software to handle any data manipulation, filtering, or cleansing required.

Shadowbase User Exits

  • Transformation and Mapping Facility
    • ASCII text file of Transformation Commands; read at start-up
  • SB API LIBRARY
    • SBGET, SBPUT, SBSETEXECUTE, SBSETIGNORE, etc.
  • User Exits – C/C++, COBOL, or TAL APIs
    • Non-native and native code supported
    • Data scrubbing and cleansing
    • Field splits and merges
    • Aggregation and summation
    • Integrate data from other databases
    • Any target environment with an API that Shadowbase User Exits can access
    • Sophisticated data selection, filtering, and transformation

Note: Shadowbase replication can feed data directly into a target database/environment via an API (e.g., MQ Series, Java Messaging Services, ODBC, etc.)

Database Specification (DBS) Mapping

A scripting “language” for target-side other-server platforms that can drop all or specific events for a target table, convert updates to inserts, drop column(s), concatenate (text) columns, and convert or replace formats and characters.

Contact Us

Limitless Transformation Options

There are a number of Shadowbase parameter settings that assist with data transformation, such as converting non-printable binary data in a character field to spaces. However, these settings work on the data record at an aggregate level, and not at a field level.

Contact Us