Matillion ETL vs erwin Data Catalog by Quest comparison

Cancel
You must select at least 2 products to compare!
erwin by Quest  Logo
262 views|207 comparisons
100% willing to recommend
Matillion Logo
3,350 views|2,263 comparisons
95% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between erwin Data Catalog by Quest and Matillion ETL based on real PeerSpot user reviews.

Find out what your peers are saying about Informatica, Alation, SAP and others in Metadata Management.
To learn more, read our detailed Metadata Management Report (Updated: April 2024).
768,578 professionals have used our research since 2012.
Featured Review
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."

More erwin Data Catalog by Quest Pros →

"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines.""Matillion ETL has great Git integration that is perfect and convenient to use.""The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.""It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies.""It is pretty user-friendly, even for people who aren't super technical.""It's been able to do everything we require.""The product's initial setup phase was easy.""It has helped us to get onto the cloud quickly."

More Matillion ETL Pros →

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

More erwin Data Catalog by Quest Cons →

"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion.""While the UI is good, it could be improved in its efficiency and made easier to use.""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.""To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful.""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.""It needs integration with more data sources.""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."

More Matillion ETL Cons →

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."
  • More erwin Data Catalog by Quest Pricing and Cost Advice →

  • "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 cost-effective. Based on our use case, it's efficient and cheap. It saves a lot of money and our upfront costs are less."
  • "The prices needs to be lower."
  • "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."
  • "It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."
  • "The AWS pricing and licensing are a cost-effective solution for data integration needs."
  • "It was procured through the AWS Marketplace because it keeps things simple. They offer retail-like checkout and bill through your existing Amazon Web Services account."
  • More Matillion ETL Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Metadata Management solutions are best for your needs.
    768,578 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: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 cubes… more »
    Top Answer:The data catalog feature is pretty good.
    Top Answer:Erwin Data Catalog is very expensive. I would rate it a two out of five for affordability.
    Top Answer:It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth
    Top Answer:We pay $5.40 per EC2 running hour, and we can reduce costs by stopping and starting the EC2 instances strategically. For instance, in our production environment, we run it for sixteen hours a day… more »
    Top Answer:There's room for improvement in how it handles data streaming capabilities. Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes… more »
    Ranking
    12th
    out of 27 in Metadata Management
    Views
    262
    Comparisons
    207
    Reviews
    1
    Average Words per Review
    564
    Rating
    7.0
    4th
    Views
    3,350
    Comparisons
    2,263
    Reviews
    11
    Average Words per Review
    701
    Rating
    8.6
    Comparisons
    Also Known As
    Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
    Learn More
    Overview

    erwin Data Catalog (DC), part of the erwin Data Intelligence Suite, automates enterprise metadata management, including data mapping, code generation, data profiling, data lineage and impact analysis. It integrates and activates data in a single, unified catalog in accordance with business requirements by scheduling ongoing scans of metadata from the widest array of data sources, keeping metadata current with full versioning and change management, and easily mapping data elements from source to target, including data at rest and in motion, and harmonize data integration across platforms.

    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
    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
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm19%
    Computer Software Company14%
    Government11%
    Manufacturing Company7%
    REVIEWERS
    Manufacturing Company33%
    Financial Services Firm33%
    Healthcare Company8%
    Computer Software Company8%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Financial Services Firm14%
    Government8%
    Manufacturing Company8%
    Company Size
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise15%
    Large Enterprise71%
    REVIEWERS
    Small Business22%
    Midsize Enterprise35%
    Large Enterprise43%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise13%
    Large Enterprise68%
    Buyer's Guide
    Metadata Management
    April 2024
    Find out what your peers are saying about Informatica, Alation, SAP and others in Metadata Management. Updated: April 2024.
    768,578 professionals have used our research since 2012.

    erwin Data Catalog by Quest is ranked 12th in Metadata Management with 2 reviews while Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews. erwin Data Catalog by Quest is rated 7.6, while Matillion ETL is rated 8.6. The top reviewer of erwin Data Catalog by Quest writes "Helps with metadata management, saves time, and allows us to do impact analysis on any changes". On the other hand, the top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". erwin Data Catalog by Quest is most compared with Informatica Enterprise Data Catalog, Talend Open Studio, Oracle Data Integrator (ODI), Alation Data Catalog and WhereScape RED, whereas Matillion ETL is most compared with Snowflake, Azure Data Factory, AWS Glue, Informatica PowerCenter and SSIS.

    We monitor all Metadata Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.