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

Matillion ETL vs erwin Data Catalog by Quest comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

erwin Data Catalog by Quest
Average Rating
7.6
Number of Reviews
2
Ranking in other categories
Metadata Management (11th)
Matillion ETL
Average Rating
8.4
Number of Reviews
26
Ranking in other categories
Cloud Data Integration (5th)
 

Mindshare comparison

erwin Data Catalog by Quest and Matillion ETL aren’t in the same category and serve different purposes. erwin Data Catalog by Quest is designed for Metadata Management and holds a mindshare of 2.7%, down 3.3% compared to last year.
Matillion ETL, on the other hand, focuses on Cloud Data Integration, holds 4.4% mindshare, down 6.7% since last year.
Metadata Management
Cloud Data Integration
 

Featured Reviews

Andres-Martinez - PeerSpot reviewer
Mar 21, 2022
Helps with metadata management, saves time, and allows us to do impact analysis on any changes
There are always ways to improve things. For example, we can use AI to be able to find out something. When we are typing something, if we don't know the exact term, Artificial Intelligence would be useful to find terms that are phonetically or syntactically similar. Instead of having to type in the exact name, they can provide those in the list. So, they can provide AI support for the search because when you have thousands and thousands of terms, it is hard to remember all the names. There were some issues when drawing the data models. If you have more than 500 or 600 tables, it takes a long time to display those in the right position on the screen. That can also be improved. They need some caching and some parallel pipelines working on the backend in order to divide it into sections.
DB
May 23, 2024
Helps us monitor real-time data, but the scalability needs improvement
In a project where we migrated from on-prem solutions to the cloud, we used Matillion and Snowflake, which streamlined the process significantly Matillion ETL's ability to conduct end-to-end data migration is valuable. We can create jobs, monitor them, and manage workflows effectively. The…

Quotes from Members

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

Pros

"When you combine it with data lineage, every time you need to make a change, it allows you to do impact analysis on any changes and then connect to the end-users or data stewards so that they can be aware that a change is coming. That's one of the main benefits we use it for."
"The data catalog feature is pretty good."
"It is pretty user-friendly, even for people who aren't super technical."
"It has good integrations with Amazon Redshift and other AWS services."
"The product has a good user interface."
"It's been able to do everything we require."
"It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"
"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."
"Matillion ETL has great Git integration that is perfect and convenient to use."
"The solution's most valuable feature is the CDC (Change Data Capture) component."
 

Cons

"There are always ways to improve things. For example, we can use AI to be able to find out something. When we are typing something, if we don't know the exact term, Artificial Intelligence would be useful to find terms that are phonetically or syntactically similar. Instead of having to type in the exact name, they can provide those in the list. So, they can provide AI support for the search because when you have thousands and thousands of terms, it is hard to remember all the names."
"There is room for improvement with respect to the connector and how to connect to the structured and unstructured database."
"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."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"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 needs integration with more data sources."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems."
"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."
"Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level."
 

Pricing and Cost Advice

"I am not very familiar with its pricing. I know it is not cheap, but it is also not super expensive. It depends on the company size. For a company making $1 million, it is very expensive. For a company making 10 million and above, it might be okay."
"Erwin Data Catalog is very expensive."
"Matillion ETL is expensive."
"It was very easy to purchase through the AWS Marketplace, but it was also expensive."
"It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."
"The prices needs to be lower."
"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."
"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."
"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."
report
Use our free recommendation engine to learn which Metadata Management solutions are best for your needs.
805,335 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Computer Software Company
12%
Government
11%
Manufacturing Company
8%
Computer Software Company
16%
Financial Services Firm
15%
Manufacturing Company
9%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

Which ETL tool would you recommend to populate data from OLTP to OLAP?
There are two products I know about * TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for cu...
What is your experience regarding pricing and costs for erwin Data Catalog?
Erwin Data Catalog is very expensive. I would rate it a two out of five for affordability.
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.
 

Also Known As

No data available
Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
 

Overview

 

Sample Customers

Balfour Beatty Construction, Banco de México, BFSI Canada, CenturyLink, Daktronics
Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc
Find out what your peers are saying about Informatica, Alation, SAP and others in Metadata Management. Updated: September 2024.
805,335 professionals have used our research since 2012.