BMC Data Management for IMS and DB2 on zOS vs Pentaho Data Integration and Analytics comparison

BMC Data Management for IMS and DB2 on zOS vs. Pentaho Data Integration and Analytics

Download the complete report

Helped 860,168 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)

Pentaho Data Integration an...

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Integration (19th)

Mindshare comparison

BMC Data Management for IMS and DB2 on zOS and Pentaho Data Integration and Analytics 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.6%, up 0.4% compared to last year.
Pentaho Data Integration and Analytics, on the other hand, focuses on Data Integration, holds 1.8% mindshare, up 0.8% 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

Aqeel UR Rehman

BI Analyst at a computer software company with 51-200 employees

Transform data efficiently with rich features but there's challenges with large datasets

Currently, I am using Pentaho Data Integration for transforming data and then loading it into different platforms. Sometimes, I use it in conjunction with AWS, particularly S3 and Redshift, to execute the copy command for data processing Pentaho Data Integration is easy to use, especially when…

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 amount of data that it loads and processes is good."

"One of the most valuable features is the ability to create many API integrations. I'm always working with advertising agents and using Facebook and Instagram to do campaigns. We use Pentaho to get the results from these campaigns and to create dashboards to analyze the results."

"Pentaho Data Integration is easy to use, especially when transforming data."

"Flexible deployment, in any environment, is very important to us. That is the key reason why we ended up with these tools. Because we have a very highly secure environment, we must be able to install it in multiple environments on multiple different servers. The fact that we could use the same tool in all our environments, on-prem and in the cloud, was very important to us."

"We use Lumada’s ability to develop and deploy data pipeline templates once and reuse them. This is very important. When the entire pipeline is automated, we do not have any issues in respect to deployment of code or with code working in one environment but not working in another environment. We have saved a lot of time and effort from that perspective because it is easy to build ETL pipelines."

"The graphical nature of the development interface is most useful because we've got people with quite mixed skills in the team. We've got some very junior, apprentice-level people, and we've got support analysts who don't have an IT background. It allows us to have quite complicated data flows and embed logic in them. Rather than having to troll through lines and lines of code and try and work out what it's doing, you get a visual representation, which makes it quite easy for people with mixed skills to support and maintain the product. That's one side of it."

"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."

"It's my understanding that the product can scale."

More Pentaho Data Integration and Analytics 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."

"The testing and quality could really improve. Every time that there is a major release, we are very nervous about what is going to get broken. We have had a lot of experience with that, as even the latest one was broken. Some basic things get broken. That doesn't look good for Hitachi at all. If there is one place I would advise them to spend some money and do some effort, it is with the quality. It is not that hard to start putting in some unit tests so basic things don't get broken when they do a new release. That just looks horrible, especially for an organization like Hitachi."

"The web interface is rusty, and the biggest problem with Pentaho is debugging and troubleshooting. It isn't easy to build the pipeline incrementally. At least in our case, it's hard to find a way to execute step by step in the debugging mode."

"I work with different databases. I would like to work with more connectors to new databases, e.g., DynamoDB and MariaDB, and new cloud solutions, e.g., AWS, Azure, and GCP. If they had these connectors, that would be great. They could improve by building new connectors. If you have native connections to different databases, then you can make instructions more efficient and in a more natural way. You don't have to write any scripts to use that connector."

"I was not happy with the Pentaho Report Designer because of the way it was set up. There was a zone and, under it, another zone, and under that another one, and under that another one. There were a lot of levels and places inside the report, and it was a little bit complicated. You have to search all these different places using a mouse, clicking everywhere... each report is coded in a binary file... You cannot search with a text search tool..."

"I would like to see support for some additional cloud sources. It doesn't support Azure, for example. I was trying to do a PoC with Azure the other day but it seems they don't support it."

"The support for the Enterprise Edition is okay, but what they have done in the last three or four years is move more and more things to that edition. The result is that they are breaking the Community Edition. That's what our impression is."

"Although it is a low-code solution with a graphical interface, often the error messages that you get are of the type that a developer would be happy with. You get a big stack of red text and Java errors displayed on the screen, and less technical people can get intimidated by that. It can be a bit intimidating to get a wall of red error messages displayed. Other graphical tools that are focused at the power user level provide a much more user-friendly experience in dealing with your exceptions and guiding the user into where they've made the mistake."

