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."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"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 simplicity of the solution is great. The solution also offers excellent integration."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"It's a competent product."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"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."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"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."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"I would like to see better integration with Power BI."
"It needs more integration tools, so you can connect to different sources."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"The solution could improve by having quicker release updates."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
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, Dataloader.io and IBM App Connect, 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.