Perforce Delphix vs. Redgate SQL Provision

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.

Incentivized

• Storage consumption reduction.
• Data environments self service for consumers.
• Excellent documentation online.
• Great community for support you.
• Great company with great people working on it.

• 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.

Incentivized

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!

• Delphix has a brilliant way of documentation online.
• Delphix has the constant need to improve its quality and fix bugs quickly as well as transparently.
• With Delphix, my data remains secured.

Incentivized