Home » Solutions » Data Transformation2
High-Volume Data Transformation 
» Solutions
Business Intelligence
Data Governance
Data Transformation
Select/Filter
Sort/Merge
Match/Join
Aggregate
Cross-Calculate
Re-Map/Reformat
Scrub/Cleanse
Substrings
Table Lookups
Type-Convert
Custom Transforms
ETL/DB Acceleration
Field Protection
File Interchange
Sort Migration
Test Data/Files
CoSort Works With, and Speeds, Your Applications

The SortCL data transformation tool within IRI's CoSort package also works hand-in-hand with unload tools. For Oracle and DB2, SortCL takes piped data from the CoSort-compatible FAst extraCT (FACT) tool, 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
• Facilitate reorg and ETL operations
• Product load and file-compare metadata
CoSort 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 the CoSort package can accept many third-party data layouts (e.g. COBOL copybooks, CSV, LDIF and XML files, CLF and ELF web logs, and SQL*Loader Control File metadata.

Meta Integration Technology, Inc. (MITI) has also created a metadata model bridge (MIMB) spoke to SortCL's data definition file format. As a result, if you have file layouts already defined for popular ETL tools like Informatica or DataStage, MIMB can automatically produce the equivalent layouts for use in SortCL. Thus you can run CoSort with your other tools, but without having to manually redefine your metadata.

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
case studies Case Studies
white papers White Papers
» Next Steps
1-800-333-SORT
1-321-777-8889
livechatLive Chat
request additional infoRequest Info
find agentFind Agent
eval requestDownload Demo
page feedbackGet Newsletter
page feedbackPage Feeback
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.