The SortCL Program

 

Next Steps
Overview Function Matrix Invocation & Logging Sample Uses Resources

SortCL


SortCL is the powerful data manipulation program and popular user interface driving almost every IRI software product. Short for Sort Control Language, SortCL is an award-winning fourth generation language (4GL), standalone executable, and callable library routine for managing structured and semi-structured data.

SortCL metadata and programs define and consolidate data mappings and manipulations. They support many data source and target formats (including custom reports) in IRI CoSort and its spin-offs:

  • IRI NextForm, for data and DB migration and replication
  • IRI FieldShield, for PII classification, masking, and auditing
  • IRI RowGen, for test data generation and management
  • IRI Voracity, which includes all of the above, supporting and combining multiple data discovery, integration, migration, governance, and analytic activities and use cases.

SortCL is therefore what makes CoSort and Voracity a one-stop, one-I/O "super tool" for data transformation, conversion, cleansing, mapping, and reporting. SortCL's extensive data manipulation and movement capabilities -- detailed in the tabs above, and listed in this diagram under the CoSort logo -- can be combined in a single job and pass through huge volumes of data.

SortCL performs the same consolidated tasks for Voracity licensees, who can see them illustrated in modern transform mapping diagrams. ETL and solution architects with big data appreciate the ability to combine data integration, remapping, cleansing, masking, and BI operations, and the dramatic differences they see in information delivery and compliance outcomes:

No Experience Necessary


SortCL uses an open, explicit metadata to define, manipulate and reformat their data in more than 150 disparate file and database sources. SortCL syntax is self-documenting; anyone can read, recognize, and modify SortCL programs with ease.

SortCL uses simple English statements based originally on VMS sort parms and now also familiar SQL, C, and Perl expressions. Unlike cryptic ETL, 3GL, and MapReduce programs, no training is needed to understand what a SortCL script will do.

But for those who cannot or simply will not learn another language, there's a powerful GUI to save them from it. IRI Workbench is a graphical integrated development environment (IDE), built on Eclipse,™ for creating, running, sharing, and modifying SortCL jobs, and their "data definition file (DDF)" source and target layouts.

Did You Know?

SortCL was introduced in 1992. It remains so widely adopted because it is uniquely explicit, open, and powerful. SortCL has met its design goals to be:

  • modular, so you can keep adding functions into the same I/O pass
  • extensible enough for complex data transformations and reporting
  • so clear that anyone can create, modify, re-use, and share its jobs
  • familiar to JCL users, SQL-savvy DBAs, and DW/BI data architects
  • far faster than ETL tools, and without using DBs or bigger servers
  • executed (not compiled!) in real-time, batch, CLI, API, and GUI ops
  • portable, so its jobs run on all Unix, Linux, and Windows platforms
  • easily integrated into new applications, SaaS uses, or ASP models

SortCL job scripts perform, speed, and/or combine: big data transformation, conversion, protection, and BI in the world's largest production environments.

Metadata Interoperability


Quickly find and re-use SortCL metadata in multiple IRI products and projects to meet your data processing, protection, presentation, and prototyping requirements. Use SortCL job scripts and DDF layouts across the IRI ecosystem, and manage their use and lineage directly in Eclipse or available cloud repositories like Git, CVS, and SVN.

SortCL DDF is also compatible with the AnalytiX DS Mapping Manager, and the Meta Integration Model Bridge (MIMB) from Meta Integration Technology, Inc. Convert the metadata already used in your BI, CRM, database, ETL, and modeling tools, into the metadata used in all IRI software. This preserves your investment in existing metadata, and allows you to more quickly leverage the benefits of IRI software running with (or instead of) those applications.

Request More Information

Live Chat

* indicates a required field.
IRI does NOT share your information.