Data Breaches Solved with Data Masking for Oracle, Salesforce, SAP and Snowflake Applications.

Industrial Manufacturing

Client Overview

A leading manufacturer of industrial equipment with operations spanning numerous geographies was faced with the daunting task of handling sensitive data in its non-production instances. The data used for testing purposes in lower instances included “Personally identifiable Information (PII)”, which had to be masked to meet internal company compliance guidelines and regulatory statutes.

Client contacted ChainSys to assist with data masking utilizing the ChainSys dataZense offering.

Project Scope

As part of the need to expedite availability of test data in non-production instances, Client needed all PII data to be identified and masked within the following primary systems - Oracle EBS, Salesforce, Snowflake and MS SQL Server. The key challenge that had to be addressed was to accurately identify PII data based on specified attributes through an automated mechanism as opposed to manual methods.

Business Situation

Client utilizes multiple Applications and underlying databases that contain PII data. The primary systems that contain such data are:

  • Oracle EBS
  • Salesforce
  • Snowflake
  • MS SQL Server

Examples of typical Critical Attributes to be identified include: 

  • Full Name
  • All Elements of Dates associated with an Individual, including Date of Birth, Date of Death and Date of Provision of a Service
  • Social Security Number
  • Passport Number
  • Physical Address
  • Telephone Numbers
  • Fax Numbers
  • Electronic Mail Addresses

The identified PII attributes had to be masked in non-production instances before the data was utilized for testing.

Technical Situation

ChainSys offered its dataZense tool for quickly scanning multiple databases and aggregating the PII data into clean reports. Data owners would have access to these reports for approval that would provide the go-ahead for expedited data masking processing through the dataZen tool.


ChainSys proposed its dataZense product to enable data masking.



dataZense tool provisions a scalable solution for: 

  • Running data profiling process to identify PII Attributes in the systems considered for Sensitive Data Identification (PII) for both structured and unstructured data
  • Review and Approve - identified PII attributes go through False-Positive / False-Negative analysis & finalized PII attributes are considered for remediation
  • Governance process to get consent from the data owners to “Keep” the PII data in systems (Production and Non-Production)
  • Data Masking is triggered once the Owner gives consent on the PII data attributes
  • Tool maintains lineage of PII data attributes – links the data to the data owner
  • Continuous monitoring for PII attributes is enabled

Products and Services Used

dataZense - To Visualize, Analyze, Catalog and Scramble Data for Effective Decision Making & Security.


No items found.