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 mappings and manipulations, and data source and target layouts (including formatted reports) in IRI CoSort and its spin-offs:

  • IRI NextForm, for data and DB migration and replication
  • IRI FieldShield, for PII data profiling, masking, and auditing
  • IRI RowGen, for test data generation and management
  • IRI Voracity, for data discovery, integration, migration, governance, and analytics

SortCL is therefore what makes CoSort (and the IRI Voracity platform using it) a one-stop "super tool" for data transformation, conversion, quality, protection, and reporting. SortCL's extensive capabilities are detailed in the tabs above, and listed in this diagram under the CoSort logo:

and most of the data-driven functions shown in the Voracity schematic here:

No Experience Necessary


SortCL uses an open, explicit metadata to define and manipulate data in more than 125 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 jobs scripts and DDF layouts across the IRI ecosystem, and manage their use and lineage directly in Eclipse and through 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 use 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.