BMC Data Management for IMS and DB2 on zOS vs Informatica PowerExchange comparison

BMC Data Management for IMS and DB2 on zOS vs. Informatica PowerExchange

Download the complete report

Helped 850,028 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

BMC Data Management for IMS...

Average Rating

8.6

Reviews Sentiment

7.6

Number of Reviews

Ranking in other categories

Database Development and Management (21st)

Informatica PowerExchange

Average Rating

8.0

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Data Integration (18th)

Mindshare comparison

BMC Data Management for IMS and DB2 on zOS and Informatica PowerExchange aren’t in the same category and serve different purposes. BMC Data Management for IMS and DB2 on zOS is designed for Database Development and Management and holds a mindshare of 0.4%, down 0.4% compared to last year.
Informatica PowerExchange, on the other hand, focuses on Data Integration, holds 1.1% mindshare, up 1.0% since last year.

Database Development and Management

Data Integration

Featured Reviews

RobertSamson

Technical Consultant at Services Robert Samson SCRS

Improves disaster recovery processes and offers an efficient CPU cycle optimization

Using BMC Data Management for IMS and DB2 on z/OS has greatly improved our database administration tasks. Although we don't test the database before production, we have experienced benefits in disaster recovery situations and capacity management. For instance, when facing capacity issues during peak transaction times, I've been able to quickly allocate additional resources to ensure smooth operations. This has been crucial, especially during times when the demand surges, such as peak flight hours.

Read full review

Mohammad Faizan Ahmad

Sr. Technical Engineer at Investcorp Bank BSC

Helpful in handling areas like complex data sources and data processing but needs improved support services

The major challenge with the tool stems from the fact that if you are implementing it in the cloud, then it has to be within the framework. Another challenge is the large volume of data. Informatica PowerExchange is a product through which we enable connectivity, so it is not an application product or a stand-alone tool, but Informatica's core systems or IICS uses it to connect to multiple systems. The major challenge associated with the tool is on the infrastructure side. The tool's features could be something faster with more connectors. A number of connectors can help connect to a wide variety of applications. The tool should focus on reducing the resilient time, like, if any network disconnectivity happens, then auto-reconnection and the retry method should be more robust so that manual intervention is not required. We communicate with the tool's support team as we need to raise our issues with them. I have already worked with Informatica and have a total experience of around eight to nine years; the one problem with the tool is its support team since they take a lot of time to address a particular issue. If one time you schedule a call and explain the situation to them about the issue, the support team will raise tickets and take notes. They will ask you to share the logs or screenshots of the errors, and you will get no resolution. The support team will randomly give you some documents and expect you to go through them, and if you get back to them with questions, a new person will be allocated, and you will have to start explaining everything again. I would not say it is a pleasant experience.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"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 data transformation is the solution's most valuable feature."

"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."

"Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking."

"This product is easy to install and it can be done in a few hours."

"Provides a significant amount of control over the landscape and overall implementation."

"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."

"PowerExchange is one of the best software solutions to build integrations with non-Oracle or standard database services, especially for SAP and Hana products."

"The product's initial setup phase was not complex. The tool is easy to install onto any of the servers, and you can integrate it."

More Informatica PowerExchange pros

Cons

"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."

"They should make it quick and easy for use of citizen data integration or for people or integrators developing at the customer side. They could be development teams within the business team. For them, the product owners can consider making it a little bit more seamless and a little bit more democratized."

"I would like the stability to improve."

"One area that could be improved is performance, as PowerExchange sometimes has less performance compared to native connectors when dealing with a huge volume of data."

"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."

"Informatica is very expensive in all aspects, so the pricing is something that could be improved."

"The major shortcoming of PowerExchange is high availability and failover. None of the versions we've used to date have had the out-of-the-box ability to enable failover and high-availability requirements. This is a significant challenge and risk."

"I would like to have easier integration with cloud platforms."

"The solution could be made more user-friendly. The configurations are also quite difficult."

More Informatica PowerExchange cons

Pricing and Cost Advice

Information not available

"There are licensing and connector costs. Basically, Informatica is pay-as-you-use."

"The product is not very expensive."

"Many users don't prefer to use the product, considering the high costs attached to the licensing part of the solution."

"There is a need to pay towards the licensing cost of the product. It is an expensive product."

"It's expensive. In fact, nobody would buy any product of Informatica if the price was the only consideration. It costs money, and it doesn't come cheap, but it provides value for money in many ways."

"An annual package license fee is required."

"The cost of PowerExchange is reasonable. It does not rely on complicated formulas or unrealistic equations. The pricing model is straightforward. There is one component, and real-time integration is included. Some other solutions require purchasing additional modules or third-party plugins for this capability."

See which vendors are best for you

Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.

See recommendations

850,028 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

31%

Insurance Company

13%

Manufacturing Company

10%

Logistics Company

Financial Services Firm

27%

Computer Software Company

12%

Insurance Company

Government

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What do you like most about BMC Data Management for IMS and DB2 on zOS?

BMC Data Management improved our data recovery process by simplifying it.

What needs improvement with BMC Data Management for IMS and DB2 on zOS?

One area for improvement with this product could be in providing clearer guidance and tools for disaster recovery planning and execution. As someone involved in managing infrastructure, understandi...

What advice do you have for others considering BMC Data Management for IMS and DB2 on zOS?

From my perspective as an infrastructure guy, the most valuable aspect of BMC's data management solutions was their ability to optimize CPU cycles, improving IMS performance without directly impact...

What do you like most about Informatica PowerExchange?

The product’s flexibility is valuable.

What is your experience regarding pricing and costs for Informatica PowerExchange?

The pricing and cost depend heavily on SAP's licensing structure, especially if using SAP integration services. Informatica is seen as broader in integrations.

What needs improvement with Informatica PowerExchange?

One area that could be improved is performance, as PowerExchange sometimes has less performance compared to native connectors when dealing with a huge volume of data. Additionally, the tool faces t...

Informatica PowerCenter vs Informatica PowerExchange

Comparisons

No data available

Compared 68% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs Informatica PowerExchange

Compared 10% of the time

Oracle GoldenGate vs Informatica PowerExchange

Compared 9% of the time

AWS Database Migration Service vs Informatica PowerExchange

Compared 5% of the time

Azure Data Factory vs Informatica PowerExchange

Compared 4% of the time

More Informatica PowerExchange Competitors

Product Reports

Database Development and Management

Download BMC Data Management for IMS and DB2 on zOS product report

BMC Data Management for IMS and DB2 on zOS report

Informatica PowerExchange

Download Informatica PowerExchange product report

Also Known As

BMC Data Management for IMS and DB2 on z/OS, Data Management for IMS and DB2 on z/OS

PowerExchange, Connectors

Overview

Transform the management of your DB2 databases to meet the scale and complexity of digital business

Run DB2 utilities with BMC Next Generation Technology to optimize your data and improve application performance
Eliminate downtime and increase availability of business services
Ensure the integrity of structured and unstructured data
Take control with intelligent automation and policy-driven rules
Bridge the gap from green-screen to modern, secure, self-service user interfaces
Move to DB2 12 and beyond with confidence

BMC

Informatica PowerExchange Connectors provides high performance, out-of-the-box connectivity without having to develop custom data access programs.

Informatica

Sample Customers

Airline Tariff Publishing Co (ATPCO), AtTask, MetaScale

ACH Food, BNSF Railway Company, Illinois State University

BMC Data Management for IMS and DB2 on zOS vs. Informatica PowerExchange