{"id":16785,"date":"2024-01-04T02:24:56","date_gmt":"2024-01-04T07:24:56","guid":{"rendered":"https:\/\/www.iri.com\/blog\/?p=16785"},"modified":"2026-10-21T17:14:22","modified_gmt":"2026-10-21T21:14:22","slug":"finding-and-masking-pii-in-relational-databases-with-the-darkshield-rdb-wizard","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/data-protection\/finding-and-masking-pii-in-relational-databases-with-the-darkshield-rdb-wizard\/","title":{"rendered":"Masking RDB Data in the DarkShield GUI"},"content":{"rendered":"

Editor’s Note:<\/strong> This article is part of a series about using IRI DarkShield to discover and mask sensitive data in relational databases. DarkShield’s support for relational database (RDB) sources can complement or, in certain use cases, replace IRI FieldShield<\/a> <\/span><\/i><\/em>for similar data classes, location-based searches, and masking functions for certain use cases<\/a>.<\/span><\/i><\/em><\/p>\n

Introduction<\/h2>\n

IRI DarkShield<\/span><\/a>\u00a0provides specialized wizards in the IRI Workbench<\/a> integrated development environment (IDE) for finding, classifying, and masking sensitive data in different sources.\u00a0These include structured, semi-structured, and unstructured files, NoSQL databases, and relational databases (RDBs). DarkShield supports relational databases accessible through a JDBC driver connection.<\/p>\n

This article focuses on using the DarkShield Relational DB Search\/Masking Job wizard to discover and mask personally identifiable information (PII) stored in relational databases. It explains the prerequisites, configuration steps, masking rules, and job execution options using an example database.<\/p>\n

The following diagram illustrates the DarkShield architecture and its components. The wizard demonstrated here runs within IRI Workbench.<\/p>\n

\"IRI<\/p>\n

DarkShield also provides other source-specific wizards, including the New File Search\/Masking Job<\/strong><\/a> wizard for files and the New NoSQL DB Search\/Masking Job<\/strong><\/a> wizard for NoSQL databases. Those workflows are outside the scope of this article.<\/p>\n

What the DarkShield Relational DB Wizard Does<\/h2>\n

The New Relational DB Search\/Masking Job<\/strong> wizard in IRI Workbench creates a DarkShield job configuration file with the .dsc<\/code> extension. The file contains the Search Contexts and Mask Contexts required for the specified database operations.<\/p>\n

These contexts serve different purposes:<\/p>\n