Editors Note, Q2’19: In addition to the method described below, there is now also available to IRI FieldShield (data masking product) or IRI Voracity (data management platform) users a Data Class Database Masking wizard, which can be used if you have pre-classified your data.
The traditional or enterprise data warehouse (EDW) has been at the center of data’s transformation to business intelligence (BI) for years. An EDW involves a centralized data repository (traditionally, a relational database) from which data marts and reports are built.
Data architects and data scientists, as well as DBAs and governance teams, may need to use or migrate data in legacy file formats and databases. Additionally, the ability to mash-up those sources with newer file and database repositories is important in data integration (ETL) and analytic projects, as well as in data profiling for data loss prevention and privacy law compliance.