Migrate: Powerful Capabilities

Validate your source data with extensive interactive query capabilities
Access even your most complex mainframe data directly
Transform, cleanse, and convert your data with over 80 built-in functions
Non zSeries mainframe servers
Combine multiple tables
Load the target system

Validate your source data with extensive interactive query capabilities

Migrate uses our Analyzer application to offer a powerful set of analytic capabilities to complement its data access. Using a simple point-and-click interface you can create an almost limitless variety of analyses. Exception reports can be generated based upon virtually any criteria you can conceive. You also have the ability to sort, summarize, subset and otherwise process the data to better highlight other possible data problems.

You can check the referential integrity of your data, scan for blank or invalid data values, check for inconsistent data, confirm data formatting, or even identify every unique code value used within a column. All of this is just a few clicks away.

Even this is just the start. Analyzer includes a wide range of column statistics, stratification, sequence, gaps, duplicates and exception testing as well as cross tabulation. These can be combined with the transformation and manipulation capabilities to support virtually any analytic requirement.

Access even your most complex mainframe data directly

Unlike many alternatives, Migrate is not limited to accessing your warehoused data. Instead, it specializes in directly connecting you with your native mainframe legacy data. Virtually any data file, regardless of complexity or native data type can be easily assimilated with your Windows applications.

No matter how complex your legacy data, Migrate creates a virtual SQL table (rows and columns) that allows you to easily perform any type of analysis or transformation in support of your data migration, in real time, without copying the data.

Transform, cleanse, and convert your data with over 80 built-in functions

When creating table definitions, you are not limited to describing the physical data. You may also present any transformations, calculations or processes as “virtual” columns that fit your needs. For example, if names in your mainframe file are stored as “SMITH, JOHN P” and you need them to appear as “John P. Smith”, no problem. A simple virtual column will process this transformation dynamically, without altering the source data. You can transform or combine columns in any way you wish with Arbutus’s extensive library of operators and functions.

Best of all, you can create entirely new virtual columns that display information not even present in the source data. Add, subtract, multiply or divide two or more columns, use tests to interpret transaction codes, or deal with negative and out-of-range values. Convert a date column to a text column, or use a data mask to present phone numbers in the preferred local format. The more than 80 built-in data manipulation functions allow almost unlimited control over the presentation of data.

Arbutus’s comprehensive semantic and transformation layers allow the implementation of virtually any data interface or business rule. You are not limited to merely exposing the data, but can actually fit it to your needs.

Non zSeries mainframe servers

Migrate offers direct data access to zSeries (MVS, OS/390, zOS) mainframes, as well as Linux and Windows Servers. Where your source system is not one of these platforms, Migrate is still able to meet your needs. The reason is each of these servers is also fully compatible with data from each other, as well as a wide range of alternative platforms, such as DEC and HP. All you need to do is transfer the raw unconverted files to one of Arbutus’s open servers ( Windows or Linux) and then proceed as if this were the source system. As always, results are guaranteed.

Combine multiple tables

Often the most challenging data migration issues are those involving more than one table or data source. With Migrate’s Data Relations feature, a simple click and drag allows you to join tables “virtually”, creating a unified view of the data.

You can also take columns from two or more tables to create a new joined copy.

Finally, you can append rows from one table to another, extract selected rows, or create summary tables based on selected columns from one or more existing tables.

Experts in data structures will be pleased to see that the technology can handle the most complex operations involving redefined or overloaded data, multiple record-types and variable record-length files.

Load the target system

Migrate offers a variety of options to load the data into the target application:

• Where the target system is hosted in a non-Windows SQL system, such as Oracle, Migrate would generally produce a fixed length or comma separated file to interface with the database’s bulk load facility.
• Where the target is a Windows based database, such as SQL Server, the data can be directly loaded using the Arbutus LegacyLink™ ODBC driver.
• Where the target system is not a database, Migrate’s extensive data manipulation capabilities can be used to output files in an appropriate format.