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

Qlik Replicate vs SSIS comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

Review summaries and opinions

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

ROI

Sentiment score
8.0
Qlik Replicate automates reporting, saves time, reduces database usage, minimizes costs, and improves efficiency compared to AWS services.
Sentiment score
7.3
SSIS provides cost-effective data management efficiency, delivering ROI without extra costs apart from the SQL Server license.
I conducted a cost comparison with the AWS service provider, and this option is much cheaper than the Kinesis service offered by AWS.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
 

Customer Service

Sentiment score
5.7
Users find Qlik Replicate support slow and inefficient, preferring quicker resolutions and direct contact with representatives, especially for AutoML issues.
Sentiment score
6.0
Many users prefer online resources over Microsoft's good but occasionally slow and expensive technical support for critical issues.
Even priority tickets, which should be resolved in minutes, can take days.
 

Scalability Issues

Sentiment score
7.1
Qlik Replicate is scalable and adaptable, especially in cloud environments, but may require memory adjustments for optimal performance.
Sentiment score
6.8
SSIS is moderately scalable, better for batch processing, with varied performance depending on infrastructure and implementation challenges.
 

Stability Issues

Sentiment score
8.5
Qlik Replicate is highly stable and reliable, efficiently handling large volumes, with seamless recovery despite minor API concerns.
Sentiment score
7.4
SSIS is a reliable, mature tool with minor performance concerns, praised for stability in diverse projects despite occasional issues.
It processes large volumes of data quickly.
 

Room For Improvement

Qlik Replicate needs better UI, error clarity, support, integration, pricing transparency, performance, and marketing to compete effectively.
SSIS requires enhancements in error logging, real-time processing, and scalability while depending on external tools increases costs.
It is a core-based licensing, which, especially in the banking industry, results in the system capacity being utilized up to a maximum of 60%.
SSIS has a difficult learning curve when dealing with complex transformations.
 

Setup Cost

Qlik Replicate's pricing is high and less flexible than competitors, suiting larger companies with extensive replication needs.
SSIS is cost-effective for enterprises, bundled with SQL Server, but add-ons can increase costs; overall valued for integration.
Licensing is calculated based on the machine's total capacity rather than actual usage.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
 

Valuable Features

Qlik Replicate offers real-time data capture, easy replication, and seamless integration for efficient data management and real-time analytics.
SSIS offers user-friendly, cost-effective ETL solutions with C# scripting, cloud deployment, and extensive support, enhancing data integration and automation.
Data retrieved from the system can be pushed to multiple places, supporting various divisions such as marketing, loans, and others.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
 

Categories and Ranking

Qlik Replicate
Ranking in Data Integration
13th
Average Rating
8.2
Reviews Sentiment
6.9
Number of Reviews
17
Ranking in other categories
No ranking in other categories
SSIS
Ranking in Data Integration
4th
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
73
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of March 2025, in the Data Integration category, the mindshare of Qlik Replicate is 3.1%, up from 2.8% compared to the previous year. The mindshare of SSIS is 8.0%, up from 8.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

KrishnaBaddam - PeerSpot reviewer
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.
Sakiru Dosumu - PeerSpot reviewer
Its ability to transform and transport data is extremely valuable
he ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
842,466 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Computer Software Company
11%
Insurance Company
10%
Manufacturing Company
10%
Financial Services Firm
19%
Computer Software Company
12%
Government
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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?
There is complexity involved in the licensing part of this system. It is a core-based licensing, which, especially in the banking industry, results in the system capacity being utilized up to a max...
What is your primary use case for Qlik Replicate?
An example involving the banking project I am currently working on is for a public sector bank in India. Primarily, they are using a database, and the ultra architecture is meant to take a backup o...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
What is your experience regarding pricing and costs for SSIS?
Utilizing SSIS involves no extra charges beyond the SQL Server license. It's an economical choice for my clients.
 

Also Known As

Replicate, Qlik Replicate
SQL Server Integration Services
 

Overview

 

Sample Customers

American Cancer Society, Fanzz, SM Retail, Smart Modular, Tangerine Bank, Wellcare
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about Qlik Replicate vs. SSIS and other solutions. Updated: February 2025.
842,466 professionals have used our research since 2012.