Business Intelligence (BI)
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
Data Masking/Protection
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
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
Data Masking/Protection
Our first article on data replication in the IRI Workbench GUI for NextForm (DB edition) or Voracity demonstrated how to copy and transform data as it moved from Oracle to two targets.
Read More
Big Data
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(!) SQL and IRI facilities in Workbench, you must first make a JDBC connection1 to your database from the DTP’s Data Source Explorer view.
Read More
DAM/DAP
IRI Chakra Max is a database firewall product designed to perform data-centric audit and protection (DCAP) for information in multiple database platforms. It does so through:
Setting database access permissions Controlling SQL statements so only approved syntax on tables is allowed Masking sensitive data dynamically as it is extracted from a tableIn this article, we focus on the creation and application of a dynamic data masking security policy in Chakra Max.
Read More
ETL
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 or .cmd, while Linux and Unix usually have .sh or no extension at all.
Read More
Business Intelligence (BI)
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 scripts based on the SortCL program language, which covers IRI Voracity ETL, CDC, SDC, pivoting and subsetting jobs, as well as its constituent product jobs; i.e., IRI CoSort (transformation and reporting), NextForm (migration and replication), FieldShield (data masking), and RowGen (test data) jobs.
Read More
Data Masking/Protection
This is the second of two articles on creating a new IRI Voracity® ETL job flow from the job design Palette in the IRI Workbench, built on Eclipse.
Read More
Data Masking/Protection
In this demonstration, the Multi-Table Protect Job Wizard in the IRI Workbench GUI for Fieldshield and Voracity is used to define a rule for data in multiple Oracle tables.
Read More