The SortCL Program

 

Transform, Cleanse, Mask, Map, Report

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 the name of IRI's

 

  1. award-winning fourth generation data definition and manipulation language (4GL)
  2. standalone data handling executable that follows those 4GL instructions
  3. internal, callable library routine that the executable (or your 3GL program) calls internally to process data

 

SortCL scripts and jobs describe and consolidate data mappings and manipulations. They support many data source and target formats (including custom reports) in IRI CoSort and its spin-off products:

  • 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 use cases. The Hadoop-enabled edition of Voracity can also run several SortCL programs interchangeably in MapReduce 2, Spark, Spark Stream, Storm, and Tez.

 

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 movement and manipulation capabilities -- detailed in the tabs above, and listed in this diagram under the CoSort logo -- can run in a single job and pass through huge volumes of data.

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

No Experience Necessary

 

SortCL uses an open, explicit metadata to define, manipulate and reformat 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 also familiar SQL, C, and PCRE syntax. 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, read, re-use, and expand 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 Erwin (ex-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.