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."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."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The setup was easy. All Microsoft products are easy to set up."
"The initial setup was easy."
"The interface is very user-friendly."
"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."
"At one point, we did have to purchase an add-on."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"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."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"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."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
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.
