Joining Flat-File & RDB Data: Textual ETL (Part 2)
IntroductionThis article demonstrates the Voracity user’s ability to join values in a flat-file file to those in an RDB (Relational Database) table to provide meaningful information. Read More
Oracle TLS Support
To configure both JDBC and ODBC to support the Transport Layer Security (TLS) protocol, there are additional configuration steps that are needed when compared to this previous article. Read More
Textual ETL: Unlocking Unstructured Data
SynopsisCorporations and government agencies store a lot of useful information in non-transactional semi-structured and unstructured data sources. Finding that data – in documents, logs, and images – is important not only for data masking, but also for textual ETL. Read More
SQL Server SSL Connection
Since SQL Server has changed the functionality and default behavior of their driver, this article will go over the basic ODBC and JDBC connections required for the IRI software backend (CoSort SortCL engine in Voracity) and job design front-end (IRI Workbench, respectively, to Microsoft SQL Server databases on-premise or in the cloud which use encrypted connections. Read More
Navigating DPDPA Compliance
IntroductionThe enactment of the Digital Personal Data Protection Act (DPDPA) 2023 on August 11, 2023, marks a significant evolution in India’s data protection landscape. This new legislation introduces stringent requirements for the management and protection of personal data and tries to balance individual rights and organizational responsibilities. Read More
Bloor Research on Data Classification in IRI Voracity
IRI Voracity is a data management platform that we have previously talked about at some length. It offers capabilities for data integration, data governance, data masking, test data management, data quality, data cleansing, data migration, and so on (and on, and on). Read More
IRI Voracity and Data Fabric
Innovative Routines International (IRI) was founded in 1978 and is headquartered in Melbourne, Florida. Incidentally, IRI should not be confused with another venerable data-driven company called IRI (Information Resources, Inc) based in Chicago, which just rebranded as Circana after a merger. Read More
DarkShield PII Discovery & Masking Charts
As you may already know, IRI DarkShield produces search annotations and masking results with every operation. These log files can contain a large volume of data, including:
metadata about the file/database source(s) what data was found as a match which matcher matched the data how the data was masked (if it was) where matches occurred within each file or database. Read More
IRI Data Class Map
In past articles we have discussed the Data Class & Rules Library and leveraged this library in data classification processes (Schema Data Class Search and Directory Data Class Search), that in turn produce a file called a Data Class Map. Read More
Schema Data Class Search
The Schema Data Class Search wizard in IRI Workbench (WB) designs search jobs for (PII or other) data in relational database schemas. The searches you configure in the wizard will compare data in entire schemas to location (metadata) and/or data (content) matchers that you previously associated with specific data classes (like email addresses, names, phone numbers, etc.). Read More
Masking RDB Data in the DarkShield GUI
Editor’s Note: This article is part of a series of articles on using DarkShield to search and mask sensitive data in relational databases. This new support for RDB sources in DarkShield can augment or replace IRI FieldShield support for the same data classes, locational searches and masking functions for certain use cases. Read More