{"id":17024,"date":"2024-01-09T20:36:14","date_gmt":"2024-01-10T01:36:14","guid":{"rendered":"https:\/\/www.iri.com\/blog\/?p=17024"},"modified":"2025-02-26T08:00:06","modified_gmt":"2025-02-26T13:00:06","slug":"data-class-mapping-in-iri-workbench","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/","title":{"rendered":"IRI Data Class Map"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">In past articles we have discussed the <a href=\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-classification\/\">Data Class &amp; Rules Library<\/a> and leveraged this library in data classification processes (<a href=\"https:\/\/www.iri.com\/blog\/data-protection\/schema-data-class-search-2\/\">Schema Data Class Search<\/a> and <a href=\"https:\/\/www.iri.com\/blog\/data-protection\/directory-data-class-search-wizard\/\">Directory Data Class Search<\/a>), that in turn produce a file called a Data Class Map<\/span><span style=\"font-weight: 400;\">.\u00a0<\/span><span style=\"font-weight: 400;\">For the topic of this article, I will discuss what a Data Class Map is and how to leverage different options for working with, and leveraging them, in the <\/span><a href=\"https:\/\/www.iri.com\/products\/workbench\"><span style=\"font-weight: 400;\">IRI Workbench<\/span><\/a><span style=\"font-weight: 400;\"> IDE.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">A Data Class Map is a file (.dataClassMap) used in Workbench to record mappings between fields and data classes and\/or field (masking) rules. The Data Class Map file is used in both the<\/span>\u00a0<a href=\"https:\/\/www.iri.com\/blog\/data-protection\/masking-pii-in-a-relational-db-with-fieldshield\/\"><i><span style=\"font-weight: 400;\">New Data Class Map <\/span><\/i><span style=\"font-weight: 400;\">DB<\/span><i><span style=\"font-weight: 400;\"> Masking Job <\/span><\/i><\/a><span style=\"font-weight: 400;\">and the <\/span><a href=\"https:\/\/www.iri.com\/blog\/data-protection\/masking-flat-files-in-the-fieldshield-gui\/\"><i><span style=\"font-weight: 400;\">New Data Class Map <\/span><\/i><span style=\"font-weight: 400;\">File<\/span><i><span style=\"font-weight: 400;\"> Masking Job <\/span><\/i><\/a><span style=\"font-weight: 400;\">wizards in the IRI Workbench <a href=\"https:\/\/www.iri.com\/products\/workbench\/fieldshield-gui\">GUI for FieldShield<\/a> to produce FieldShield data masking job scripts. <\/span><\/p>\n<p>The data class map has mappings of fields of a data source to rules, which are assigned based on data classifications. The data class map is only used with FieldShield, and can generate its SortCL-compatible FieldShield Control Language (.fcl) job scripts by right-clicking on the file and going through the corresponding file mask or database masking wizard.<\/p>\n<p>A Data Class Map is not to be confused with a <a href=\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-classification\/\">Data Class &amp; Rules Library<\/a> (.dcrlib), which is a library containing definitions of data classes and rules that are used by many wizards such as in the RowGen, NextForm, DarkShield, and some FieldShield wizards.<\/p>\n<h5><b>How to Create a Data Class Map<\/b><\/h5>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-17031 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/how-to-create-a-data-class-map-300x110.png\" alt=\"\" width=\"581\" height=\"213\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-create-a-data-class-map-300x110.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/how-to-create-a-data-class-map.png 512w\" sizes=\"(max-width: 581px) 100vw, 581px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">You can create a Data Class Map by going through one of the three wizards in the top toolbar menu for Data Discovery<\/span><span style=\"font-weight: 400;\">. The first wizard, <\/span><i><span style=\"font-weight: 400;\">Create Empty Data Class Map \u2026<\/span><\/i><span style=\"font-weight: 400;\"> steps you through the process of creating an empty Data Class Map (i.e. one containing no data class mappings).\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Next is the <\/span><a href=\"https:\/\/www.iri.com\/blog\/data-protection\/directory-data-class-search-wizard\/\"><i><span style=\"font-weight: 400;\">Directory Data Class Search <\/span><\/i><\/a><span style=\"font-weight: 400;\">wizard. This wizard steps through the process of performing data classification on files in directories on the local file system, and then generates a Data Class Map to map the fields in those files to your data classes and masking rules.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Finally, there is the <\/span><a href=\"https:\/\/www.iri.com\/blog\/data-protection\/schema-data-class-search-2\/\"><i><span style=\"font-weight: 400;\">Schema Data Class Search <\/span><\/i><\/a><span style=\"font-weight: 400;\">wizard that will walk you through the process of performing data classification on tables in a schema(s) to produce a Data Class Map containing mappings between columns in tables and data classes and rules.<\/span><\/p>\n<h5><b>Data Class Map Form Editor Parts<\/b><\/h5>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Data Class Map Tree View<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Data Class Map Main Details Page<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Table\/File Data Info Details Page<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Data Class Map Toolbar<\/span><\/li>\n<\/ul>\n<h5><b>Data Class Map Tree View<\/b><\/h5>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-17033 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/Data-Class-Map-Tree-View2-300x135.png\" alt=\"\" width=\"362\" height=\"163\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/Data-Class-Map-Tree-View2-300x135.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/Data-Class-Map-Tree-View2-350x159.png 350w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/Data-Class-Map-Tree-View2.png 353w\" sizes=\"(max-width: 362px) 100vw, 362px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The Data Class Map form editor provides an overhead view of the various tables and files data sources from a widget referred to as a <\/span><i><span style=\"font-weight: 400;\">Tree View<\/span><\/i><span style=\"font-weight: 400;\">. This Tree Viewer displays nodes that represent different items based on the associated icon.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">At the top level of the Tree viewer is a parent node <img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/_g_1tFWhuPyUdEgJ240vxBTOwUpIUlZD9DlbIv8eA63PB49am0AxIJ_o7yJU4n7pTd4BbtSNJSO6fb64o9gAhXy1gX6kV_xSLgHFV7uOyuE1oHcFQoI8u9RM2vno0C8smr12I-GOtXdVRDiZF2_pBpc\" \/> \u00a0 <\/span><span style=\"font-weight: 400;\">representation of the Data Class Map object. If you click on the parent node, information about the Data Class Map itself will be displayed on a page called <\/span><i><span style=\"font-weight: 400;\">Main Data Class Map Details<\/span><\/i><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For each table or file in a Data Class Map that contains mappings, there is a child node \u00a0<img decoding=\"async\" title=\"\" src=\"https:\/\/lh7-us.googleusercontent.com\/fzMrRT-uAM9cCnSvlmcbHuS_HfMnukJOZvYZ5_HpBUdqW1GsNPIzdPTOPl7C4_9qoLJM1OHOzhFJU6ndrJXMnPVPzzTXOaWzP1yVzfrRJwclo4d_R87cbcOhT9zaba2ubx7B8y8Kjpryhaqlt27mtcc\" alt=\"\" \/><\/span><span style=\"font-weight: 400;\">\/ <img decoding=\"async\" title=\"\" src=\"https:\/\/lh7-us.googleusercontent.com\/BRSK5lKLONHXhpsxhLFCG7Z080sFGnoS1SxWrpL9R8m1tX-64zwt8XmUDugbCiF97lu87fFU9ZzHpU7AJb0o6WdHCk8SqyHd4_JcutRfzWtNPMuxUwiitNgup_xEB5fhVray3hr-XIkh7zLdGErb3JM\" alt=\"\" \/> <\/span><span style=\"font-weight: 400;\">representation. Information on these tables and files and their mappings are displayed on a page called<\/span><i><span style=\"font-weight: 400;\"> Data Info Details, <\/span><\/i><span style=\"font-weight: 400;\">which you can view by clicking on these child nodes within the Tree Viewer.<\/span><\/p>\n<h5><b>Data Class Map Main Details Page<\/b><\/h5>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-17034 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/Data-Class-Map-Main-Details-Page-300x94.png\" alt=\"\" width=\"661\" height=\"207\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/Data-Class-Map-Main-Details-Page-300x94.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/Data-Class-Map-Main-Details-Page-1024x321.png 1024w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/Data-Class-Map-Main-Details-Page-768x241.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/Data-Class-Map-Main-Details-Page.png 1159w\" sizes=\"(max-width: 661px) 100vw, 661px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The Main Data Class Map Details page provides details about the data classes (and the rule applied to said data class) currently being used by the Data Class Map to perform operations like auto-classification on tables and files. You can scroll through the list of active data classes and double-click on entries to open a page called <\/span><i><span style=\"font-weight: 400;\">Data Class Details<\/span><\/i><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-17035 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/data-class-details-300x259.png\" alt=\"\" width=\"427\" height=\"369\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-details-300x259.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-details.png 510w\" sizes=\"(max-width: 427px) 100vw, 427px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The Data Class Details page allows you to see a list of fields the data class has mapped to across different tables and schemas or files. There is also a dropdown menu for changing the rule assigned to a Data Class. The Rules displayed in the dropdown menu are the rules internally stored in the Data Class Map.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To update the list of Rules accessible by the Data Class Map, you need to add a Rule to the .dcrlib and then perform a Sync and Update process from the Data Class Map toolbar. Toolbar options will be discussed further, below.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Note that when the Rule assigned to a Data Class is changed from this page, the Data Class Map will automatically update the fields that were mapped to that particular Data Class with the Rule that had been selected from the Default Rule field\u2019s dropdown menu.\u00a0\u00a0<\/span><\/p>\n<h5><b>Table\/File Data Info Details Page<\/b><\/h5>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-17036 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/table-file-data-info-details-page-300x245.png\" alt=\"\" width=\"730\" height=\"596\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/table-file-data-info-details-page-300x245.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/table-file-data-info-details-page-1024x837.png 1024w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/table-file-data-info-details-page-768x628.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/table-file-data-info-details-page.png 1103w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The Data Info Details page in the Data Class Map form editor displays various information about the data silo. Inside the Data Info Details page, there are three sections: the Table\/File Info, Field Mappings, and Data Preview.<\/span><\/p>\n<h5><b>Table\/File Info<\/b><\/h5>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-17037 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/table-info-300x87.png\" alt=\"\" width=\"680\" height=\"197\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/table-info-300x87.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/table-info-768x224.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/table-info.png 793w\" sizes=\"(max-width: 680px) 100vw, 680px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">In the case of a table, the Table Info section lists details about a table including connection information. When a Data Info Details page is associated with a file there is a File Info section instead. The File Info section likewise lists details about the file in question.<\/span><\/p>\n<h5><b>Field Mappings<\/b><\/h5>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-17038 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/field-mappings-300x105.png\" alt=\"\" width=\"660\" height=\"231\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/field-mappings-300x105.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/field-mappings-768x270.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/field-mappings.png 785w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The second section of the Data Info Details page displays a view of the field mappings after data classification has occurred. As you can see from the image above there are four columns: Column, Data Class, %Matching, and Field Rule.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The first column displays the column names of tables or files when the header is present in the file.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-17039 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/pasted-image-0-300x87.png\" alt=\"\" width=\"679\" height=\"197\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/pasted-image-0-300x87.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/pasted-image-0-768x223.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/pasted-image-0.png 1014w\" sizes=\"(max-width: 679px) 100vw, 679px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The second column displays what data class has been matched to a field if any. In this column, you can manually reassign or unassign the data class matched to a field.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If a data class is assigned to a field and also has a default rule, the Field Rule column will be updated to reflect the change to the new rule assignment for said field. Likewise, the %Matching column will be updated and indicate that a manual user assignment has occurred.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-17040 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/data-class-matching-300x209.png\" alt=\"\" width=\"332\" height=\"231\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-matching-300x209.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-matching.png 349w\" sizes=\"(max-width: 332px) 100vw, 332px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The third column shows the percentage of matches found using <\/span><a href=\"https:\/\/www.iri.com\/blog\/data-protection\/data-matchers\/\"><span style=\"font-weight: 400;\">data matchers<\/span><\/a><span style=\"font-weight: 400;\"> inside a data class. The percentage of matching is useful because we can assign depth of matching thresholds to our Data Class Maps to account for false positives or false negatives. On the other hand, if a match is found on a column name in a <\/span><a href=\"https:\/\/www.iri.com\/blog\/data-protection\/location-matchers\/\"><span style=\"font-weight: 400;\">location matcher<\/span><\/a><span style=\"font-weight: 400;\">, the keyword <\/span><i><span style=\"font-weight: 400;\">name<\/span><\/i><span style=\"font-weight: 400;\"> shows:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17041\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/keyword-name-300x83.png\" alt=\"\" width=\"949\" height=\"262\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/keyword-name-300x83.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/keyword-name-1024x284.png 1024w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/keyword-name-768x213.png 768w\" sizes=\"(max-width: 949px) 100vw, 949px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The fourth column displays the masking rule assigned to a column in a table or field in a file. In this column, you can manually reassign or unassign the rule that matches a field.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The rule you assigned determines how the data in a column (or field) will be masked when a FieldShield job is created. If a rule is manually assigned, the %Matching column will indicate that a manual user assignment occurred.<\/span><\/p>\n<h5><b>Preview of Data<\/b><\/h5>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17042\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/preview-of-data-300x60.png\" alt=\"\" width=\"1012\" height=\"203\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/preview-of-data-300x60.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/preview-of-data-1024x206.png 1024w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/preview-of-data-768x155.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/preview-of-data.png 1217w\" sizes=\"(max-width: 1012px) 100vw, 1012px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The last section is the preview of the source table or file data. By default, only the first twenty rows of data will be displayed in the preview section.\u00a0<\/span><\/p>\n<h5><b>Data Class Map Toolbar<\/b><\/h5>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-17043 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/data-class-map-toolbar.png\" alt=\"\" width=\"262\" height=\"60\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Toolbar Actions:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"> <img decoding=\"async\" title=\"\" src=\"https:\/\/lh7-us.googleusercontent.com\/weN_pQj-jVZngr57y3NxCFVI8jXmT4uKOlX_O0NQtVYOsqd8-iNW3Ad3zEw6xIPLMmMq1QHKxoanllxNLKY8ZXlFO-kABT3pvEQa0iWAC5cZGnhwPJny2Ysv79-dR14aO5rI3PD8MC0cO8lXuIjxcZs\" alt=\"\" \/><span class=\"c0\"> \u00a0<\/span>Sync with the latest changes to Data Class &amp; Rule Library and re-classify tables in Schema with new and\/or update data classes and rules.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"> <img decoding=\"async\" title=\"\" src=\"https:\/\/lh7-us.googleusercontent.com\/Ecze_r_8LEtcxRfZmf5GZih_YBjosDQ7EmSEcHMN-GFD0HzQSXlZQjhOItYRtJj-uH8Uj0o3qx7a-8tRTPlh9PBrF61B7rxUj8CM2jdjgvIW9Obup4l3byjq-3OB-7yQFQaQJmMW_00zSBm3lLuZqcM\" alt=\"\" \/><span class=\"c0\">\u00a0<\/span>Auto classify a new table.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"> <img decoding=\"async\" title=\"\" src=\"https:\/\/lh7-us.googleusercontent.com\/xmX-0E_42DSPggZFns38r3b7qQxDl92Pnrle0FCw2oAU65xLb0Hf4Nagh-Ze0TBOjfKxbuJ49UbtELebhM2foEB8q8wQa6oHL3WfjwNW8OHdDk2qqtMjGPmpJuBLFHJkXVayMOHsQorFWhn8Mb3Kbc8\" alt=\"\" \/> Auto classify a new file.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"> <img decoding=\"async\" title=\"\" src=\"https:\/\/lh7-us.googleusercontent.com\/tio_w1tePdSVxExSwjwvdGRnL9I0MjyRUtBa4F-OHhvPieXu2fLKLY3OK5qo8l1HGZFgRBZVD4PVk44WtTFBTuO-g3pibe-EQs7DugGgUpAegglkuZCwGwVgx_n25o0TQxf4ZWoWVZEhkzMnV24lG3A\" alt=\"\" \/> Delete either a table or file mapping.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"> <img decoding=\"async\" title=\"\" src=\"https:\/\/lh7-us.googleusercontent.com\/mNylgspWjOE-vif_U6DP5afwUIDn9Wb3yl2590yHkvXVOEtX6JuARr7NVvdvu8nwrQwn-uIL3QU9WtyRa0N5FAWvKt8Jo86FjwW2BbIW01BR2MOSlaOA0FhoLg6zn3YSAVWo8vnagmB3__vElBpSwQU\" alt=\"\" \/> Import a flat file (.tsv) to generate mappings of masking rules to columns in tables.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"> <img decoding=\"async\" title=\"\" src=\"https:\/\/lh7-us.googleusercontent.com\/k06__r_axfPPVffhvZ-Irn3xIt7LL8JCyi82lRNAGSE0MXsEEAgmHxr2N5qF_6qwdKML0ZAtAYHEldJo1s0kh1TbdJ1RCdAp_V-di5MrkQ51vgGWxOFc_ST9JJJ9nfTUqKhSDcP9ZVCCoKtyLKp9v5w\" alt=\"\" \/> Export the existing mapping in a Data Class Map to flat file (.tsv).<\/span><\/li>\n<\/ul>\n<h5><b>Sync with Data Class Library \/ Update Data Class Map<\/b><\/h5>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-17045 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/sync-data-class-300x259.png\" alt=\"\" width=\"518\" height=\"447\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/sync-data-class-300x259.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/sync-data-class.png 528w\" sizes=\"(max-width: 518px) 100vw, 518px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Sometimes you may need to make changes to data classes or rules stored in an <a href=\"https:\/\/www.iri.com\/blog\/data-protection\/iri-data-classification\/\">IRI Data Class &amp; Rule Library<\/a> after making a Data Class Map. For a Data Class Map to reflect these new changes in its mappings, it first needs to update its internal list of data classes and rules based on the latest version in the IRI Data Class and Rule Library.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Afterward, the data classification process must be redone anew. This is because the results of classification and subsequently produced field mappings may differ after changes are made to data classes and rules.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To perform a <\/span><i><span style=\"font-weight: 400;\">SyncUpdate <\/span><\/i><span style=\"font-weight: 400;\">you must launch the Classification Wizard via the <img decoding=\"async\" title=\"\" src=\"https:\/\/lh7-us.googleusercontent.com\/weN_pQj-jVZngr57y3NxCFVI8jXmT4uKOlX_O0NQtVYOsqd8-iNW3Ad3zEw6xIPLMmMq1QHKxoanllxNLKY8ZXlFO-kABT3pvEQa0iWAC5cZGnhwPJny2Ysv79-dR14aO5rI3PD8MC0cO8lXuIjxcZs\" alt=\"\" \/><\/span><span style=\"font-weight: 400;\">\u00a0option on the toolbar. Then you must select the Data Class &amp; Rule Library that will be used and indicate the data classes that will be active for the incoming data classification process.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Once the data classes are set up you can click <\/span><i><span style=\"font-weight: 400;\">Finish<\/span><\/i><span style=\"font-weight: 400;\"> to begin the data classification process anew. The latest version of your data classes and rules will then be in the IRI Data Class and Rule Library.<\/span><\/p>\n<h5><b>Auto Classify New Table<\/b><\/h5>\n<p><span style=\"font-weight: 400;\">The Data Class Map file also acts as a sort of staging phase to review your current column mappings and to modify them as needed. You can also manually add a table into an empty Data Class Map or one that wasn\u2019t included in a previous Schema Data Class Search operation.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To do this, click the Auto Classify New Table <img decoding=\"async\" title=\"\" src=\"https:\/\/lh7-us.googleusercontent.com\/Ecze_r_8LEtcxRfZmf5GZih_YBjosDQ7EmSEcHMN-GFD0HzQSXlZQjhOItYRtJj-uH8Uj0o3qx7a-8tRTPlh9PBrF61B7rxUj8CM2jdjgvIW9Obup4l3byjq-3OB-7yQFQaQJmMW_00zSBm3lLuZqcM\" alt=\"\" \/><\/span><span style=\"font-weight: 400;\"> button on the Data Class Map toolbar.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-17046 aligncenter\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/get-database-240x300.png\" alt=\"\" width=\"512\" height=\"640\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/get-database-240x300.png 240w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/get-database.png 562w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">As shown above, a page will open for you to select a database connection profile from a list of existing profiles, or to create a new connection profile. Based on the profile you specify, a list of tables across various schemas should appear.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Select one or more of the tables that you want added to the Data Class Map and automatically classify (from stored Data Classes) to build new column mappings. Once you are done with that step, click Finish.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">From the example below, you can see a new table was\u00a0 added from a different schema and column mappings were produced:<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17047\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/data-table-info-300x129.png\" alt=\"\" width=\"686\" height=\"295\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-table-info-300x129.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-table-info-768x330.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-table-info.png 995w\" sizes=\"(max-width: 686px) 100vw, 686px\" \/><\/p>\n<h5><b>Auto Classify New File<\/b><\/h5>\n<p><span style=\"font-weight: 400;\">Similar to the Auto Classify New Table option, you can also manually add a file into an empty Data Class Map or add one that wasn\u2019t included in a past Directory Data Class Search. To do this, click the Auto Classify New File <img decoding=\"async\" title=\"\" src=\"https:\/\/lh7-us.googleusercontent.com\/xmX-0E_42DSPggZFns38r3b7qQxDl92Pnrle0FCw2oAU65xLb0Hf4Nagh-Ze0TBOjfKxbuJ49UbtELebhM2foEB8q8wQa6oHL3WfjwNW8OHdDk2qqtMjGPmpJuBLFHJkXVayMOHsQorFWhn8Mb3Kbc8\" alt=\"\" \/><\/span><span style=\"font-weight: 400;\"> button on the Data Class Map toolbar.<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17049\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/data-class-map-toolbar-data-source2-300x163.png\" alt=\"\" width=\"639\" height=\"347\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-map-toolbar-data-source2-300x163.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-map-toolbar-data-source2-768x418.png 768w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-map-toolbar-data-source2.png 945w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">A page will open for you to provide the data source (in this case a file) and any metadata regarding the structure of the file. If no metadata file exists, you can generate it through the <\/span><a href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-metadata-discovery-wizard\/\"><i><span style=\"font-weight: 400;\">Discover Metadata<\/span><\/i><\/a><span style=\"font-weight: 400;\"> option.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Once you are done setting up each new data source and its fields, click <\/span><i><span style=\"font-weight: 400;\">Finish<\/span><\/i><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17053\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/new-data-source-and-its-fields-300x133.png\" alt=\"\" width=\"721\" height=\"320\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/new-data-source-and-its-fields-300x133.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/new-data-source-and-its-fields.png 980w\" sizes=\"(max-width: 721px) 100vw, 721px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The example above shows that a new file was added and its field mappings were produced.<\/span><\/p>\n<h5><b>Delete Source<\/b><\/h5>\n<p><span style=\"font-weight: 400;\">To remove tables or files and their related mappings from a Data Class Map, just select the table or file node and click on the <img decoding=\"async\" title=\"\" src=\"https:\/\/lh7-us.googleusercontent.com\/tio_w1tePdSVxExSwjwvdGRnL9I0MjyRUtBa4F-OHhvPieXu2fLKLY3OK5qo8l1HGZFgRBZVD4PVk44WtTFBTuO-g3pibe-EQs7DugGgUpAegglkuZCwGwVgx_n25o0TQxf4ZWoWVZEhkzMnV24lG3A\" alt=\"\" \/><\/span><span style=\"font-weight: 400;\"> option on the Data Class Map toolbar.<\/span><\/p>\n<h5><b>Import a Flat File to Create Field Mappings<\/b><\/h5>\n<p><span style=\"font-weight: 400;\">If you already have table\/PII location details in a spreadsheet, you can create IRI field mappings from a tab-delimited file with that information. Import file entries must be in this format:\u00a0<\/span><\/p>\n<pre><i><span style=\"font-weight: 400;\">&lt;schema_name&gt;TAB&lt;table_name&gt;TAB&lt;column_name&gt;TAB&lt;dataclass_name&gt;TAB&lt;rule_name&gt;<\/span><\/i><\/pre>\n<p><span style=\"font-weight: 400;\">OR<\/span><\/p>\n<pre><i><span style=\"font-weight: 400;\">&lt;schema_name&gt;TAB&lt;table_name&gt;TAB&lt;column_name&gt;2TABs&lt;rule_name&gt;<\/span><\/i><\/pre>\n<p><span style=\"font-weight: 400;\">Each line entry in the import file can take up to five parameters, with at least four required and one optional parameter. The schema (column1), table (column2) and column (column3) names are required. A data class name (column4) is optional, but a rule name (column5) is required.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Here is an example of an import file with all five columns shown:<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17051\" src=\"\/blog\/wp-content\/uploads\/2024\/01\/data-class-map-tsv-300x221.png\" alt=\"\" width=\"438\" height=\"323\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-map-tsv-300x221.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-map-tsv.png 568w\" sizes=\"(max-width: 438px) 100vw, 438px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Note that the schemas, tables, and columns listed in the import file you use must already exist in a database. Likewise, the data class and rule names in the import file must exist in your .dcrlib file.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The names of data classes and rules are used to search the .dcrlib and retrieve the data class\/rule\u2019s information based on the unique name associated with individual data classes and rules stored in the .dcrlib. The data class and rules retrieved from a .dcrlib file are used to make mappings inside the Data Class Map.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To begin the import process click the <img decoding=\"async\" title=\"\" src=\"https:\/\/lh7-us.googleusercontent.com\/mNylgspWjOE-vif_U6DP5afwUIDn9Wb3yl2590yHkvXVOEtX6JuARr7NVvdvu8nwrQwn-uIL3QU9WtyRa0N5FAWvKt8Jo86FjwW2BbIW01BR2MOSlaOA0FhoLg6zn3YSAVWo8vnagmB3__vElBpSwQU\" alt=\"\" \/><\/span><span style=\"font-weight: 400;\"> button on the Data Class Map toolbar.<\/span><\/p>\n<h5><b>Export Existing Mappings<\/b><b><\/b><\/h5>\n<p><span style=\"font-weight: 400;\">The export button on the Data Class Map toolbar will begin the process of converting and exporting field mappings stored in the Data Class Map to TSV file format. Each line entry in the export file will represent one field mapping.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The entries in the export file are in the following the format:\u00a0<\/span><\/p>\n<pre><i><span style=\"font-weight: 400;\">&lt;schema_name&gt;TAB&lt;table_name&gt;TAB&lt;column_name&gt;TAB&lt;dataclass_name&gt;TAB&lt;rule_name&gt;<\/span><\/i><\/pre>\n<p><span style=\"font-weight: 400;\">OR<\/span><\/p>\n<pre><i><span style=\"font-weight: 400;\">&lt;schema_name&gt;TAB&lt;table_name&gt;TAB&lt;column_name&gt;2TABs&lt;rule_name&gt;<\/span><\/i><\/pre>\n<p><span style=\"font-weight: 400;\">To begin the export process click the <img decoding=\"async\" title=\"\" src=\"https:\/\/lh7-us.googleusercontent.com\/k06__r_axfPPVffhvZ-Irn3xIt7LL8JCyi82lRNAGSE0MXsEEAgmHxr2N5qF_6qwdKML0ZAtAYHEldJo1s0kh1TbdJ1RCdAp_V-di5MrkQ51vgGWxOFc_ST9JJJ9nfTUqKhSDcP9ZVCCoKtyLKp9v5w\" alt=\"\" \/><\/span><span style=\"font-weight: 400;\"> button on the Data Class Map toolbar.<\/span><\/p>\n<h5><b>Need Help?<\/b><\/h5>\n<p><span style=\"font-weight: 400;\">If you have any questions about data classification and column mapping in your IRI FieldShield data masking operation for a relational database, please email <\/span><a href=\"mailto:fieldshield@iri.com\"><span style=\"font-weight: 400;\">fieldshield@iri.com<\/span><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In past articles we have discussed the Data Class &amp; 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.\u00a0For the topic of this article, I will discuss what a Data Class Map is and<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/\" title=\"IRI Data Class Map\">Read More<\/a><\/div>\n","protected":false},"author":152,"featured_media":17055,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[8,91],"tags":[1304,1730,1081,280,1770,89,850,1765,1758,154,1760],"class_list":["post-17024","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-protection","category-iri-workbench","tag-data-class","tag-data-class-mapping","tag-data-classification","tag-data-discovery","tag-data-masking-rules","tag-database-test-data","tag-iri-workbench","tag-rdb-data-masking","tag-rdbms-data-masking","tag-rdbms-tables","tag-sensitive-data-masking"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>IRI Data Class Map - IRI<\/title>\n<meta name=\"description\" content=\"Maximize the efficiency of database data classification and PII data masking through the FieldShield Data Class Map feature in IRI Workbench\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"IRI Data Class Map\" \/>\n<meta property=\"og:description\" content=\"Maximize the efficiency of database data classification and PII data masking through the FieldShield Data Class Map feature in IRI Workbench\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-10T01:36:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-26T13:00:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-mapping.png\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"368\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Adam Lewis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Adam Lewis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/\"},\"author\":{\"name\":\"Adam Lewis\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/37c0e5beab094bd61cc521902df2876e\"},\"headline\":\"IRI Data Class Map\",\"datePublished\":\"2024-01-10T01:36:14+00:00\",\"dateModified\":\"2025-02-26T13:00:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/\"},\"wordCount\":2087,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-mapping.png\",\"keywords\":[\"data class\",\"data class mapping\",\"data classification\",\"data discovery\",\"data masking rules\",\"database test data\",\"IRI Workbench\",\"RDB data masking\",\"RDBMS data masking\",\"RDBMS tables\",\"sensitive data masking\"],\"articleSection\":[\"Data Masking\/Protection\",\"IRI Workbench\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/\",\"url\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/\",\"name\":\"IRI Data Class Map - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-mapping.png\",\"datePublished\":\"2024-01-10T01:36:14+00:00\",\"dateModified\":\"2025-02-26T13:00:06+00:00\",\"description\":\"Maximize the efficiency of database data classification and PII data masking through the FieldShield Data Class Map feature in IRI Workbench\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-mapping.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-mapping.png\",\"width\":768,\"height\":368},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IRI Data Class Map\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/37c0e5beab094bd61cc521902df2876e\",\"name\":\"Adam Lewis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/087667d0c75d33bb6fab6e734bd89333?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/087667d0c75d33bb6fab6e734bd89333?s=96&d=blank&r=g\",\"caption\":\"Adam Lewis\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/adaml\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"IRI Data Class Map - IRI","description":"Maximize the efficiency of database data classification and PII data masking through the FieldShield Data Class Map feature in IRI Workbench","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/","og_locale":"en_US","og_type":"article","og_title":"IRI Data Class Map","og_description":"Maximize the efficiency of database data classification and PII data masking through the FieldShield Data Class Map feature in IRI Workbench","og_url":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/","og_site_name":"IRI","article_published_time":"2024-01-10T01:36:14+00:00","article_modified_time":"2025-02-26T13:00:06+00:00","og_image":[{"width":768,"height":368,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-mapping.png","type":"image\/png"}],"author":"Adam Lewis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Adam Lewis","Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/"},"author":{"name":"Adam Lewis","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/37c0e5beab094bd61cc521902df2876e"},"headline":"IRI Data Class Map","datePublished":"2024-01-10T01:36:14+00:00","dateModified":"2025-02-26T13:00:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/"},"wordCount":2087,"commentCount":0,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-mapping.png","keywords":["data class","data class mapping","data classification","data discovery","data masking rules","database test data","IRI Workbench","RDB data masking","RDBMS data masking","RDBMS tables","sensitive data masking"],"articleSection":["Data Masking\/Protection","IRI Workbench"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/","url":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/","name":"IRI Data Class Map - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-mapping.png","datePublished":"2024-01-10T01:36:14+00:00","dateModified":"2025-02-26T13:00:06+00:00","description":"Maximize the efficiency of database data classification and PII data masking through the FieldShield Data Class Map feature in IRI Workbench","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-mapping.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-mapping.png","width":768,"height":368},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/iri\/iri-workbench\/data-class-mapping-in-iri-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"IRI Data Class Map"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/37c0e5beab094bd61cc521902df2876e","name":"Adam Lewis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/087667d0c75d33bb6fab6e734bd89333?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/087667d0c75d33bb6fab6e734bd89333?s=96&d=blank&r=g","caption":"Adam Lewis"},"url":"https:\/\/www.iri.com\/blog\/author\/adaml\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2024\/01\/data-class-mapping.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/17024"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/152"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=17024"}],"version-history":[{"count":19,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/17024\/revisions"}],"predecessor-version":[{"id":18262,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/17024\/revisions\/18262"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/17055"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=17024"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=17024"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=17024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}