BMC Data Management for IMS and DB2 on zOS vs Matillion ETL comparison

BMC Data Management for IMS and DB2 on zOS vs. Matillion ETL

Download the complete report

Helped 814,763 peers since 2012

Categories and Ranking

BMC Data Management for IMS...

Average Rating

8.6

Number of Reviews

Ranking in other categories

Database Development and Management (19th)

Matillion ETL

Average Rating

8.4

Number of Reviews

Ranking in other categories

Cloud Data Integration (5th)

Featured Reviews

RobertSamson

Technical Consultant at Services Robert Samson SCRS

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…

Read full review

AntonHaupt

Data Architect at Capitec

Jan 23, 2024

Efficient data integration and transformation with seamless cloud-native integration

In our small business unit, we currently have around four users, with two of them utilizing Matillion within our organization. Considering our growing needs, we're contemplating transitioning to an enterprise SaaS solution where we would share the same instance. Currently, each user is billed individually, but consolidating to a shared instance seems more efficient. Scalability is excellent when using the SaaS solution, easily reaching a rating of ten out of ten. Each data pipeline request is encapsulated within a Docker container and spun off, allowing for instant scalability. Overall, I would rate it a nine out of ten in terms of performance and scalability.

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 product has a good user interface."

"The technical support treats us well. They already have a support portal, and they are responsive, which helps."

"The most valuable feature of Matillion ETL is its ease of use. If you have had some experience with other solutions, such as Snowflake, the use of this solution will be simple."

"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."

"It has good integrations with Amazon Redshift and other AWS services."

"The most valuable feature of Matillion ETL is the ETL. The solution is open-source which provides advantages, such as good performance and high efficiency. Additionally, it supports three data types which eliminates predefining the data, and we can write script models in Python."

"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."

"The tool's middle-dimensional structure significantly simplifies obtaining the right data at the appropriate level. This feature makes deploying our applications easier since we utilize a single source without publishing data from various sources."

More Matillion ETL 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."

"When using the SQL loader type there were not a lot of pre-processing features for the data. For example, if there is a table with twenty columns, but we only want to load ten columns. In that case, we can use a security script to select the specific columns needed. However, if we want to perform extensive pre-processing of the data, I faced some challenges with Matillion ETL. I did not encounter many challenges, but my overall experience is limited as I only have three years of experience."

"There are certain functions that are available in other ETL tools which are still not present in Matillion ETL. It would be good to have more features."

"The cost of the solution is high and could be reduced."

"The improvement area could be possible if the tool provides better integration capabilities with other ecosystems, including governance tools or data cataloging tools, as it is currently an area where the solution is lacking."

"The product's scalability needs improvement. Perhaps adding more connectors would be beneficial."

"In the next release, we would like to have connections to more databases."

"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."

"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."

More Matillion ETL cons

Pricing and Cost Advice

Information not available

"It was very easy to purchase through the AWS Marketplace, but it was also expensive."

"Purchasing it through the AWS Marketplace is pretty convenient. There is a little bit of back and forth in terms of the licensing based on the machine size, but it seems to have worked out well. it is convenient to have it all as part of our AWS billing."

"The pricing depends on what edition the customer opts for. For example, the standard edition is priced at $2.00 per credit. And you are only charged when you use it. You're not charged when it's idle."

"The solution is very cheap. You're paying $2.50 an hour and if you set your service up, which you can do, you're not getting charged. Currently, our ETL process is just an overnight process that runs for about an hour. I can start and stop my server just for an hour if I want to and spent $2.50 a day for an ETL solution. There are no additional costs."

"It is cost-effective. Based on our use case, it's efficient and cheap. It saves a lot of money and our upfront costs are less."

"Its price depends on what you expect. You pay on a monthly basis, but there is a possibility to have special contracts depending on the installation."

"I have heard from my manager and other higher ups, "This product is cheaper than other things on the market," and they have done the research."

"The cost of the solution is high and could be reduced."

More Matillion ETL pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.

See recommendations

814,763 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

25%

Insurance Company

16%

Government

10%

Manufacturing Company

Financial Services Firm

16%

Computer Software Company

15%

Manufacturing 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 Matillion ETL?

The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.

What is your experience regarding pricing and costs for Matillion ETL?

The solution's pricing is not based on the licensing cost but on the running hours when the Matillion instance is up and running. Its pricing model is different from the traditional pricing models ...

What needs improvement with Matillion ETL?

Depending on the use case, the solution's pricing could be improved. Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems.

Dataloader.io vs BMC Data Management for IMS and DB2 on zOS

Comparisons

Compared 100% of the time

More BMC Data Management for IMS and DB2 on zOS Competitors

Azure Data Factory vs Matillion ETL

Compared 13% of the time

SSIS vs Matillion ETL

Compared 10% of the time

AWS Glue vs Matillion ETL

Compared 9% of the time

Snowflake vs Matillion ETL

Compared 8% of the time

Informatica PowerCenter vs Matillion ETL

Compared 7% of the time

More Matillion ETL 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

Matillion ETL

Download Matillion ETL product report

Also Known As

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

Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery

Learn More

BMC

Matillion

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

Matillion ETL is a powerful tool for extracting, transforming, and loading large amounts of data from various sources into cloud data warehouses like Snowflake. Its ability to load data dynamically and efficiently using metadata is a standout feature, as is its open-source ETL with good performance and high efficiency.

The solution has a graphical interface for jobs, is easily adjustable and extensible, and allows for scheduling and error reporting. Matillion ETL has helped organizations move to a cloud-based solution, bridge the gap between on-premises and on-cloud, and perform complex migration projects.

Sample Customers

Airline Tariff Publishing Co (ATPCO), AtTask, MetaScale

Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc

BMC Data Management for IMS and DB2 on zOS vs. Matillion ETL