Try our new research platform with insights from 80,000+ expert users

AWS Glue vs BMC Data Management for IMS and DB2 on zOS comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

AWS Glue
Average Rating
7.8
Reviews Sentiment
7.1
Number of Reviews
43
Ranking in other categories
Cloud Data Integration (1st)
BMC Data Management for IMS...
Average Rating
8.6
Number of Reviews
2
Ranking in other categories
Database Development and Management (19th)
 

Featured Reviews

Ajaykumar Myana - PeerSpot reviewer
Jul 31, 2023
Provides serverless mechanism, easy data transformation and automated infrastructure management
I had the source data, which was unstructured and non-fixable, and my responsibility was to convert it into structured data. For this task, I used PySpark as the programming language. With Python, I implemented the creation of a data frame using Glue jobs. Since Glue jobs are a serverless…
RS
Feb 29, 2024
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…

Quotes from Members

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

Pros

"Its ease of use, cost-effectiveness, and highly secure architecture are some of the most valuable features."
"The solution is stable and reliable."
"It's very good to manage."
"AWS Glue is quite better than other tools, but you have to learn it properly before you start using it."
"The key role for Glue is that it hosts our metadata before rolling out our actual data. This is the major advantage of using this solution and our clients client have been very satisfied with it."
"The most valuable feature of AWS Glue is scalability."
"The facility to integrate with S3 and the possibility to use Jupyter Notebook inside the pipeline are the most valuable features."
"It is AWS-integrated. There is end-to-end integration with the other AWS services. It is also user-friendly."
"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."
 

Cons

"AWS Glue should be more reliable and faster in processing. Enhancing the speed of data processing would be beneficial."
"The monitoring is not that good."
"Cost-wise, AWS Glue is expensive, so that's an area for improvement. The process for setting up the solution was also complex, which is another area for improvement."
"The crucial problem with AWS Glue is that it only works with AWS. It is not an agnostic tool like Pentaho. In PowerCenter, we can install the forms from Google and other vendors, but in the case of AWS Glue, we can only use AWS."
"Only people who can code, either in Java or Python, can use the product freely. Those who don't know Java or Python might find using AWS Glue difficult."
"We face performance issues when using AWS Glue for data transformation and integration."
"It would be better if it were more user-friendly. The interesting thing we found is that it was a little strange at the beginning. The way Glue works is not very straightforward. After trying different things, for example, we used just the console to create jobs. Then we realized that things were not working as expected. After researching and learning more, we realized that even though the console creates the script for the ETL processes, you need to modify or write your own script in Spark to do everything you want it to do. For example, we are pulling data from our source database and our application database, which is in Aurora. From there, we are doing the ETL to transform the data and write the results into Redshift. But what was surprising is that it's almost like whatever you want to do, you can do it with Glue because you have the option to put together your own script. Even though there are many functionalities and many connections, you have the opportunity to write your own queries to do whatever transformations you need to do. It's a little deceiving that some options are supposed to work in a certain way when you set them up in the console, but then they are not exactly working the right way or not as expected. It would be better if they provided more examples and more documentation on options."
"AWS Glue would be improved by making it easier to switch from single to multi-cloud."
"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."
"One area for improvement with this product could be in providing clearer guidance and tools for disaster recovery planning and execution."
 

Pricing and Cost Advice

"This solution is affordable and there is an option to pay for the solution based on your usage."
"I rate pricing an eight out of ten."
"AWS Glue is quite costly, especially for small organizations."
"The current cost is around forty to fifty thousand a month."
"The pricing is a bit higher than other solutions like Athena and EC2. If the pricing becomes more scaled or flexible, it will be good because you have to pay 44 cents just for one DPU for an hour. If you increase DPUs to 5 or 10, the pricing gets multiplied. There are also some time limits like 0 to 10 minutes or 10 to 20 minutes. If the pricing is according to the minutes, it would be better because you have to limit your job to 10 minutes or 20 minutes."
"The solution's pricing is based on DPUs so it is a good idea to optimize use or it can get expensive."
"Its price is good. We pay as we go or based on the usage, which is a good thing for us because it is simple to forecast for the tool. It is good in terms of the financial planning of the company, and it is a good way to estimate the cost. It is also simple for our clients. In my opinion, it is one of the best tools in the market for ETL processes because of the fact that you pay as you use, which separates it from other big tools such as PowerCenter, Pentaho Data Integration, and Talend."
"Technical support is a paid service, and which subscription you have is dependent on that. You must pay one of them, and it ranges from $15,000 to $25,000 per year."
Information not available
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
814,763 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
21%
Computer Software Company
14%
Manufacturing Company
8%
Insurance Company
6%
Financial Services Firm
25%
Insurance Company
16%
Government
10%
Manufacturing Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

How do you select the right cloud ETL tool?
AWS Glue and Azure Data factory for ELT best performance cloud services.
How does Talend Open Studio compare with AWS Glue?
We reviewed AWS Glue before choosing Talend Open Studio. AWS Glue is the managed ETL (extract, transform, and load) from Amazon Web Services. AWS Glue enables AWS users to create and manage jobs in...
What are the most common use cases for AWS Glue?
AWS Glue's main use case is for allowing users to discover, prepare, move, and integrate data from multiple sources. The product lets you use this data for analytics, application development, or ma...
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...
 

Also Known As

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

Overview

 

Sample Customers

bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
Airline Tariff Publishing Co (ATPCO), AtTask, MetaScale
Find out what your peers are saying about AWS Glue vs. BMC Data Management for IMS and DB2 on zOS and other solutions. Updated: October 2024.
814,763 professionals have used our research since 2012.