Denodo vs Matillion ETL comparison

Cancel
You must select at least 2 products to compare!
Denodo Logo
1,577 views|1,005 comparisons
93% 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 Denodo and Matillion ETL based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Denodo vs. Matillion ETL Report (Updated: March 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
"Denodo is very stable.""It is a go-to tool for data virtualization. The virtualization and data catalog are the features of why we chose Denodo.""The best thing about Denodo is that creating and deploying a web service can be done in about 10 minutes, compared to a whole day when it comes to other solutions (such as when deploying with Java and AWS).""Data mining is one of the valuable features. We're able to connect all of the data sources with the installed driver, so that is a good advantage in Denodo. Being able to join the tables and view them is also valuable.""It can support a number of data sources, and it can pull flat files, from cloud-based databases or from those on-premises. Denodo can pull from any data source and interface with the view. Then, we can publish the view.""The ability to connect to a lot of different sources.""The most valuable features of Denodo are the extraction option for adapters, and there are many things for the views, that are cached. Denodo is not storing the data, it looks first to tune the query, and these things are for the agents.""The most valuable features are query optimization and the single language independence from the sources we're using to catch data."

More Denodo Pros →

"It is pretty user-friendly, even for people who aren't super technical.""Matillion ETL helps manage data movement, ingestion, and transformation through pipelines.""The product's initial setup phase was easy.""The most valuable feature of Matillion ETL is its ease of use. If you have had some experience with other solutions, such as Snowflake, the use of this solution will be simple.""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 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.""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 takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."

More Matillion ETL Pros →

Cons
"We occasionally have some integration issues that we need to work through.""It would be beneficial to make sure that the team that will be using Denodo has some kind of training on how to use the product at least a month beforehand, and there could even be some kind of feedback or Q&A sessions to go along with the training. If Denodo were able to provide this kind of training, it would be very helpful to users in insurance and banking companies because the staff are typically older and not always technically-minded.""The dropdown menus feel antiquated to me, and the administrative portals need improvement.""The solution is slow when there are many virtualization layers.""Lacks integrations with AWS, GCP and the like.""Monitoring event logs can be improved. In the older version, there was a monitoring schedule to get event reports and properly audit the reports. In the newer version, it is not there, and we have to manually configure data and audit events.""I would like to see a proper way to avoid killing the sourcing systems.""There have been some issues when you are at a table. Currently, Denodo exports data sets for a tabular model. When you are finished modeling your database or data warehouse they export a link to be used in Tableau. They should support other tools like Power BI."

More Denodo Cons →

"It needs integration with more data sources.""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.""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.""I am looking forward to seeing the expansion of the source range for their data loader product.""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.""The cost of the solution is high and could be reduced.""Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."

More Matillion ETL Cons →

Pricing and Cost Advice
  • "The licensing should be improved, as the cost per connector is quite expensive."
  • "I don't know the actual cost, but it's tens of thousands of dollars per month."
  • "The licensing charges for this solution are payable annually."
  • "The pricing is pretty good, and I would rate it at four out of five."
  • "Cost wise, on a scale from one to five, with one being the cheapest and five being the most expensive, Denodo would be at three. We get all the features in a bundle."
  • "Depending on the size of the client you want to work with, it can be prohibitively expensive at times."
  • "There is an express edition and a licensed enterprise edition."
  • "Talking with my manager and others, nobody has complained about the pricing so far which is a positive sign."
  • More Denodo 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 Cloud Data Integration solutions are best for your needs.
    768,578 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: If you are a Denodo user, it makes sense to undergo their training. Different types of professionals can benefit from it, including administrators, developers, and architects. If you are keen on it… more »
    Top Answer: I like Denodo a lot. It offers quick and easy web service deployment within minutes. There are not any flaws that I think make the product less good or effective. The only thing I can point out is… more »
    Top Answer:Denodo is suitable for pretty much all sectors that deal with Big data Cloud solutions Data governance Logical data fabric Master data management In my opinion, organizations in different fields… more »
    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
    8th
    Views
    1,577
    Comparisons
    1,005
    Reviews
    20
    Average Words per Review
    718
    Rating
    7.8
    4th
    Views
    3,350
    Comparisons
    2,263
    Reviews
    11
    Average Words per Review
    701
    Rating
    8.6
    Comparisons
    Azure Data Factory logo
    Compared 15% of the time.
    AWS Glue logo
    Compared 6% of the time.
    Delphix logo
    Compared 6% of the time.
    Mule Anypoint Platform logo
    Compared 6% of the time.
    Informatica PowerCenter logo
    Compared 5% of the time.
    Also Known As
    Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
    Learn More
    Overview

    Denodo is a leading data integration, management, and delivery platform that uses a logical approach to enable data science, hybrid and multi-cloud data integration, self-service BI, and enterprise data services. Organizations of different sizes across various industries utilize the product to get above the data silos. The solution offers organizations the freedom to migrate data to the cloud, or logically unify data warehouses and data lakes, without affecting business. This can ultimately result in the evolution of data strategies.

    The platform accelerates data provisioning through reduced data replication, provides business users the freedom to select their preferred applications, and enables consistent security and governance across multiple systems. The solution offers one of the leading logical data fabric solutions by initiating data virtualization and eliminating the complexity and exposing the data in business-friendly formats.

    Denodo also offers modern data integration and management for hybrid and multi-cloud environments for Denodo Platform for Cloud. This service can be purchased through the bring-your-own-license (BYOL) option. Users seeking faster deployment can license the product to popular cloud providers, including Amazon AWS, Google Cloud Platform, and Microsoft Azure. The solution integrates, manages, and delivers data in complex environments with high performance, governance, and security. It also offers additional solutions, such as the Denodo Platform for Cloud Modernization, the Denodo Platform for Cloud Data Integration, and the Denodo Platform for Cloud Analytics, which overcome common cloud data challenges.

    Denodo Features

    At the beginning of 2022, version 8.0 of Denodo introduced several new key features of the platform. These include:

    • Scalability: Denodo can scale from departmental or project to enterprise-wide with geographically distributed nodes. It can also handle large transactional loads of users, sources, and transactions as well as analytical loads of data volumes.

    • Query optimizers: This feature offers advanced cost-based and source constraint-based query optimization that includes query rewrite, query delegations, data movements, and join optimization.

    • Intelligent caching: This feature makes full, portal, and time-based caching possible.

    • Fine-grained security model: This Denodo feature makes integration with external systems possible.

    • Monitoring and auditing: Denodo offers enterprise-grade monitoring and auditing, which allows for integration with system management products, including Tivoli, Unicenter, and HP BTO.

    • Development and deployment support: The product offers full lifecycle support for the development and deployment of applications, providing users with all required tools.

    Denodo Benefits

    Denodo offers various benefits for its users through its services. Some of the greatest advantages of using this platform include:

    • The solution accelerates time to market for all types of business data through its services.

    • Denodo provides IT agility, which helps companies respond to business-changing demands in a timely manner.

    • Users can decide how much data replication they want to reduce through Denodo and use the product in full control.

    • The solution meets the industry's security and privacy requirements by providing high-grade protection for users' data.

    • Users can benefit from centralized control of data query executions for complete governance and full security.

    • Denodo offers legacy replacement, multi-cloud deployments, and cloud migrations with minimal disruptions and a fair price.

    • The solution utilizes artificial intelligence (AI) and machine learning (ML) to unlock data potential for customers.

    Reviews from Real Users

    Naresh M., a senior application developer at a financial services firm, appreciates Denodo because it offers quick and simple web services creation.

    Alisson M., a senior BigData DevOps engineer at Schaeffler, says that Denodo is great for queries and scouting data.

    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
    Autodesk, VHA, AAA, Sumitomo Mitsui Trust Bank, Caterpillar, European Chemical Agency, Seagate, Nationwide, Time Warner Cable, Pantex, Inditex, BNSF Railways, Vodafone, CIT Group, Jazztel, Wolters Kluwer, Telefonica, TransAlta
    Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc
    Top Industries
    REVIEWERS
    Financial Services Firm25%
    Manufacturing Company19%
    Computer Software Company13%
    Government6%
    VISITORS READING REVIEWS
    Financial Services Firm19%
    Manufacturing Company9%
    Computer Software Company9%
    Energy/Utilities Company8%
    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
    REVIEWERS
    Small Business33%
    Midsize Enterprise13%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise9%
    Large Enterprise77%
    REVIEWERS
    Small Business22%
    Midsize Enterprise35%
    Large Enterprise43%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise13%
    Large Enterprise68%
    Buyer's Guide
    Denodo vs. Matillion ETL
    March 2024
    Find out what your peers are saying about Denodo vs. Matillion ETL and other solutions. Updated: March 2024.
    768,578 professionals have used our research since 2012.

    Denodo is ranked 8th in Cloud Data Integration with 29 reviews while Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews. Denodo is rated 7.8, while Matillion ETL is rated 8.6. The top reviewer of Denodo writes "Saves our underwriters' time with data virtualization, but could provide more learning resources". On the other hand, the top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". Denodo is most compared with Azure Data Factory, AWS Glue, Delphix, Mule Anypoint Platform and Informatica PowerCenter, whereas Matillion ETL is most compared with Snowflake, Azure Data Factory, AWS Glue, Informatica PowerCenter and SSIS. See our Denodo vs. Matillion ETL report.

    See our list of best Cloud Data Integration vendors.

    We monitor all Cloud Data Integration 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.