Home » Solutions » Data Transformation2
High-Volume Data Transformation 
Work With, and Speed, Your Applications
CoSort's SortCL data transformation tool also works hand-in-hand with unload tools. For Oracle and DB2, SortCL takes piped data from CoSort's FAst extraCT (FACT) and pipes it pre-sorted into database load utilities like SQL*Loader.

SortCL's familiar and intuitive data definition language (DDL) uses symbolic field-names and metadata repositories to:
• Map sources to targets
• Reduce script sizes and creation times
• Speed table creation, load and file-compare metadata

SortCL job scripts contain SQL-like data manipulation language (DML) commands that use and/or reference those data layouts.

4GL SortCL jobs get run from the command line, in batch scripts, from 3GL programs, and via a state-of-the-art, cross-platform Java GUI. SortCL and related facilities in CoSort can accept many third-party data layouts (e.g. COBOL copybooks, CSV, CLF and ELF web logs and SQL*Loader Control File metadata. Meta Integration Technology, Inc. (MITI) has created a metadata model bridge (MIMB) for SortCL's data definition file format so you can leverage your tool's file layouts in adjacent SortCL jobs.

SortCL, as with other CoSort user interfaces, exploits CoSort's granular performance tuning and flexible CPU licensing. Continuing innovation in parallelism, I/O, data manipulation routines, and industry partnerships keep CoSort at the leading edge of commercial data sorting and related file processing.

See also:
Solutions > Business Intelligence > Reporting Functions
Solutions > ETL/DB Acceleration
Solutions > Field Protection
Solutions > File Interchange
Products > CoSort
Products > CoSort > SortCL
Products > CoSort > SortCL > Metadata
make text smaller make text larger print this pageemail this page
» Resources
» Next Steps
1-800-333-SORT
1-321-777-8889
Did you find what you were looking for on this page?
YesNoUnsure

What you were looking for:

Include your email address if you would like a response.

 
With CoSort, you can run end-to-end reorg and flat-file data warehouse extract-transform-load (ETL) operations at the industry's highest data volume and performance levels.