Delphix, from Perforce, provides test data management for DevOps. The Delphix DevOps Data Platform automates data security, while rapidly deploying test data to accelerate application releases.
N/A
Denodo
Score 8.0 out of 10
N/A
Denodo is the eponymous data integration platform from the global company headquartered in Silicon Valley.
N/A
Oracle Data Masking and Subsetting
Score 8.0 out of 10
N/A
Oracle Data Masking and Subsetting is designed to help database customers improve security, accelerate compliance, and reduce IT costs by sanitizing copies of production data for testing, development, and other activities and by discarding unnecessary data.
REST API calls are available for all Delphix activities. Delphix makes it simple to move data between production to other test or QA environments. Through the replacement with a dummy, yet realistic data of the customer or patient data, you reduce the danger of data breaches for any and all copies of data you produce.
Denodo allows us to create and combine new views to create a virtual repository and APIs without a single line of code. It is excellent because it can present connectors with a view format for downstream consumers by flattening a JSON file. Reading or connecting to various sources and displaying a tabular view is an excellent feature. The product's technical data catalog is well-organized.
The tool is excellent when you need to provide all the details about your clients, yet hide their identity - all while maintaining the referential integrity of the data (so child-records of the masked parent record and maintain the same fake ID of the parent).
Fast refresh of production data to non-production environments.
Easy to automate tasks in Delphix (Bookmark, Rewind, Refresh, etc.) and build pipelines in tools like Jenkins. Enables CI/CD push button build of new virtual database and also the ability to automate regression testing scenarios as well as provide a simple way to expose self-service to developers & testers.
The staff at Delphix are knowledgeable and take a genuine interest in helping their customers succeed. The support organization is among the best I've seen.
Delphix is good at notifying customers of bugs & features striking a good balance on sending the right amount and type of communication.
Delphix is always improving the product and fixing any bugs quickly and transparently.
Delphix Data Masking product works as described and allows for multiple streams of masking concurrently to complete masking faster.
It offers several ways in which you can mask your data; for example, you can choose to replace all names with "real fake names", or choose to replace all SSNs with existing SSNs, but randomly assigned. You control the algorithm.
It works on non-Oracle databases as well (in our case, we use it for both Oracle and SQL/Server).
The overhead is minimal (it doesn't take long to run, and it doesn't consume too many system resources.
Delphix is a hefty solution for virtualization, but it is not strong enough for the creation of data, so we have to use another platform when it comes to creating new data.
Moreover, Delphix web pages do not support AD security groups which eventually results in hassle if you have a large number of users to create and maintain passwords.
Caching - but I am sure it will be improved by now. There were times when we expected the cache to be refreshed but it was stale.
Schema generation of endpoints from API response was sometimes incomplete as not all API calls returned all the fields. Will be good to have an ability to load the schema itself (XSD/JSON/Soap XML etc).
Denodo exposed web services were in preliminary stage when we used; I'm sure it will be improved by now.
Export/Import deployment, while it was helpful, there were unexpected issues without any errors during deployment. Issues were only identified during testing. Some views were not created properly and did not work. If it was working in the environment from where it was exported from, it should work in the environment where it is imported.
Denodo is a tool to rapidly mash data sources together and create meaningful datasets. It does have its downfalls though. When you create larger, more complex datasets, you will most likely need to cache your datasets, regardless of how proper your joins are set up. Since DV takes data from multiple environments, you are taxing the corporate network, so you need to be conscious of how much data you are sending through the network and truly understand how and when to join datasets due to this.
Delphix support could be a little better. It seems sometimes we bounce through support engineers until we get one that understands our issues and know how to fix it.
The other competitors in the market are Solix and Data Global and SAP. The pricing and the UI are much simpler and easy to put Delphix in the top spot.
We also looked at Delphix: the tool was quite powerful, easy to use, and competitive from a cost standpoint. However, since our entire data warehouse environment is built on the Oracle technology stack, it made sense to us to use the Oracle product here, as it integrates very well with other Oracle database and ETL products.
We have many compliance regulations we need to adhere to. Without this tool, we were always taking a risk of exposing client information, and get penalized by the State of the Feds (the financial consequences are significant).
So while the tool doesn't save us money directly, it greatly reduces the risk we had been taking all these years. To some degree, this is much like an insurance policy.
Given the above, it also allows us to share information with other departments/agencies, in situations where before we simply couldn't take the risk of exposing client information.
