We performed a comparison between BMC Data Management for IMS and DB2 on zOS and Denodo based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon, MuleSoft, Matillion and others in Cloud Data Integration."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."
"BMC Data Management improved our data recovery process by simplifying it."
"This solution provides us with the ability to sync data, and make it available for anyone to use across the business."
"The best thing about Denodo is that creating and deploying a web service can be done in about 10 minutes, compared to a whole day when it comes to other solutions (such as when deploying with Java and AWS)."
"The ability to transfer data is very valuable."
"In PL/SQL, first you need to gather all the data and then start writing the file, but in Denodo you fetch the data and write the data simultaneously. So, for example, if you have 1 million or 2 million records, you don't have to wait to fetch all of the 2 million; you can keep on fetching and writing in the file simultaneously."
"It is easy to virtualize data using the solution."
"The ability to connect to a lot of different sources."
"The most valuable features are query optimization and the single language independence from the sources we're using to catch data."
"Denodo makes it easy to export data as a service or data link to other services."
"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."
"The data catalog certainly has room for improvement. It is functional but we look forward to development. We are in constant contact with Denodo and they are fully aware of our needs."
"Performance management could be improved."
"The dropdown menus feel antiquated to me, and the administrative portals need improvement."
"I would like it if we could pull the data model or export the data model because Denodo has, based on how you build, something called associations. The data model gets very confusing when you go look at it. It depends on how you define it, but it's really huge. I wish there was a way to export it into Visio. It could be that they already have a way to do it, and I don't know, but it would be much easier for the architects and even for the developers to look at it than scrunching it into the screen and expanding every small portion of it. If there was an easy way to export the Denodo model into another modeling tool and view it, it would be great."
"Documentation needs to be improved"
"We occasionally have some integration issues that we need to work through."
"Sometimes, Windows-related functions do not work properly in Denodo. The analytic functions in SQL do not work properly."
"It would be beneficial to make sure that the team that will be using Denodo has some kind of training on how to use the product at least a month beforehand, and there could even be some kind of feedback or Q&A sessions to go along with the training. If Denodo were able to provide this kind of training, it would be very helpful to users in insurance and banking companies because the staff are typically older and not always technically-minded."
Earn 20 points
BMC Data Management for IMS and DB2 on zOS is ranked 32nd in Database Development and Management with 2 reviews while Denodo is ranked 8th in Cloud Data Integration with 29 reviews. BMC Data Management for IMS and DB2 on zOS is rated 8.6, while Denodo is rated 7.8. 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 Denodo writes "Saves our underwriters' time with data virtualization, but could provide more learning resources". BMC Data Management for IMS and DB2 on zOS is most compared with AWS Database Migration Service, Qlik Replicate, IBM InfoSphere Optim and IBM App Connect, whereas Denodo is most compared with Azure Data Factory, AWS Glue, Delphix, Informatica PowerCenter and Mule Anypoint Platform.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud Data Integration 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.