The Job Script Editor in IRI Workbench
The IRI Workbench GUI, built on Eclipse™, provides several ways to create data-driven jobs … jobs which are ultimately expressed in self-documenting plain-text scripts and metadata files. Read More
How to Build Realistic but Fake PII
There are times when it is necessary to test with or share data that has elements of personally identifiable information (PII). To comply with data privacy laws and prevent a data breach, you may need to provide data that reflects, and sometimes imparts, critical information, but still protects the PII. Read More
The Formidable but Imperative Task of IoT Security
The Internet of Things (IoT) continues to grow at an unbelievable rate, and creates tremendous benefits and opportunities for society. With it grows the demand for products and services that control, manage, and protect the massive amounts of data streaming from all those network-connected devices. Read More
How to Run Remote Jobs from IRI Workbench
This article covers the creation and use of remote server connections from IRI Workbench so you can run CoSort (Voracity), NextForm, FieldShield, or RowGen scripts on other computers. Read More
Creating & Executing SQL Statements in IRI Workbench
Among the many database-centric features in IRI Workbench is the ability to create, modify, and execute SQL statements manually or graphically. These “SQL scrap-booking” features are available through the free Data Tools Platform (DTP) plug-in for Eclipse, which also supports IRI job wizards for database:
profiling, searching, classification, E-R diagramming, and integrity checking integration, including ETL, pivoting, slowly changing dimensions, and change data capture column masking, including format-preserving encryption, redaction, and pseudonymization subsetting, test data generation, and bulk loading migration, replication, and offline reorgsTo use the cross-platform(!) Read More
What is Data Security Governance?
The Latest Data Risk LandscapeEnterprise data continues to change rapidly in form, size, use, and residence. Rarely does it remain in siloed constructs anymore, limited to certain business units or untouched by the outside world. Read More
IoT & IRI – Aggregation on the Edge
As a follow-on to my introduction to IoT and MQTT, this article describes how device data collected from standard climate sensors and sent through an MQTT (Message Queuing Telemetry Transport) server can be rapidly and inexpensively pre-aggregated by a single SortCL program (in IRI CoSort) on a tiny edge device or gateway. Read More
An Introduction to IoT & MQTT
This article introduces the concept of the Internet of Things (IoT) and the popular, lightweight Message Queuing Telemetry Transport (MQTT) protocol for moving data from IoT devices into processing frameworks. Read More
Using Wicked Shell in IRI Workbench
As we transition IRI Workbench to the Neon version of Eclipse™ in 2017, the Easy Shell feature that facilitated command-line executions of job and batch scripts will no longer be available. Read More
Executing ETL & Batch Flows
Batch files contain commands in plain text that can be executed by the command line interpreter of the operating system to accomplish a specific purpose. Windows batch files usually have an extension of .bat Read More
Single Job Execution Options in IRI Workbench
IRI Workbench not only has several ways to create jobs, but also several ways to execute them.
This article focuses on IRI Workbench execution options for job scripts based on the SortCL program language, which covers IRI Voracity ETL, CDC, SDC, pivoting and subsetting jobs, as well as its constituent product functions; i.e., Read More