We performed a comparison between BMC Data Management for IMS and DB2 on zOS and Informatica PowerCenter 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 solution is stable."
"The most valuable features are the metadata repository and the data warehouse application console."
"What I like the most is that we have to deal with less while writing the queries."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"It has helped us monetize."
"Good product if you are trying implement data quality, data integration, and data management projects."
"If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful."
"Good interface, reasonable documentation."
"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."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"The developer tool documentation can be enhanced with a more clear explanation of each utility, accompanied by relevant examples, so that developers are able to create programs with ease."
"Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers."
"Support could be better."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
BMC Data Management for IMS and DB2 on zOS is ranked 21st in Database Development and Management with 2 reviews while Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews. BMC Data Management for IMS and DB2 on zOS is rated 8.6, while Informatica PowerCenter is rated 8.0. 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 Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". BMC Data Management for IMS and DB2 on zOS is most compared with AWS Database Migration Service, Dataloader.io, Qlik Replicate and IBM App Connect, whereas Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks 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.