We performed a comparison between Qlik Replicate and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The CDC and the flexibility to use QVD as a source are the most valuable features of 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 applications."
"It enables us to transform data at the latest stage rather than in ETL loads, so it's more ELT which is one of the advantages. It is also in near real-time, which brings significant advantage for our embedded analytics approach."
"Qlik Replicate stands out with its cutting-edge technology and its ability to handle diverse data management tasks. This powerful tool allows us to efficiently and swiftly load data into various data stores or destinations, while also enabling easy distribution across different endpoints. A notable feature is its capability to reload data from multiple sources by creating multiple tasks within a brief timeframe of fifteen to twenty minutes. This eliminates the need for manual intervention and ensures quick data loading from different tables."
"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."
"It's very user-friendly when it comes to settings and configuration. It also offers very detailed logging about warnings and errors."
"The most useful functions of Qlik Replicate are the data manipulation to transformations."
"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."
"The simplicity of the solution is great. The solution also offers excellent integration."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"SSIS' best feature is SFTP connectivity."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The most important features are it works well and provides self-service BI."
"The setup is straightforward. It's very easy to install."
"The UI and data version control can be improved."
"We would like to see more details in messages about errors with the system."
"In the next release, I would like to see closer integration with data catalyst."
"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."
"It's not possible to replicate the QVC files in data analytics."
"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."
"In various scenarios, an important consideration is when we encounter issues and Qlik Replicate suggests reloading a specific table. If we face any problems or encounter errors with that table, it becomes necessary to make a change in Qlik Replicate. Performing a full reload every time is not feasible or practical. Instead, we should identify the specific issues and address them without repeating the entire reloading process. Based on this approach, we can investigate and resolve the problem by performing targeted loads from the source itself. This change aligns with my perspective and is something I would like to implement."
"The solution's flexibility to work with APIs should also be improved since it is very weak in working with APIs."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"Future releases should improve the data lineage, as it currently is not good."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"Performance could be better."
"The solution could improve by having quicker release updates."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"It hangs a lot of the time."
Qlik Replicate is ranked 16th in Data Integration with 13 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Qlik Replicate is rated 8.2, while SSIS is rated 7.6. The top reviewer of Qlik Replicate writes " Performs well with batch-wise data applications but some features can also be overly dependent on each other". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Qlik Replicate is most compared with Oracle GoldenGate, AWS Database Migration Service, Qlik Compose, Azure Data Factory and Confluent, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and Oracle GoldenGate. See our Qlik Replicate vs. SSIS report.
See our list of best Data Integration vendors.
We monitor all 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.