We performed a comparison between BMC Data Management for IMS and DB2 on zOS and WhereScape RED based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, Quest Software, SolarWinds and others in Database Development and Management."BMC Data Management improved our data recovery process by simplifying it."
"I have worked with DB2's great features in the last five years. The IDAA feature transformed the vision of warehousing, business analytics, and big data at my bank. Besides the mainframe, I saw that this solution was evolutionary. It gives real-time information."
"It has a built-in automatic scheduling environment."
"Naturally produces a way to easily debug your DW data solutions."
"The most valuable feature is the metadata generated code."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time."
"RED has provided us the ability to integrate, stage, and transform data from diverse sources into an enterprise-grade data warehouse which meets the needs of my organization, but it also enables us to easily and quickly make ETL or DW changes."
"I found the initial setup very easy."
"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."
"One area for improvement with this product could be in providing clearer guidance and tools for disaster recovery planning and execution."
"DB2 is a hard tool to grasp. It's hard for users to learn how to use it. It's not easy to see how it works."
"Technical support isn't the best."
"No support for change data capture or delta detection - that must be custom coded ."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"Improve the object renaming ability (it works, but it could be more automated)."
"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."
"Customization could be better."
Earn 20 points
BMC Data Management for IMS and DB2 on zOS is ranked 21st in Database Development and Management with 2 reviews while WhereScape RED is ranked 48th in Data Integration. BMC Data Management for IMS and DB2 on zOS is rated 8.6, while WhereScape RED is rated 8.2. The top reviewer of BMC Data Management for IMS and DB2 on zOS writes "Improves disaster recovery processes and offers an efficient CPU cycle optimization ". On the other hand, the top reviewer of WhereScape RED writes "Quick to set up, flexible, and stable". BMC Data Management for IMS and DB2 on zOS is most compared with AWS Database Migration Service, Qlik Replicate and IBM App Connect, whereas WhereScape RED is most compared with Azure Data Factory, SSIS, Informatica PowerCenter, Matillion ETL and Denodo.
We monitor all Database Development and Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.