Compare Informatica Data Masking vs. Oracle GoldenGate Informatica Data Masking is ranked 8th in Database Security while Oracle GoldenGate is ranked 5th in Data Integration Tools with 7 reviews. Informatica Data Masking is rated 0, while Oracle GoldenGate is rated 8.6.
List and comparison of the Best open source free Data Masking Tools Available in the Market:
Data Masking is a process that is used to hide data.
In Data masking, actual data is masked by random characters. It protects the confidential information from those who don’t have the authorization to sight it.
The main purpose of data masking is to shield complex and private data in conditions where the data might be noticeable to someone without their permission.
What You Will Learn:
- Why Mask Data?
- List of The Best Data Masking Tools
- Conclusion
Why Mask Data?
Data Masking shields PII data or other confidential information of the organization.
It secures the file transferring process from one location to another. It also helps to secure application development, testing, or CRM applications. It allows its users to access dummy data for testing or training purposes.
How is Data Masking Done?
Data Masking can be done either statically or dynamically.
In order to achieve data masking, it is essential to create a copy of a database that is matching to the original one. Data masking shields private data in real-time. When a query is directed to a database, the records are replaced with dummy data and then masking procedures are applied to it accordingly.
Static Data Masking
Dynamic Data Masking
[image source]
Features of Data Mask Tools
Enlisted below are the various features of these Tools:
- Masking Procedures present on-demand for data.
- Data privacy law helps to track compliance.
- Codeless masking rules are available.
- Access to data stored in various databases.
- Accurate but imaginary data is accessible for testing.
- Format-preserving encryption conversion.
What are the Best Data Masking Tools?
Data Masking Tools are protecting tools that avoid any misuse of complex information.
Data Masking Tools eliminate complex data with false data. They may be used throughout application development or testing where end-user inputs the data.
Here, in this article, we have discussed a list of tools that will prevent the data from being misused. These are the top as well most common tools for masking data for small, large and mid-size enterprises.
[image source]
Top Data Masking Software Comparison
Tool Name | Ratings | Platform Connectivity | Supported Technology |
---|---|---|---|
DATPROF Data Masking Tool | 5.0/5.0 | Oracle, SQL Server, PostgreSQL, IBM DB2, EDB Postgres | Synthetic test data, GDPR, synchronization template, CISO, ERD, TDM, CI/CD, Runtime API |
Oracle - Data Masking and Subsetting | 4.0/5.0 | Cloud Platforms, Linux, Mac, Windows. | SDM, DDM, Data Virtualization with SDM, Tokenization. |
IBM InfoSphere Optim Data Privacy | 4.9/5.0 | Big data platforms, Mainframe files, Windows, Linux, Mac | SDM, DDM, Synthetic data generation, Data Virtualization with SDM |
Delphix | 3.5/5.0 | Linux, Mac, Windows, Relational DB. | SDM, Data Virtualization with SDM, FPE (Format-Preserving encryption). |
Informatica Persistent Data Masking | 4.2/5.0 | Linux, Mac, Windows, Relational DB, Cloud Platforms. | SDM, DDM |
Microsoft SQL Server Data Masking | 3.9/5.0 | T-Query, Windows, Linux, Mac, cloud. | DDM |
List of The Best Data Masking Tools
Mentioned below are the most popular Data Masking tools that are available in the market.
Let's Explore!!
#1) DATPROF – Test Data Simplified
DATPROF delivers several tools:
- DATPROF provides a smart way of masking and generating data for testing the database
- DATPROF has a patented algorithm for subsetting database in a really simple and proven way
- The software is able to handle complex data relationship with an easy to use interface
- It has a really smart way to temporarily bypass all triggers, constraints and indexes so it is the best performing tool in the market.
Download Link: DATPROF – Test Data Simplified
#2) Oracle Data Masking and Subsetting
Oracle Data Masking and Subsetting benefits database clients to advance security, quicken submission, and cut IT prices.
It helps in removing the duplicates for testing data, development, and other actions by removing redundant data and files. This tool suggests data plotting and uses a masking description. It comes up with encoded guidelines for HIPAA, PCI DSS, and PII.
Features:
- Discovers Complex Data and its relationships automatically.
- Wide Masking Plan Library and enhanced Application Models.
- Revolutions of complete data masking.
- Fast, Secure and Assorted.
Pros:
- It proposes various customs for masking data.
- It supports non-oracle databases as well.
- It takes less time to run.
Cons:
- High-cost.
- Less secured for development and testing environments.
Pricing: Contact for Pricing.
URL: Oracle Data Masking and Subsetting
#3) Delphix
Delphix is a fast as well as secure data masking tool for masking data across the company. It comes up with encoded rules for HIPAA, PCI DSS, and the SOX.
The Delphix Masking Engine is combined with a Delphix data virtualization platform to save and store data loading. DDM exists through a partnership company with HexaTier.
Features:
- End-to-end data masking and creates reports for the same.
- Masking Combined with data virtualization to progress transport of the data.
- Easy in use as no training is required to mask data.
- It migrates data steadily across sites, on-premises or in the cloud.
Pros:
- Easy and in-time regaining of records.
- Virtualization of databases.
- Data refreshing is fast.
Cons:
- High cost.
- SQL Server databases are slow and limited.
- Reliant on NFS old protocols.
Pricing: Contact for pricing.
URL:Delphix
#4) Informatica Persistent Data Masking
Informatica Persistent Data Masking is an accessible data masking tool that helps an IT organization to access and manage their most complex data.
It delivers enterprise scalability, toughness, and integrity to a large volume of databases. It creates a reliable data masking rule across the industry with a single audit track. It allows to trail actions for securing sensitive data via complete audit logs and records.
Features:
- Supports Robust Data Masking.
- Creates and integrates the masking process from a single location.
- Features to handle a large volume of databases.
- It has wide connectivity and customized Application Support.
![Data masking software reviews for windows 10 Data masking software reviews for windows 10](/uploads/1/2/5/0/125010794/176035001.jpg)
Pros:
- Decreases the risk of Data Break via a single audit trail.
- Advances the Quality of Development, Testing and Training events.
- Easy deployment in the workstations.
Cons: Need to work more on UI.
Pricing: A 30-day free trial is available.
URL: Informatica Persistent Data Masking
#5) Microsoft SQL Server Data Masking
Dynamic Data Masking is a new safety feature announced in SQL Server 2016 and it controls unlicensed users to access complex data.
It is a very easy, simple and a protective tool that can be created using a T-SQL query. This data security procedure determines complex data, through the field.
Features:
- Simplification in designing and coding for application by securing data.
- It doesn’t change or transform the stored data in the database.
- It permits the data manager to choose the level of complex data to expose with a lesser effect on the application.
Pros:
- End operators are prohibited from visualizing complex data.
- Generating a mask on a column field doesn’t avoid updates.
- Changes to applications are not essential to read data.
Cons:
- Data is fully accessible while querying tables as a privileged user.
- Masking can be unmasked via CAST command by executing an ad-hoc query.
- Masking cannot be applied for the columns like Encrypted, FILESTREAM, or COLUMN_SET.
Pricing: Free trial is available for 12 months.
URL: Dynamic Data Masking
#6) IBM InfoSphere Optim Data Privacy
IBM InfoSphere Optim Data Privacy proposes data mapping and uses a masking report with a masking asset. It has predetermined reports for PCI DSS and HIPAA.
It offers wide abilities to efficiently mask complex data across non-production environments. To secure private data, this tool will substitute the delicate info with truthful, and completely useful masked data.
Features:
- Mask private data on request.
- Decrease risk by locking data.
- Fasten data privacy application.
- A secure environment for application testing.
Pros:
- Easily abstracts data with no-coding.
- Advanced Data Masking Feature.
- Smart filtering abilities.
Cons:
- Need to work on UI.
- Complex architecture.
Pricing: Contact for Pricing.
URL:IBM InfoSphere Optim Data Privacy
#7) CA Test Data Manager
CA Test Data Manager helps in data privacy and compliance problems as it comes with General Data Protection Regulation GDPR and other laws.
This tool bids data mapping, data movement, and functional masking. It has a universal file reporting and metadata. It has SDM expertise for complex and large environments with consistent databases.
Features:
- Creates Synthetic test data for data testing.
- Creates future test scenarios and unexpected outcomes.
- Stores data for reuse.
- Creates virtual copies of test data.
Pros:
- Different filters and templates are present to mask data.
- No additional permission is required to access the production data.
- Very fast tools to mask data.
Cons:
- Works only on Windows.
- Complex User Interface.
- Automating everything is not easy.
Pricing: A Free trial is available.
URL:CA Test Data Manager
#8) Compuware Test Data Privacy
Compuware Test Data Privacy helps in the mapping of data and generic masking reports.
This tool mainly works on the mainframe platform and supports hybrid non-mainframe settings. Their solution offers Topaz for Enterprise Data for reliability, conversant and security.
It has two essential areas to perform test data privacy solutions for securing test data i.e. data breach prevention and compliance with data privacy laws.
Features:
- Decreases the difficulty by codeless masking.
- Completes data normalization into and out of the masking process.
- Dynamic Privacy Rules with complex test data essentials such as account numbers, card numbers, etc.
- Allows to discover and mask data within a greater field.
Pros:
- Easy to use and is fast.
- Secures test data against breaks.
- Apply test data privacy to test data, so that it will be more secure.
Cons:
- Complex user Interface.
Pricing: Contact for Pricing.
URL:Compuware Test Data Privacy
#9) IRI – FieldShield
IRI is a US-based ISV founded in 1978 that's best known for its CoSort fast data transformation, FieldShield data masking, and RowGen test data products. IRI also bundles those and consolidates data discovery, integration, migration, governance, and analytics in a big data management platform called Voracity.
FieldShield is popular in the DB data masking and test data market due to its high speed, low cost, compliance features, and range of supported data sources. It is compatible with other IRI data masking, testing, ETL, data quality, and analytic jobs in Eclipse, SIEM tools, and erwin platform metadata.
Features:
- Multi-source data profiling, discovery (search) and classification
- Broad array of masking functions (including FPE) to anonymize and delete PII
- Assures referential integrity across schema and multi-DB/file scenarios
- Built-in re-ID risk scoring and audit trails for GDPR, HIPAA, PCI DSS, etc.
Pros:
- High performance, without the need for a central server
- Simple metadata and multiple graphical job design options
- Responsive POC and tech support a wide range of use cases
- Affordable, especially relative to IBM, Oracle, Informatica
Cons:
- English-only documentation
- Thick client Eclipse UI (not web-based)
- DDM requires FieldShield API call, or separate product (IRI Chakra Max DB firewall)
Pricing: Available for free and you can contact them for more pricing details.
URL:IRI – FieldShield
#10) NextLabs Data Masking
NextLabs Data Masking offers an established software that can shield data and guarantee compliance in the cross-platform.
The essential part of NextLabs data masking is its Dynamic Authorization technology with Attribute-Based Access Control. It secures all the critical business data and applications.
Features:
- Helps in classifying and sorting data.
- Monitors data movement and its usage.
- It prevents access for precise data.
- Notifications on risky actions and irregularities.
Pros:
- Can be installed easily in each workstation.
- Evades data breaking.
- Data Safety across CAD, PLM, and email is good.
Cons:
- Software compatibility problems with PLM software.
- Execution is tough at times for the suppliers and vendors.
Pricing: Contact them for pricing.
URL:NextLabs Data Masking
#11) Hush-Hush
Hush-Hush shield helps in recognizing data against internal risk.
It de-identifies the establishment's complex data. HushHush elements are out-of-the-box procedures that are built for elements such as credit cards, addresses, contacts, etc.
This data masking software de-identifies data in folders, records, emails, etc., through API. Its custom code can be planned and ad-hocked.
Features:
- Less time and Easy installation.
- Supple, Robustness and takes less time to create workflows.
- Easy and Robust Combination into SQL server, Biztalk etc.
- Custom SSIS agenda to mask data.
Pros:
- Speed up development.
- No learning curves.
- Create data by just “INSERT” command.
Cons:
- In startups the growth is fast but the progress slows down in developed industries.
- Limited control of data.
Pricing: You may request for free use and contact them for final pricing.
URL:Hush-Hush
Additional Tools for Data Masking
#12) HPE Secure Data
HPE Secure Data offers an end to end method to secure the organization data. This tool shields data to its complete development cycle that is deprived of revealing live data to risk.
It has database integrity features enabled and compliance reporting like PCI, DSS, HIPPA etc. Technology supported by HPE is DDM, Tokenization etc.
URL: HPE Secure Data
#13) Imperva Camouflage
Imperva Camouflage Data Masking decreases the risk of data break by substituting complex data with real data.
This tool will support and confirm compliance with rules and international plans. It has reporting and managing capabilities with database integrity. It supports SDM, DDM and generates synthetic data.
URL: Imperva Camouflage Data Masking
#14) Net2000 – Data Masker Data Bee
Net2000 offers all the tools that help to scramble, change or complicate the test data.
It succeeds in the risk of complex data re-identification. It has the feature of database integrity. It supports SDM and Tokenization technology. It is useful for all platforms like Windows, Linux, Mac etc.
URL: Net2000 – Data Masker Data Bee
#15) Mentis Data Masking
Mentis offers the most influential masking and monitoring solutions. It has in-built suppleness that modifies data security according to the environment.
It has SDM, DDM, and Tokenization enabled features. It offers prevention of data loss and database security options. It supports almost all platforms like Windows, Mac, cloud, Linux etc.
URL: Mentis Data Masking
#16) JumbleDB
JumbleDB is a wide-ranging data masking tool which secures complex data in non-production surroundings. JumbleDB transmits a quick and smart auto-discovery engine based on out-of-the-box templates.
It has multiple assorted support of cross-database platforms. It detects complex data and its relationship between referential integrity. Notifications are raised on data abnormalities or fluctuations.
URL:JumbleDB
Conclusion
In this article, we have discussed the Top Data Masking Tools that are available in the market.
These above-discussed tools are the most popular and secure ones, and their features & technology is as per the industrial requirements.
These tools are available free of cost and have a simple user interface and easy installations as well. You can choose any tools based on your requirements.
From our research, we can conclude that DATPROF is best for large, mid-size as well as small businesses. Informatica Data Privacy Tool and IBM Infosphere Optim Data privacy are best for Large Enterprises, Oracle Data Masking and Subsetting are best for Med-Size Enterprises and Delphix is good for Small Enterprises.
Recommended Reading
Active4 years, 11 months ago
I'm looking for (ideally free, open-source) data masking tools. Do any such exist?
Note: this related question deals with tools for generating test data, but in this question I'm more interested in starting with real data, and masking it for use in test without losing any special relationships that make it interesting for test purposes. Generated data is fine for some test purposes, but real-world data will bring up issues you never thought of.Tool to generate large datasets of test data
Community♦
testerabtesterab
2873 gold badges7 silver badges13 bronze badges
closed as off-topic by Paul White♦, Michael - sqlbot, Mark Storey-Smith, ypercubeᵀᴹ, Max VernonOct 30 '14 at 13:18
This question appears to be off-topic. The users who voted to close gave this specific reason:
- 'Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope.' – Paul White, Michael - sqlbot, Mark Storey-Smith, ypercubeᵀᴹ, Max Vernon
9 Answers
I would be very surprised if there was a generic tool for this - how would it 'know' what is sensitive data and what wasn't? For example it would need to examine all your data and recognize all possible formats of credit card number, phone number, postcode, email address, and whatever other data is considered sensitive. It would also need to be smart about your schema - e.g. should it rewrite all customer email addresses to '[email protected]' - or does any part of your database, applications, other tools assume that a customer's email address (or SSN or whatever) is unique? Or do you have some part of the application that checksums credit card numbers, that would break if you reset them all to 0000 0000 0000 0000? Or does your telephony system assume that a customer's dialing code corresponds to the country in their address?
Basically, configuring any tool to do it will be as much or more work than just writing your own script, using your knowledge of the application. At my site, we simply made it policy that anyone who adds a column with such data in updates the script to anonymize it at the same time, after an initial audit to find all those columns and write version 1.
GaiusGaius
10.4k3 gold badges26 silver badges63 bronze badges
If your database is tiny, has a simple data model and is well understood by current DBA’s – scripting “might” be the answer. However, the effort (and cost) to manually analyze and mask typical databases can get out of hand pretty quickly as requirements change, functionality is added and developers/DBA’s come and go.
While I’m not aware of any open source data masking products, there are commercial offerings available that are reasonably comprehensive, relatively easy to use and may be surprisingly reasonable cost-wise. Many of them include out-of-the-box discovery capability to identify and classify sensitive data (SSN, credit cards, phone numbers) as well as functionality to maintain the checksums, email address formatting, data grouping, etc. so that masked data looks and feels real.
But you don’t have to take my (admittedly biased) word for it. Ask the industry analysts such as Gartner or Forrester who have a number of unbiased reports available on masking that may help.
Hopefully these comments will encourage you to consider exploring commercial products as well as internal script development. At the end of the day, the most important thing is to protect the sensitive data that many of us see day-in and day-out that we really don’t need to see to do our jobs – putting us and the people whose personal data we hold at risk.
![Data Masking Software Reviews Data Masking Software Reviews](/uploads/1/2/5/0/125010794/141959914.jpg)
Kevin Hillier,Senior Integration Specialist, Camouflage Software Inc.
user757
Never seen such an item, but having worked with a few sensitive data sets in my time, the main thing that needs to be scrambled is people's identities or personally identifying information. This should only make an appearance in a few places in the database.
Your masking operation should retain the statistical properties and relationships of the data, and probably needs to retain actual reference codes (or at least some sort of controlled translation mechanism) so you can reconcile it to the actual data.
This sort of thing can be achieved by getting a distinct list of the names in the fields and replacing it with something like FirstNameXXXX (where XXXX is a sequence number, one for each distinct value). Credit card numbers and similar information that could be used for identity theft are quite likely to be a no-no in a development environment, but you only need real ones if you're testing payment processing systems - typically the vendor will give you special codes for dummy accounts.
It's not particularly difficult to write anonymising procedures of this sort, but you will need to agree exactly what needs to be anonymised with the business. If necessary, go through the database field by field. Asking yes/no will give you false positives that you don't want. Ask the business rep to explain why, or the consequences or regulatory implications of not anonymising particular data.
ConcernedOfTunbridgeWellsConcernedOfTunbridgeWells
16.2k2 gold badges50 silver badges69 bronze badges
I had the same task few weeks ago. we evaluated some software systems, but most of them are only for exactly one type of data base, e.g. oracle and they are often very complicated to use.. so uhm no the nicest thing to evaluate this. It took us weeks.
We decided to buy the data masking suite professional version as it was the most easy to ue one. It has also cool possibilities to mask data, e.g. you can change email addresses to real looking ones e.g. [email protected] to [email protected].
You can try it free for about 500(?) records as far as I remember.
Here is the link http://www.data-masking-tool.com/
SaJoeSaJoe
My way of doing this: Free mahjong solitaire no download.
- Make a new database with only view and select rights for the users
- Make views to tables that should be viewable in other databases
- Mask columns that need masking by: repeat('*',char_length(
column to be masked
))
15.8k6 gold badges37 silver badges74 bronze badges
Boudi van VlijmenBoudi van Vlijmen
I first stated down this path several years ago and have since built up a consultancy based around this practice.
I'm assuming that the purpose is to build up test data for use in test environments where those personel accessing the data do not have rights for viewing the production information.
The first thing to establish is exactly what data elements you need to mask and to do that it is best to start out with a data discovery tool such as Schema Spy (Open source) and you will need the relevant jdbc driver for this task but it is a very useful step in the process.
Talend Open Studio is one of the best tools I have used in recent years to perform some of the ETL functions and you will also be able to do some basic masking practice by replacing values with a random or. Lookup/replace - to maintain consistency - using the map component.
But if your looking for a real data masking tool I have not found a suitable open source tool. If you have a very moderate budget for tools I would suggest Data Masker but you will need to do some import and export through MS SQL or Oracle as it only connects via those protocols.
Check out http://www.datakitchen.com.au/2012-08-14-15-04-20/data-masking/data-masker-toolset for info about data masking, data masking methodology, data discovery and test data management. There is also a useful blog at http://www.dataobfuscation.com.au
user25272user25272
There is a tool available in the Market from Informatica which is called Informatica ILM(TDM). This uses PowerCenter as a backone for ETL and mask data with different masking options available. Altough you need a data analyst or SME who can understand how the data should be masked. Tool itself doesn't provide information which fields should be masked, however there is an internal algorithm or procedure or process to identify senstive data fields such as Name, ID columns with number, Credit card, SSN number, Account Number etc.
dezso
23.5k12 gold badges64 silver badges104 bronze badges
Best Photo Masking Software
Awadhesh YonaAwadhesh Yona
This year I have the opportunity to work with IBM Optim that claims to do what is asked for. Is not free, but it works fine.
MendesMendes
The one I like best is IRI FieldShield (https://www.iri.com/products/fieldshield) in terms of versatility (most data masking functions), speed (CoSort engine for data movement inside), and ergonomics (simple 4GL jobs supported in its Eclipse GUI with tons of DB and file connections). Price-wise it’s about half IBM and Informatica, though also available in a larger data integration suite for ‘big’ data transformation, migration, and BI too. So it’s not free either, but uses some open source (the IDE, and can use OpenSSL and GPG) and the scripts run on Windows, Linux, and other Unix flavors.
Urvashi SaxenaUrvashi Saxena