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."A pretty good series of connectors is one of the best features of Qlik Replicate."
"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."
"Great with replicating and updating records."
"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."
"We use Qlik Replicate to change data capture of databases in production environments."
"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."
"The most useful functions of Qlik Replicate are the data manipulation to transformations."
"From a technical perspective, this is an excellent product."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"The initial setup was easy."
"The 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."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The setup was easy. All Microsoft products are easy to set up."
"SSIS' best feature is SFTP connectivity."
"We'd like better connectivity."
"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 would be better if the solution’s pricing were more obvious."
"The UI and data version control can be improved."
"We would like to see more details in messages about errors with the system."
"Support-wise, this solution is in need of improvement."
"Support for this product is not great. It needs to be improved."
"The solution's flexibility to work with APIs should also be improved since it is very weak in working with APIs."
"The solution could improve by having quicker release updates."
"Video training would be a helpful addition."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"Future releases should improve the data lineage, as it currently is not good."
Qlik Replicate is ranked 17th in Data Integration with 12 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 "A highly stable solution that can be used to change data capture in legacy systems". 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.