We performed a comparison between Qlik Replicate, SAP Replication Server, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The CDC and the flexibility to use QVD as a source are the most valuable features of Qlik Replicate."
"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."
"Great with replicating and updating records."
"A pretty good series of connectors is one of the best features of Qlik Replicate."
"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."
"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."
"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."
"From a technical perspective, this is an excellent product."
"SAP Replication Server is an application that I consider to be a robust system. It has proven to be highly reliable in my experience."
"We can customize any workflow and we also like the business domain modeling that can be done."
"It speeds up the performance in terms of how fast you are able to access the data, look at it, get it reported to you, and send it to somebody. It also reduces the amount of storage."
"It's pretty good at handling replication, even under high load. It also provides cross-database replication, for example, from Sybase to Oracle."
"SAP is renovating different things. We are using external tools to connect as of now. It is going well, and now the new generation integration platforms are going to be pretty easy."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"We can connect with multiple data sources easily using an external connector in SSIS."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The solution's flexibility to work with APIs should also be improved since it is very weak in working with APIs."
"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."
"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."
"We'd like better connectivity."
"Support for this product is not great. It needs to 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 private solution is expensive. If you're in a situation where you're paying IBM or AWS or somebody just to host you specifically, you're paying people to run it and you're taking care of all the upgrades."
"If someone wants to replicate their data from Sybase to a newer technology for data warehousing or other purposes, it would be better if they supported those."
"Improvement is a never ending story, and HANA is doing some improvements. We are able to adopt that, and we have to do it by integration with HANA. They are very major changes that we need to see."
"There is room for improvement in terms of pricing and faster support."
"I would like to see it become mobile-friendly."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"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."
"Tuning using this solution requires extensive expertise to improve performance."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"Performance could be better."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."