"I have been facing some difficulties when working with large datasets. It seems that when there is a large amount of data, I experience memory errors."

More Pentaho Data Integration and Analytics cons

Pricing and Cost Advice

Information not available

"Sometimes we provide the licenses or the customer can procure their own licenses. Previously, we had an enterprise license. Currently, we are on a community license as this is adequate for our needs."

"We did a two or three-year deal the last time we did it. As compared to other solutions, at least so far in our experience, it has been very affordable. The licensing is by component. So, you need to make sure you only license the components that you really intend to use. I am not sure if we have relicensed after the Hitachi acquisition, but previously, multi-year renewals resulted in a good discount. I'm not sure if this is still the case. We've had the full suite for a lot of years, and there is just the initial cost. I am not aware of any additional costs."

"I mostly used the open-source version. I didn't work with a license."

"For most development tasks, the Enterprise edition should be sufficient. It depends on the type of support that you require for your production environment."

"If a company is looking for an ETL solution and wants to integrate it with their tech stack but doesn't want to spend a bunch of money, Pentaho is a good solution"

"You need to go through the paid version to have Hitachi Lumada specialized support. However, if you are using the free version, then you will have only the community support. You will depend on the releases from Hitachi to solve some problem or questions that you have, such as bug fixes. You will need to wait for the newest versions or releases to solve these types of problems."

"It does seem a bit expensive compared to the serverless product offering. Tools, such as Server Integration Services, are "almost" free with a database engine. It is comparable to products like Alteryx, which is also very expensive."

"There is a good open source option (Community Edition)."

More Pentaho Data Integration and Analytics pricing and cost advice

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

860,168 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

32%

Manufacturing Company

11%

Insurance Company

Logistics Company

Financial Services Firm

21%

Computer Software Company

14%

Government

Manufacturing Company

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

Which ETL tool would you recommend to populate data from OLTP to OLAP?

Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition : https://www.hitachivantara.com/en-us/pdf/brochure/leverage-open-source-benefits-with-assurance-of-hita...

What do you think can be improved with Hitachi Lumada Data Integrations?

In my opinion, the reporting side of this tool needs serious improvements. In my previous company, we worked with Hitachi Lumada Data Integration and while it does a good job for what it’s worth, ...

What do you use Hitachi Lumada Data Integrations for most frequently?

My company has used this product to transform data from databases, CSV files, and flat files. It really does a good job. We were most satisfied with the results in terms of how many people could us...

Oracle Data Integrator (ODI) vs Pentaho Data Integration and Analytics

Comparisons

No data available

Compared 16% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 11% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 10% of the time

Talend Open Studio vs Pentaho Data Integration and Analytics

Compared 9% of the time

Azure Data Factory vs Pentaho Data Integration and Analytics

Compared 8% of the time

More Pentaho Data Integration and Analytics 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

Pentaho Data Integration and Analytics

Download Pentaho Data Integration and Analytics product report

Pentaho Data Integration and Analytics report

Also Known As

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

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

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

Pentaho Data Integration stands as a versatile platform designed to cater to the data integration and analytics needs of organizations, regardless of their size. This powerful solution is the go-to choice for businesses seeking to seamlessly integrate data from diverse sources, including databases, files, and applications. Pentaho Data Integration facilitates the essential tasks of cleaning and transforming data, ensuring it's primed for meaningful analysis. With a wide array of tools for data mining, machine learning, and statistical analysis, Pentaho Data Integration empowers organizations to glean valuable insights from their data. What sets Pentaho Data Integration apart is its maturity and a vibrant community of users and developers, making it a reliable and cost-effective option. Pentaho Data Integration offers a range of features, including a comprehensive ETL toolkit, data cleaning and transformation capabilities, robust data analysis tools, and seamless deployment options for data integration and analytics solutions, making it a go-to solution for organizations seeking to harness the power of their data.

Hitachi Vantara

Sample Customers

Airline Tariff Publishing Co (ATPCO), AtTask, MetaScale

66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute

BMC Data Management for IMS and DB2 on zOS vs. Pentaho Data Integration and Analytics