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."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 like the completeness of the way I can build ETL workflows."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"Once you have learned Informatica, it is very easy to use."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"Deployment was simple and straightforward."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"It has a Data Catalog that uses the Model repository."
"Informatica PowerCenter is a very good ETL tool."
"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."
"I would like to see it be able to import data from NoSQL."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"The initial setup is not straightforward. You need expertise to do it."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
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, Qlik Replicate, Dataloader.io 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.