We performed a comparison between BMC Data Management for IMS and DB2 on zOS and SSIS 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."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"The setup was easy. All Microsoft products are easy to set up."
"SSIS' most valuable feature is its reporting services."
"The UI is very user-friendly."
"It is easy to set up the product."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"The interface is very user-friendly."
"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 interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"It would be nice if you could run SSIS on other environments besides Windows."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
BMC Data Management for IMS and DB2 on zOS is ranked 21st in Database Development and Management with 2 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. BMC Data Management for IMS and DB2 on zOS is rated 8.6, while SSIS is rated 7.6. 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 SSIS writes "Maintaining the solution and contacting its support team is easy". BMC Data Management for IMS and DB2 on zOS is most compared with AWS Database Migration Service, Qlik Replicate, IBM App Connect and Dataloader.io, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue.
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.
