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
Starburst Enterprise
Score 10.0 out of 10
N/A
Starburst Enterprise is a fully supported, production-tested and enterprise-grade distribution of open source Trino (formerly Presto® SQL). It aims to improve performance and security while making it easy to deploy, connect, and manage a Trino environment. Through connecting to any source of data – whether it’s located on-premise, in the cloud, or across a hybrid cloud environment – Starburst provides analytics tools to users while accessing data that lives anywhere.
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.
If you run a SQL query, Starburst Presto can help you track efficiently the status of SQL query. It can also track how many resources have been allocated for execution and what is the optimal way to run the query without hindrance. It also provides good information on worker nodes and how parallel threads are running together.
User/PWD management in the Delphix Self-Service web page does not support LDAP nor AD security groups. This creates a hassle if you have a large number of self-service users to create and maintain passwords for. The fix for this is supposed to be the new Central Management tool. We just ended up creating jobs in Jenkins (which supports groups) using the python-examples scripts from the Delphix Github.
Reporting on storage and performing capacity planning is not easy when running many (20+) virtual databases. The latest release and new Central Management tool are both supposed to storage reporting much better.
Delphix Data Masking tool could handle masking of complex flat files better. We ended up creating a tagger and un-tagger to add/remove metadata to enable Delphix masking to be able to mask our complex flat file. Would have been nice if that capability was already built into the masking tool.
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.
There are many first generation test data management tools that use SQL scripts behind the scenes to create small subsets of data for testing of functional subjects within the database (i.e. Claims or Membership, etc.). Delphix differs by operating at the data block level on disk, sitting between the db engine (Oracle, SQL, etc.) and the physical storage. This allows Delphix to provide full size virtual databases for the cost of not much more than enough storage for a single prod sized copy. Intelligent block sharing also enables full db refreshes and rewinds in minutes, not hours or days, all without having to maintain any schema relationship information which is required in first-gen TDM tools. Delphix does not perform any SQL functions so its not for extract, transform, load or creating smaller subset databases. We figured why subset the data if we can get a full virtual copy for no additional cost!
Most of our systems were compatible with Starburst Presto. The dashboard which they provide was fairly intuitive and easy to use. The learning curve wasn't that much. Also, the parallel processing part was an additional feature that we didn't find in many competitive products. The pricing was a little higher but it was worth the trade-off.