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
Oracle Data Service Integrator
Score 6.4 out of 10
N/A
Oracle Data Service Integrator provides companies the ability to develop and manage federated data services for accessing single views of disparate information. Oracle Data Service Integrator is standards based, declarative, and enables re-usability of data services.
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.
Since adopting Oracle Data Service Integrator (ODSI) over a year ago, we have been able to integrate multiple sources of data from multiple sources into a very robust process. This has really helped our developers and data scientists research and improve our user data. They are able to use the ODSI built-in architecture to create tools and processes that make their quality of life much better.
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!
Denodo is great, but if you want or need local storage and/or replication, then Oracle Data Service Integrator is the way to go. ODSI allowed us to perform data aggregation and run reports against locally stored data, which was a must in our environment. Oracle is the clear winner when it comes to choosing a mature product that gets the job done.
