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

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

Download the complete report

Helped 859,533 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 (20th)

Matillion Data Productivity...

Average Rating

8.4

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

Cloud Data Integration (8th)

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

Tomáš Hronek

Data Engineer at Merck

Used for wrangling or transforming data from sources like S3 and Databricks

I use Matillion ETL for wrangling or transforming data from sources like S3 and Databricks The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation. Sometimes, we have issues with the solution's stability and need to restart it for…

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

"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."

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

"The simplicity of this tool is nice. It has a good graphical user interface. You can also do a lot of generic stuff in the tool. If there is good connectivity to a cloud database, such as Snowflake, and you can have a lot of Snowflake functionality in the tool."

"Matillion ETL is one hundred percent stable."

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

"The product has a good user interface."

"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines."

More Matillion Data Productivity Cloud pros

Cons

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

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

"It can have multi-environment support. We should be able to deploy it in different environments. Its integration with SAP connection is not so nice, which should be improved. It can also support an on-prem database."

"Unlike Snowflake which automatically takes care of upgrading to the latest version and includes additional features, with Matillion ETL we need to do this ourselves."

"The tool's lineage is very weak."

"Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level."

"The product must enhance its near-real-time data capture feature."

"Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems."

"Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."

More Matillion Data Productivity Cloud cons

Pricing and Cost Advice

Information not available

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

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

"It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."

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

"A rough estimation of the cost is around 20,000 dollars a month, however, this is dependent on the machine used and how Matillion ETL is used."

"Matillion ETL is expensive."

"The AWS pricing and licensing are a cost-effective solution for data integration needs."

"Matillion ETL has a pay-as-you-go pricing model of a few dollars per hour of runtime."

More Matillion Data Productivity Cloud 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

859,533 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

19%

Computer Software Company

15%

Manufacturing Company

Energy/Utilities 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...

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?

While pricing can be an issue compared to other solutions, Matillion Data Productivity Cloud offers discounts and special deals, especially when dealing with high-volume clients or fewer existing c...

What needs improvement with Matillion ETL?

There are problems with GCP connectivity. Specifically, connections to BigQuery for extracting information are complex, and the optimization of the extraction process requires improvements. I raise...

Azure Data Factory vs Matillion Data Productivity Cloud

Comparisons

No data available

Compared 13% of the time

AWS Glue vs Matillion Data Productivity Cloud

Compared 10% of the time

SSIS vs Matillion Data Productivity Cloud

Compared 8% of the time

Oracle Data Integrator (ODI) vs Matillion Data Productivity Cloud

Compared 6% of the time

SnapLogic vs Matillion Data Productivity Cloud

Compared 5% of the time

More Matillion Data Productivity Cloud 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 Data Productivity Cloud

Download Matillion Data Productivity Cloud product report

Matillion Data Productivity Cloud 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

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

Matillion Data Productivity Cloud features an intuitive graphical interface, seamless AWS integration, and efficient data management. Its tools streamline complex tasks for SFDC, RDS, Marketo, Facebook, and Google AdWords.

Matillion Data Productivity Cloud provides fast transformations with built-in verification, easy scheduling, and sampling. With automatic scalability and diverse data source support, it simplifies complex data tasks. Users benefit from cloud data warehousing and integrating data into Snowflake while appreciating its ease of use by non-technical teams. Enhancements can focus on frequent API adjustments, improved documentation, faster performance with less latency, and better error handling.

What are the key features of Matillion Data Productivity Cloud?

User-Friendly Interface: Simplifies interaction for non-technical users with a graphical interface.
Seamless Integration: Works smoothly with AWS, SFDC, RDS, Marketo, Facebook, and Google AdWords.
Automatic Scalability: Efficiently manages varying workloads with scale-up and down capabilities.
Efficient Data Handling: Streamlines transformations, scheduling, and sample data verifications.
Diverse Data Source Support: Easily integrates multiple data sources for streamlined processes.

What benefits and ROI should users seek in reviews?

Ease of Use: Reduces complexity for non-technical teams with intuitive operation.
Performance Efficiency: Fast data processing and transformations enhance productivity.
Cloud Compatibility: Supports integration with cloud platforms for versatile data solutions.
Time-Saving Scheduling: Automates data tasks, allowing users to focus on other priorities.
Scalability: Automatically adjusts to workload needs, optimizing resource use and cost.

In industries such as technology, finance, and healthcare, Matillion Data Productivity Cloud is implemented to streamline ETL processes, optimize data pipeline construction, and enhance data migration efforts. It supports efficient data loading and integration between cloud and on-premises databases, aiding industries in managing data-driven projects.

Matillion

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 Data Productivity Cloud