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.
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.
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.
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.
Note: Shadowbase replication can feed data directly into a target database/environment via an API (e.g., MQ Series, Java Messaging Services, ODBC, etc.)
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
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