MDTransform

Simplified Data Transformation for Testing and Database Changes

MDTransform helps you move, reshape, and prepare data on IBM i with repeatable, auditable processes.

Integrate with your change pipeline so transformed data is ready when you need it for testing, migrations, or cutover.

Reduce manual scripting and handoffs—define transformations once and apply them consistently across environments.

MDTransform automated data transformation
You can have a ridiculously enormous and complex data set, but if you have the right tools and methodology, then it's not a problem.

Aaron Koblin – Known for transforming complex data into structured, repeatable, and meaningful outputs

Popular Use Cases

Database Modernization

Manage DDS to DDL implementation accurately & efficiently. Integrate required data changes across entire databases, including quality and integrity checks.

Field Expansion

Confidently automate managing field expansions, initializing new fields, merging fields. No need for writing complex SQL programs. Measure data quality before implementations, reducing downtime and errors.

Test Data Management

Use Data Copy Templates to identify selection criteria for building and maintaining test data. Trigger test data refreshes at build or scheduled intervals. Reuse, rollback or restore test data as part of installation processes.

KEY FEATURES | KEY FEATURES | KEY FEATURES

Template Based System

Improves productivity and quality using policy-based templates for all data movement during development.

Transformation SQL Generation

Default transformation SQL created. No need to write transformation programs with every change.

SQL Based

The full power of SQL can be used, customized or created for any transformation use case.

Pre-Installation Validation

Data transformation validation takes place before implementing application changes. Avoids unnecessary downtime in production.

Manual, Event or Scheduled

Data Transformation can be manually started, triggered as part of installations or scheduled for more suitable times.

Integration with MDRapid

Handle even the largest table change installations with virtually no downtime using MDRapid.

Speak To Our Experts

For more info, a live demonstration, or to discuss your business and technical needs with the Midrange Dynamics team.

Request Info