HPE Shadowbase Data Management Utilities

HPE Shadowbase Data Definition Language (SBDDLUTL)

Many Enscribe users need to replicate their Enscribe data into external systems and environments, for example, to feed a data warehouse. This process is usually accomplished by converting the Enscribe information into standard SQL data structures and schemas.

The HPE Shadowbase Data Definition Language Utility (SBDDLUTL) is a command line interface (CLI) database schema conversion tool which converts an Enscribe record definition (which is naturally hierarchical) into a SQL schema definition (which is naturally a ‘flattened’ structure). The SBDDLUTL feature is available as part of the HPE Shadowbase Data Management Utilities product bundle. Please note that this is only an overview of SBDDLUTL. For more information, please reference our SBDDLUTL Solution Brief or contact us.

Key SBDDLUTL Features

  • Creates a flattened Enscribe DDL definition from the original hierarchical Enscribe DDL definition
  • Creates a SQL CREATE TABLE DDL statement from the flattened Enscribe DDL definition
  • Maps Enscribe DDL fields/data types into equivalent SQL columns/data types
  • Converts Enscribe DDL REDEFINES structures and ARRAYS/OCCURS clauses into uniquely-named and normalized SQL target columns
  • Alerts if the target SQL environment does not support any of the source Enscribe DDL definitions, allowing for user input to either correct or disregard the offending data structures
  • Supports a powerful command language to manage the metadata conversion environment (e.g., for target column naming conventions or for ARRAY processing rules)
  • Can be run on any NonStop system, even if no NonStop SQL/MP or SQL/MX license exists

SBDDLUTL allows the user to view Enscribe DDL schemas, and includes a variety of useful formatting commands to read, store, and manipulate Enscribe DDL file definitions. SBDDLUTL can:

  • read in existing DDL dictionaries,
  • set options,
  • perform conversions on the stored records,
  • and output the results to various destinations, including the terminal, an edit file as ASCII, or to a binary file as a serialized Google Protocol Buffer.

For the commands with extensive output, SBDDLUTL can redirect output to an edit file with the default file write access. If necessary, the utility can change the default file write access for an input/output operation by adding a modifying character at the end of the specified file name. To specify unique data type conversions, the user can use the command: “SET TYPE <type> for <fully qualified field name>,” which allows the user to set the data type for the specific field. Additionally, “REPLACE <source type> with <target type>” allows broad, global datatype changes with some intelligent wildcarding. Please refer to the SBDDLUTL manual for additional details.

Related Solution Brief: