BMC AMI DevX vs Matillion Data Productivity Cloud comparison

BMC AMI DevX vs. Matillion Data Productivity Cloud

Download the complete report

Helped 885,376 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 AMI DevX

Average Rating

8.0

Reviews Sentiment

7.2

Number of Reviews

Ranking in other categories

Software Configuration Management (1st), Debugging (9th), Database Development and Management (19th), Mainframe Application Development (1st), Test Data Management (6th), Mainframe Testing Tools (1st), Data Masking (6th), AI Software Development (200th)

Matillion Data Productivity...

Average Rating

8.4

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

Cloud Data Integration (10th), AI Data Analysis (14th)

Featured Reviews

Patricio-Martinez

Developer at Selfemployed

Good for large amounts of data and has a variety of use cases but can be complex to use

It's a very complicated tool. Sometimes the customer wants better, faster transaction times. They want the solution to move as fast as possible. We're trying to scale and grow our application with more servers to get the level of speed desired. Everything from small processes to big batch processing needs to be faster.

Read full review

Jitendra Jena

Director Axtria - Ingenious Insights! at Axtria - Ingenious Insights

Easy integration and workflow proposals streamline processes

The predefined connectors eliminate the need to write code for connectivity. If you have a predefined connector, it is easy to use with plug and play functionality. The processing time and ease of use are significant benefits. As everyone is moving into AI integration, it will definitely help. When creating workflows, they can propose solutions directly.

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 like that Compuware File-AID can actually map out control sections within load modules, or, as they're now known, program objects."

"One of the features that the developers like is that they can retrieve what they need with the tool. They don't have to go through some process or request something be done by another team. They can get the programs they need, compile them, retrieve the JCL and alter the JCL if they need to, and put these programs wherever they need to go for their testing."

"Test data management capabilities are good."

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

"From a user perspective, the GUIs make it easier for people to see and interact with files on the mainframe."

"We have seen an improvement in the rate and level of quality at which we deploy changes."

"For bank applications, DB2 is the best on the market."

"I like the ability to flow through the source and see what happens to the data as the statements are executed. If there is a fault, it will track the event, and we can then look back to see why it may have caused the fault. You can also reverse engineer your test. You can set it so that you can go backward as well as forward in your test. This is something that I haven't done here at my company. Compuware Xpediter is one of the best debugging tools for mainframe software development. We have currently licensed only the COBOL language for Xpediter, but I know they have other languages, including Assembler, PL/I."

More BMC AMI DevX pros

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

"Give it a shot. See how easy it is to get started with the product, because the scripting which is required is minimal."

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

"It has helped us to get onto the cloud quickly."

"We allow non-technical people to use Matillion to load data into our data warehouse for reporting, so it is easy enough to use that we don't always have to get a technical person involved in setting up a data movement (ETL)."

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

"The product's initial setup phase was easy."

"Compared to the likes of traditional ETLs, like Informatica, SnapLogic, and Talend, or even raw Python scripts, this product needs no improvement, as it is so much better."

More Matillion Data Productivity Cloud pros

Cons

"The solution could be improved by being better integrated with the open world. In the next release, I would like to have the ability to work in an open environment whilst remaining integrated with the legacy environment."

"Technical support has gotten better over the years, though there's always room for improvement."

"When you're setting up the parameters for how ISPW will work in your shop, there are a lot of questions that have to be answered... BMC Compuware should have more in-depth explanations about what the choices in each question mean. If you pick A, what does that mean has to happen? What does that impact? If you pick B, what does that mean? What does that impact?"

"I'm always looking for improvement in things like the documentation, to make things a little bit easier and simpler to understand, a place where people can go to troubleshoot issues."

"DB2 is a hard tool to grasp. It's hard for users to learn how to use it."

"I'm waiting to see what 19.2 for Topaz looks like, but I have a problem with the JES Explorer right now. It limits you to a certain prefix for job names and there are some groups that have multiple prefixes that they'd like to see all at once in their job names, because of how they work in a group. And they can't see that in the JES Explorer."

"It often doesn't play well with other plugins in the environment."

"It would be good if the vendors would work together or at least have some collaboration between them, so they would know what would work and what wouldn't work. Right now, the way things are working, they're relying on the customer to make everything work."

More BMC AMI DevX cons

"It needs integration with more data sources."

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

"Performance can be improved for efficiency, and it can be made faster."

"It would be great to have the ability to move windows around to dock in different locations or external windows."

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

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

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

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

More Matillion Data Productivity Cloud cons

Pricing and Cost Advice

"It has saved our developers time and effort when working on documentation, which is now more readable and fluent."

"In terms of pricing, there isn't an extra charge for the parts of it we use. It comes with the licenses we purchased for other products, so no complaints there. The licensing is built in with the other products that you purchase from Compuware."

"The price point is great."

"The only thing I would mention related to the licensing and/or the pricing, is that they have some visualization features in there that are licensed by concurrent users. We're starting to trip up on that. We're looking to probably increase the number of concurrent licenses that we have. But those types of licensing strategies, where they license by concurrent users or the number of seats is confusing for some people. They don't understand why it works sometimes and doesn't work other times."

"In general, Compuware tools are very competitive."

"I like the seat-based licensing much more than MSU-based licensing, and that the cost has been competitive."

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

"The prices needs to be lower."

"The product must improve its pricing."

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

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

"The absence of licensing commitments makes it easy to experiment with the tool, and if we decide it's not suitable, we can simply stop the ETL instance and cease incurring charges."

"The price of Matillion ETL is reasonable."

"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

885,376 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

32%

Insurance Company

10%

Manufacturing Company

Computer Software Company

Financial Services Firm

11%

Manufacturing Company

10%

Computer Software Company

10%

Marketing Services Firm

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	6
Large Enterprise	16

By reviewers
Company Size	Count
Small Business	6
Midsize Enterprise	10
Large Enterprise	11

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 pricing is managed by the tooling team. The pricing is moderate, neither expensive nor cheap.

What needs improvement with Matillion ETL?

The main areas for improvement are AI features and scalability.

IBM File Manager vs BMC AMI DevX

Comparisons

Endevor vs BMC AMI DevX

Compared 12% of the time

Compared 8% of the time

InterTest vs BMC AMI DevX

Compared 6% of the time

Broadcom Test Data Manager vs BMC AMI DevX

Compared 5% of the time

IBM Debug for z/OS vs BMC AMI DevX

Compared 4% of the time

More BMC AMI DevX Competitors

Denodo vs Matillion Data Productivity Cloud

Compared 10% of the time

MuleSoft Anypoint Platform vs Matillion Data Productivity Cloud

Compared 9% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs Matillion Data Productivity Cloud

Compared 5% of the time

Skyvia vs Matillion Data Productivity Cloud

Compared 4% of the time

Fivetran vs Matillion Data Productivity Cloud

Compared 4% of the time

More Matillion Data Productivity Cloud Competitors

Product Reports

BMC AMI DevX

Download BMC AMI DevX product report

Matillion Data Productivity Cloud

Download Matillion Data Productivity Cloud product report

Matillion Data Productivity Cloud report

Also Known As

File-AID, Data for Db2, Code Debug, Data Studio, Workbench for Eclipse, Code Pipeline

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

Overview

BMC AMI DevX is a comprehensive solution enhancing code management and testing efficiency. It offers debugging capabilities within financial applications and integrates data management seamlessly, serving major banking sectors with reliable performance.

AMI DevX is tailored for banking industries, optimizing application debugging in COBOL and enhancing data handling in robust financial systems. It simplifies mainframe data management with real-time insights, improving efficiency through editing and cloning functionalities. The tool's integration with Compuware File-AID for IMS and DB2 ensures streamlined development processes. Challenges include a steep DB2 learning curve and initial setup complexities, with technical support inconsistencies and steep pricing impacting affordability. Despite this, its valuable features significantly support large banking operations.

What features make BMC AMI DevX valuable?

Line-by-Line Code Debugging: Allows precise identification and rectification of issues.
Variable Change & Line Skipping: Flexibility in testing without recompiling.
Database-Independent Testing: No need for loading databases during testing.
Real-Time Data Insights: Enhances decision-making with immediate information.
Data Warehousing & Analytics: Facilitates comprehensive data analysis.
Integration & Formatting: Streamlines development by simplifying data processes.

What benefits should users look for in reviews?

Improved Efficiency: Streamline data management and editing capabilities.
Robust Debugging: Effective in both online and batch COBOL program debugging.
Enhanced Financial Application Support: Superior handling in grants and loans applications.
Comprehensive Testing: Enables creation of clone test files for thorough testing.

In large banking sectors, BMC AMI DevX is integral for grants and loans-related applications. Its robust nature supports financial systems, offering debugging for COBOL, updating data in Compuware File-AID for IMS, and integrating DB2. Users implement this for exceptional data management and application reliability.

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

Helvetia, The IMT Group, Hapag-Lloyd, Royal Bank of Canada, Chunghwa Telecom

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

BMC AMI DevX vs. Matillion Data Productivity Cloud