ETL
To make data usable for intelligent models and predictive analytics, it may need to be extracted from a database and rapidly transformed. This is where a robust database unload tool comes into play. Read More
Data Masking/Protection
Public and private cloud file systems are becoming increasingly popular places for businesses and government agencies to store their data. Several major competitors have arisen in the cloud storage provider space, with Amazon, Microsoft Azure, and Google Cloud Platform at the top. Read More
ETL
Data flowing through application development, machine learning, and analytic pipelines must address several needs common to all three, including:
Realism, to reflect production data characteristics and application test requirements; Compliance, with business and data privacy rules, plus DB and analytic models; Availability, or security, of the data (depending on your perspective); and, Auditability, for lineage and accountability. Read More
Big Data
Finding and masking personally identifiable information (PII) in Snowflake® data warehouses works the same way in IRI FieldShield® or Voracity® installations as it does for other relational database sources. Read More
Business Intelligence (BI)
Abstract Syntax Notation One (ASN.1) is a language for describing the content and encoding of message data exchanged between computers (particularly in the telco industry). Read More
Data Transformation
This article is the third of four articles discussing newly added support for Excel files in the core IRI program for structured data definition and manipulation, SortCL. Read More
Business Intelligence (BI)
This article is a continuation of the previous article, which introduced IRI support for XLS and XLSX file formats in the IRI SortCL 4GL and runtime program used for rapidly manipulating spreadsheet data in the IRI Voracity data management (ETL, data quality, etc.) Read More
Business Intelligence (BI)
In addition to all the other structured data sources that IRI software already supports, it is now possible to read, process and write data from and to XLS and XLSX files in the SortCL program central to:
IRI CoSort, for fast sorting, transformation, and reporting IRI NextForm, for mapping, migration, and replication IRI RowGen, for random selection or generation of realistic test data IRI FieldShield, for sensitive data masking IRI Voracity, for all the above, plus ETL, data cleansing, and wrangling for analyticsand to write the resulting data back to those or other targets, including one or more Excel sheets. Read More
Business Intelligence (BI)
The names of IRI software products and how they run have at times been a source of mystery, or even confusion, to the uninitiated. This article spells out the pieces and clarifies their interplay, providing a quick primer for prospective users, partners, and new industry analysts. Read More
Data Masking/Protection
Incremental data replication, masking, integration (ETL), and other data refresh operations are common in frequently updating database environments. These jobs require the detection of additions and updates to tables. Read More