{"id":16996,"date":"2024-01-05T21:26:00","date_gmt":"2024-01-06T02:26:00","guid":{"rendered":"https:\/\/www.iri.com\/blog\/?p=16996"},"modified":"2025-02-10T16:59:11","modified_gmt":"2025-02-10T21:59:11","slug":"schema-data-class-search-2","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/data-protection\/schema-data-class-search-2\/","title":{"rendered":"Schema Data Class Search"},"content":{"rendered":"

The Schema Data Class Search wizard in <\/span>IRI Workbench<\/span><\/a> (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<\/a> (metadata) and\/or data<\/a> (content) matchers that you previously associated with specific <\/span>data classes<\/span><\/a> (like email addresses, names, phone numbers, etc.).<\/span><\/p>\n

The search process compares your data class matchers with column data it scans to determine the best matches, if any. The wizard then combines the results of data discovery and classification with your data class masking rules, and records this mapping to a file called the <\/span>Data Class Map<\/span><\/a>. It also produces several search logs and aggregate visuals<\/a><\/span>.<\/span><\/p>\n

Why Perform a Schema Data Class Search?<\/b><\/h5>\n

As mentioned above, a Schema Data Class Search will perform data discovery on multiple schemas and produce a Data Class Map. The Data Class Map is used by several wizards, including the <\/span>New Data Class Map DB Masking Job<\/span><\/i> wizard in <\/span>IRI FieldShield<\/span><\/a>, to automatically create job scripts for masking structured data in one or more RDB tables in one or more schemas.<\/span><\/p>\n

Prerequisites<\/b><\/h5>\n

Before performing a Schema Data Class Search operation some initial setup steps are required.<\/span><\/p>\n

    \n
  1. An IRI Project must be present in the workspace (Workbench project folder).<\/span><\/li>\n
  2. There must be a Data Class & Rule Library (.<\/span>dcrlib<\/span><\/i>) available that contains at least one Data Class. You have the option when first creating an IRI project to generate a Data Class & Rule Library pre-populated with some default Data Classes and Rules.<\/span><\/li>\n
  3. A connection profile is required to read from and scan the data inside tables of a schema during the process of a Schema Data Class Search.<\/span><\/li>\n<\/ol>\n

    To learn more about Data Classification and Data Classes read this <\/span>article<\/span><\/a>.<\/span><\/p>\n

    Several articles and videos discuss making <\/span>connections to different databases<\/span><\/a> inside IRI Workbench; e.g.,\u00a0<\/span><\/p>\n