Matillion ETL vs erwin Data Catalog by Quest comparison

Cancel
You must select at least 2 products to compare!
erwin by Quest  Logo
268 views|211 comparisons
100% willing to recommend
Matillion Logo
3,247 views|2,215 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, Collibra and others in Metadata Management.
To learn more, read our detailed Metadata Management Report (Updated: May 2024).
772,649 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 →

"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good.""It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth""The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation.""We allow non-technical people to use Matillion to load data into our data warehouse for reporting. Thus, 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).""It's been able to do everything we require.""It has good integrations with Amazon Redshift and other AWS services.""The product has a good user interface.""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."

More Matillion ETL Pros →

Cons
"There is room for improvement with respect to the connector and how to connect to the structured and unstructured database.""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."

More erwin Data Catalog by Quest Cons →

"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.""In the next release, we would like to have connections to more databases.""Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more.""While the UI is good, it could be improved in its efficiency and made easier to use.""I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly.""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.""Matillion’s on-premises capabilities don’t allow you to build something customized."

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.
    772,649 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:The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.
    Top Answer:The pricing depends on what edition the customer opts for. For example, a standard edition and then business critical of different editions. Each of those has a different cost per unit, which is… more »
    Top Answer:One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems.
    Ranking
    12th
    out of 27 in Metadata Management
    Views
    268
    Comparisons
    211
    Reviews
    1
    Average Words per Review
    564
    Rating
    7.0
    4th
    Views
    3,247
    Comparisons
    2,215
    Reviews
    13
    Average Words per Review
    687
    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 Company13%
    Government11%
    Manufacturing Company7%
    REVIEWERS
    Manufacturing Company33%
    Financial Services Firm33%
    Healthcare Company8%
    Computer Software Company8%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Financial Services Firm14%
    Manufacturing Company9%
    Government8%
    Company Size
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise15%
    Large Enterprise72%
    REVIEWERS
    Small Business25%
    Midsize Enterprise33%
    Large Enterprise42%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    Buyer's Guide
    Metadata Management
    May 2024
    Find out what your peers are saying about Informatica, Alation, Collibra and others in Metadata Management. Updated: May 2024.
    772,649 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), WhereScape RED and Alation Data Catalog, whereas Matillion ETL is most compared with Snowflake, Azure Data Factory, AWS Glue, SSIS and Informatica PowerCenter.

    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.