Matillion ETL vs Qlik Compose comparison

Cancel
You must select at least 2 products to compare!
Matillion Logo
3,495 views|2,369 comparisons
Qlik Logo
2,162 views|1,624 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Matillion ETL and Qlik Compose 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 Matillion ETL vs. Qlik Compose Report (Updated: March 2024).
765,386 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
"The loading of data is the most valuable feature of Matillion ETL.""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).""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 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.""Matillion ETL has great Git integration that is perfect and convenient to use.""It has improved the costs of managing my customer’s data.""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.""It's been able to do everything we require."

More Matillion ETL Pros →

"I have found it to be a very good, stable, and strong product.""Qlik Compose is good enough. It is user-friendly and intuitive.""One of the most valuable features of this tool is its automation capabilities, allowing us to design the warehouse in an automated manner. Additionally, we can generate Data Lifecycle Policies (DLP) reports and efficiently implement updates and best practices based on proven design patterns.""There were many valuable features, such as extracting any data to put in the cloud. For example, Qlik was able to gather data from SAP and extract SAP data from the platforms.""It is a scalable solution.""The technical support is very good. I rate the technical support a ten out of ten.""It's a stable solution.""It can scale."

More Qlik Compose Pros →

Cons
"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.""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.""It needs integration with more data sources.""I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly.""While the UI is good, it could be improved in its efficiency and made easier to use.""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.""I am looking forward to seeing the expansion of the source range for their data loader product."

More Matillion ETL Cons →

"When processing data from certain tables with a large volume of data, we encounter significant delays. For instance, when dealing with around one million records, it typically takes three to four hours. To address this, I aim to implement performance improvements across all tables, ensuring swift processing similar to those that are currently complete within seconds. The performance issue primarily arises when we analyze the inserts and updates from the source, subsequently dropping the table. While new insertions are handled promptly, updates are processed slowly, leading to performance issues. Despite consulting our Qlik vendors, they were unable to pinpoint the exact cause of this occurrence. Consequently, I am seeking ways to optimize performance within Qlik Compose, specifically concerning updates.""I'd like to have access to more developer training materials.""There could be more customization options.""For more complex work, we are not using Qlik Compose because it cannot handle very high volumes at the moment. It needs the same batching capabilities that other ETL tools have. We can't batch the data into small chunks when transforming large amounts of data. It tries to do everything in one shot and that's where it fails.""It would be better if the first level of technical support were a bit more technically knowledgeable to solve the problem. I think they could also improve the injection of custom scripts. It is pretty difficult to add additional scripts. If the modeling doesn't give you what you want, and you want to change the script generated by the modeling, it is a bit more challenging than in most other products. It is very good with standard form type systems, but if you get a more complicated data paradigm, it tends to struggle with transforming that into a model.""My issues with the solution's stability are owing to the fact that it has certain bugs causing issues in some functionalities that should be working.""There is some scope for improvement around the documentation, and a better UI would definitely help.""The solution has room for improvement in the ETL. They have an ETL, but when it comes to the monitoring portion, Qlik Compose doesn't provide a feature for monitoring."

More Qlik Compose Cons →

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 →

  • "On a scale of one to ten, where one is cheap, and ten is very expensive, I rate the solution a six."
  • "The price of the solution is expensive."
  • "While they outperform Tableau, there's room for improvement in Qlik's pricing structures, especially for corporate clients like us."
  • More Qlik Compose Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    765,386 professionals have used our research since 2012.
    Questions from the Community
    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 »
    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 most valuable is its excellence as a graphical data representation tool and the versatility it offers, especially with drill-down capabilities.
    Top Answer:While they outperform Tableau, there's room for improvement in Qlik's pricing structures, especially for corporate clients like us.
    Ranking
    4th
    Views
    3,495
    Comparisons
    2,369
    Reviews
    11
    Average Words per Review
    701
    Rating
    8.6
    18th
    out of 94 in Data Integration
    Views
    2,162
    Comparisons
    1,624
    Reviews
    10
    Average Words per Review
    460
    Rating
    7.7
    Comparisons
    Also Known As
    Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
    Compose, Attunity Compose
    Learn More
    Overview

    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.

    Qlik Sense is a powerful business intelligence tool that offers a range of features to help organizations make faster and more informed decisions. Its primary use cases include operational and financial dashboards, self-service reporting, and centralized access to cross-functional reports. The solution is praised for its mobile platform, ease of use, data-sharing capabilities, and extensibility. 

    Qlik Sense has helped organizations improve data literacy, reduce time consumed in complex reports, and provide widely available MI to senior stakeholders. It also enables self-service analytics, improves data quality and governance, enhances collaboration, and reduces costs.

    Sample Customers
    Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc
    Poly-Wood
    Top Industries
    REVIEWERS
    Manufacturing Company36%
    Financial Services Firm36%
    Healthcare Company9%
    Computer Software Company9%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Financial Services Firm14%
    Government8%
    Manufacturing Company8%
    VISITORS READING REVIEWS
    Financial Services Firm13%
    Manufacturing Company11%
    Computer Software Company11%
    Energy/Utilities Company6%
    Company Size
    REVIEWERS
    Small Business23%
    Midsize Enterprise36%
    Large Enterprise41%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise68%
    REVIEWERS
    Small Business36%
    Midsize Enterprise9%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise13%
    Large Enterprise70%
    Buyer's Guide
    Matillion ETL vs. Qlik Compose
    March 2024
    Find out what your peers are saying about Matillion ETL vs. Qlik Compose and other solutions. Updated: March 2024.
    765,386 professionals have used our research since 2012.

    Matillion ETL is ranked 4th in Cloud Data Integration with 22 reviews while Qlik Compose is ranked 18th in Data Integration with 12 reviews. Matillion ETL is rated 8.6, while Qlik Compose is rated 7.6. The top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". On the other hand, the top reviewer of Qlik Compose writes "Easy matching and reconciliation of data". Matillion ETL is most compared with Azure Data Factory, Snowflake, AWS Glue, Informatica PowerCenter and SSIS, whereas Qlik Compose is most compared with Qlik Replicate, Talend Open Studio, Azure Data Factory, SSIS and Palantir Foundry. See our Matillion ETL vs. Qlik Compose 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.