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."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"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."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"The number of docs has been reduced drastically, which is very good."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"Has a good visual tool for data mapping."
"The product's initial setup phase is very easy."
"UI-based ability to create data mapping."
"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."
"While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"The pricing could be improved."
"Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
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.