Perforce Delphix vs. Oracle Big Data SQL Cloud Service

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

Oracle Big Data SQL Cloud Service is useful for large organizations with more than 5,000 employees where it will help manage the company's human resources information, and also useful for companies who have a big number of items and so one, it's perfect for large organizations. Unfortunately, this makes it an expensive solution for small to medium organizations.

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.

• Store Data
• Organize Data
• Integrate Data

Incentivized

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

• Needs some modernization to its UI
• Takes some time to analyze big chunks of Data

Incentivized

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!

Oracle Big Data SQL Cloud Service was able to provide solutions to all our of needs at that time and was the fastest solution to be implemented.

Incentivized

• 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