MDTransform


Manage Database File Changes and Data Transformation

Are database modernization projects or file expansions on your horizon?

IBM i development teams modernizing application architecture with SQL, or just modifying existing file structures, will appreciate the data transformation capability within MDCMS.

Complex SQL syntax and conversion programs can become a thing of the past with MDTransform. It helps you quickly map and manage database file changes, and it even generates SQL scripts. Development teams are only limited by what SQL can do.

Using MDTransform, confidently automate managing field expansions, initializing new fields, merging fields, and managing deployment of DDS to DDL conversions. It also handles field type changes such as numerical to string, string to graphical, and vice versa, with ease.

MDTransform for IBM i guides users through the steps to easily add and populate new fields or update field content. Behind the scenes, it builds and executes a dynamic SQL insert to populate the new version of the file.

Data transformation results are validated during the compile phase to avoid any surprises during installation. In fact, users can view, customize, and validate conversion results when the transformation occurs.

Build and Refresh Test Data

Providing reliable test data is critical for any test plan. MDTransform uses MDCMS Data Copy Templates to identify selection criteria for building and maintaining test data. Select which files, and which records in the file, you need. MDTransform can even initiate column-specific masking of confidential data. Development and QA teams can quickly refresh data whether it resides on the same or different partitions. Templates may be saved, copied, and reused, and data transfer can occur dynamically or be scheduled for periodic refreshes.

MDTransform can be accessed from MDCMS Object Manager or from MDOpen, the Eclipse-based plug in to MDCMS. It is an optional MDCMS feature available for a nominal fee. Midrange Dynamics users who would like to check out the new functionality may request a free 30-day license key.

Download a PDFSchedule a Demo

“The product is solid, and the support we’ve received has been great. We believe Midrange Dynamics has a solid commitment to their product, which gives us a lot of confidence in relying on it for our change management.”

– Dave Easton, VP of IT – MBS Textbook Exchange, Inc.