We performed a comparison between BMC Data Management for IMS and DB2 on zOS and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Database Development and Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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."
"The setup is straightforward. It's very easy to install."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"The interface is very user-friendly."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"The performance and stability are good."
"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."
"One area for improvement with this product could be in providing clearer guidance and tools for disaster recovery planning and execution."
"The security could be improved, as it is more important in our context."
"Generic processes should be used instead of custom code for each table."
"I would like to see more features in terms of the integration with Azure Data Factory."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"The performance of this solution is not as good as other tools in the market."
"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."
"Improvement as per customer requirements."
"Video training would be a helpful addition."
BMC Data Management for IMS and DB2 on zOS is ranked 20th 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 Dataloader.io, AWS Database Migration Service, IBM App Connect and Qlik Replicate, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our BMC Data Management for IMS and DB2 on zOS vs. SSIS report.
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.