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

Matillion ETL vs Qlik Replicate comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Matillion ETL
Average Rating
8.4
Number of Reviews
26
Ranking in other categories
Cloud Data Integration (5th)
Qlik Replicate
Average Rating
8.2
Number of Reviews
15
Ranking in other categories
Data Integration (16th)
 

Featured Reviews

AntonHaupt - PeerSpot reviewer
Jan 23, 2024
Efficient data integration and transformation with seamless cloud-native integration
In our small business unit, we currently have around four users, with two of them utilizing Matillion within our organization. Considering our growing needs, we're contemplating transitioning to an enterprise SaaS solution where we would share the same instance. Currently, each user is billed individually, but consolidating to a shared instance seems more efficient. Scalability is excellent when using the SaaS solution, easily reaching a rating of ten out of ten. Each data pipeline request is encapsulated within a Docker container and spun off, allowing for instant scalability. Overall, I would rate it a nine out of ten in terms of performance and scalability.
KrishnaBaddam - PeerSpot reviewer
Aug 28, 2024
Lightweight tool, ensures that data is replicated across different systems and simplify complex tasks such as defining relationships
Qlik Compose is something that will automate user's overall data modernization. Here data modernization includes data modeling, ETL jobs, etc. But the advantage is users can automate the overall process of data engineering and data modeling through Qlik Compose. I think that's useful when users are able to manage 60% of the workload automated. That will be very useful. That's fantastic. Replicate does not have a great AI capability. AI capabilities are present in Qlik Sense. Qlik Replicate is a very light tool. It is only meant to capture data from the log files, get the data, and transfer it, read that table structure, create the table structure, and transfer the data whenever there is a change. So, it basically integrates with the kernel of the operating system. The way it works is that these replicate tools will integrate with the kernel of the operating system, and they will access the redo log files of the database. The redo log should have access to all the files of the structure of the schema, too. So, using that technique, they redo all the data structures, create a similar structure, and replicate the structure in the target schema, table, and database. After that is done, it will start tracing the instances that are happening. For example, if data is inserted into the table, then an insert is fired on the statement on the table. So, that particular insert is captured. And based on that insert statement, it will pull the SQL query and say, "Okay, there is an insert. I need to get that data." It will get the data from the redo log itself rather than going to a database. Then, it will just pass that transaction into the target system, where it will just insert the data. And this happens instantaneously, within a microsecond. So, if there is an insert, an update, or a delete, everything is transferred immediately. It is picked from the redo log because it comes to the redo log, and then the redo log sends it to Qlik Replicate and Replicate to the target system on which Replicate is installed.

Quotes from Members

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

Pros

"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)."
"Matillion ETL has great Git integration that is perfect and convenient to use."
"It has improved the costs of managing my customer’s data."
"It has helped us to get onto the cloud quickly."
"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"The loading of data is the most valuable feature of Matillion ETL."
"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."
"It's very user-friendly when it comes to settings and configuration. It also offers very detailed logging about warnings and errors."
"The main valuable feature is its real-time change data capture (CDC) capabilities, which process data with minimal latency. There is not much delay. It also performs well with batch-wise data applications."
"A pretty good series of connectors is one of the best features of Qlik Replicate."
"The most useful functions of Qlik Replicate are the data manipulation to transformations."
"We use Qlik Replicate to change data capture of databases in production environments."
"It is only meant to capture data from the log files, get the data, and transfer it, read that table structure, create the table structure, and transfer the data whenever there is a change."
"A valuable feature of Qlik Replicate is that you do not need ETL. It's easy to use—you choose two systems and it automatically replicates them. Even if there is no CDC available, if you insert it and update it, and there is nothing to find out, then you can use Qlik Replicate. It's a good product."
"Low-priced reporting and analytics solution, with good scalability and stability. It has on-premises and cloud versions that are cohesive and can integrate well."
 

Cons

"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"The product must enhance its near-real-time data capture feature."
"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."
"Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."
"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems."
"The tool's lineage is very weak."
"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."
"We'd like better connectivity."
"The UI and data version control can be improved."
"It's not possible to replicate the QVC files in data analytics."
"When you remote into it the Qlik Replicate UI a lot of times it just freezes. We set up the EC2, to allow them to go to the server and click on the Replicate icon, it just opens up and just sits there. At that point, we have to go into the EC2 and then reboot the server. This should be fixed, it is frustrating."
"This product could be improved by providing more insight regarding errors. One of our customers that uses Qlik Replicate has had an issue. We tried to debug it, but we could not trace the error message. The infrastructure site should give us more insight about errors. Qlik Replicate is not a business solution, it's an IT solution. The reporting tools and bug site should be improved."
"The solution's flexibility to work with APIs should also be improved since it is very weak in working with APIs."
"The disadvantage is people are not going for this license because it is not marketed properly."
"The product should improve its licensing limitation."
 

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."
"The absence of licensing commitments makes it easy to experiment with the tool, and if we decide it's not suitable, we can simply stop the ETL instance and cease incurring charges."
"I think it is cost conscious. It used to be very cheap and they have more recently bumped up the pricing, so it is competitive now."
"The AWS pricing and licensing are a cost-effective solution for data integration needs."
"Its price depends on what you expect. You pay on a monthly basis, but there is a possibility to have special contracts depending on the installation."
"The prices needs to be lower."
"It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."
"Matillion ETL is expensive."
"Pricing for this solution is very reasonable."
"Unlike Azure, where you pay based on consumption, Qlik Replicate seems to charge per endpoint."
"Qlik Replicate is mainly suited for large companies. However, it is too costly for small businesses. Its pricing is high."
"Qlik Replicate is not expensive, compared to GoldenGate."
"On a scale from one to ten, where one is cheap, and ten is expensive, I rate Qlik Replicate's pricing a nine out of ten."
"Overall, Qlik is an expensive solution. You need to pay for all additional features that you would like to use."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
16%
Computer Software Company
15%
Manufacturing Company
9%
Government
6%
Financial Services Firm
19%
Computer Software Company
13%
Manufacturing Company
12%
Insurance Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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.
What do you like most about Qlik Replicate?
The main valuable feature is its real-time change data capture (CDC) capabilities, which process data with minimal latency. There is not much delay. It also performs well with batch-wise data appli...
What needs improvement with Qlik Replicate?
The disadvantage is, I think, people are not going for this license because it is not marketed properly. Qlik was not promoting it because Talend was acquired at the same time. So Talend has become...
What is your primary use case for Qlik Replicate?
Qlik Compose is basically an integration tool, which has been acquired by Qlik from an Israeli IT company. So that Qlik can become leaders or can jump into the integration space. So, there are two ...
 

Also Known As

Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
Replicate, Qlik Replicate
 

Learn More

 

Overview

 

Sample Customers

Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc
American Cancer Society, Fanzz, SM Retail, Smart Modular, Tangerine Bank, Wellcare
Find out what your peers are saying about Matillion ETL vs. Qlik Replicate and other solutions. Updated: October 2024.
814,649 professionals have used our research since 2012.