Metadata Conversion Tools for CoSort SortCL Users. Support for Copybooks, UMG, XML, etc. CoSort Products

Home » Products » CoSort » Metadata Converters

Automatic Metadata Migration Tools

» Products

CoSort (Transform)

Free Converters Leverage Your File Definitions

CoSort Version 9 offers several tools to translate your existing file layout (and sort job) metadata. With these included utilities, you can re-use your data (and certain job definitions) in CoSort's data manipulation and management tool, SortCL. IRI has also partnered with a leading metadata conversion company (MITI) to automatically create SortCL-ready file layouts from major BI, ETL and relational data tools.

About SortCL Metadata

SortCL's explicit text-based metadata is straightforward and self-documenting -- making it easy to learn, use, and audit. You can store your files' field (column) layouts in reusable Data Definition File (.ddf) repositories. You can paste or reference these definitions in your SortCL job script. SortCL (and RowGen) use /FIELD= statements to identify column:

• Names or Aliases
• Sizes or Ranges
• Positions or Delimiters
• Data Types
• Conditions and Expressions
• Security and Other Functions

Third-Party Metadata

File layout translators included in the CoSort package can migrate your existing field/column descriptions into SortCL (and RowGen) .ddf repositories. These tools can reduce or eliminate the overhead associated with migrating metadata to a .ddf from:

• COBOL copybooks (cob2ddf)
• comma-separated values (csv2ddf)
• W3C extended log format (elf2ddf)
• Oracle SQL*Loader control files (ctl2ddf)

Therefore, if you already have file layouts defined in the above applications, you can automatically reproduce that metadata for use in large SortCL manipulation jobs -- or in RowGen, for generating safe test data in those same file formats.

If your file layouts exist in other formats (including CWM, DSX, UML, XMI and XML), consider that Meta Integration Technology, Inc. (MITI)'s Meta Integration Model Bridge (MIMB) will convert these repositories into SortCL .ddf syntax as well!

Whether you use a metadata converter that IRI, MITI, a consultant, or your own company develops, the benefit is clear -- not having to re-create metadata you already own.

Sort Program Metadata

You can also access free mvs2scl, vse2scl, and ssu2scl utilities to convert your legacy sort parms. For many jobs, the automatic result can be an equivalent SortCL job specification file containing the input and output field layouts. Where automation falls short, manual conversion is not difficult.

Another CoSort tool -- called sorti2scl -- converts CoSort's sort interactive (SortI) program job specifications into their SortCL job equivalents.

IRI, The CoSort Company