Qlik Replicate vs SAP Replication Server vs SSIS comparison

Cancel
You must select at least 2 products to compare!
Qlik Logo
6,009 views|4,955 comparisons
100% willing to recommend
SAP Logo
929 views|834 comparisons
100% willing to recommend
Microsoft Logo
Read 69 SSIS reviews
19,105 views|15,500 comparisons
79% willing to recommend
Comparison Buyer's Guide
Executive Summary

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.
To learn more, read our detailed Data Integration Report (Updated: April 2024).
769,789 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"It's very user-friendly when it comes to settings and configuration. It also offers very detailed logging about warnings and errors.""We use Qlik Replicate to change data capture of databases in production environments.""Great with replicating and updating records.""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.""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.""The most useful functions of Qlik Replicate are the data manipulation to transformations.""The CDC and the flexibility to use QVD as a source are the most valuable features of Qlik Replicate.""A pretty good series of connectors is one of the best features of Qlik Replicate."

More Qlik Replicate Pros →

"We can customize any workflow and we also like the business domain modeling that can be done.""SAP Replication Server is an application that I consider to be a robust system. It has proven to be highly reliable in my experience.""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.""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."

More SAP Replication Server Pros →

"SSIS is easy to use.""It is easy to set up the product.""It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better.""The solution is stable.""The performance and stability are good.""The solution is easy to use and developer friendly.""The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work.""It is easy to set up. The deployment is also very quick."

More SSIS Pros →

Cons
"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.""In the next release, I would like to see closer integration with data catalyst.""We'd like better connectivity.""The UI and data version control can be improved.""Some features can also be overly dependent on each other. So, there is room for improvement.""The solution's flexibility to work with APIs should also be improved since it is very weak in working with APIs.""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."

More Qlik Replicate Cons →

"There is room for improvement in terms of pricing and faster support.""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.""I would like to see it become mobile-friendly.""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."

More SAP Replication Server Cons →

"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade.""I would like to see better integration with Power BI.""It hangs a lot of the time.""The high prices attached to the product can be an area of concern where improvements are required.""We'd like them to develop data exploration more.""SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it.""It's a legacy tool, that is nearing the end of its useful life.""There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."

More SSIS Cons →

Pricing and Cost Advice
  • "Qlik Replicate is not expensive, compared to GoldenGate."
  • "Pricing for this solution is very reasonable."
  • "Overall, Qlik is an expensive solution. You need to pay for all additional features that you would like to use."
  • "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."
  • "Unlike Azure, where you pay based on consumption, Qlik Replicate seems to charge per endpoint."
  • More Qlik Replicate Pricing and Cost Advice →

  • "It's a very expensive solution."
  • "You can pick one of the hosted cloud services as opposed to owning it and doing it yourself. Your cost of ownership on the hardware, the data storage, and the maintenance all go down. It depends on what service you use."
  • More SAP Replication Server Pricing and Cost Advice →

  • "This solution has provided an inexpensive tool, and it is easy to find experienced developers."
  • "My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
  • "This solution is included with the MSSQL server package."
  • "It would be beneficial if the solution had a less costly cloud offering."
  • "Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
  • "We have an enterprise license for this solution."
  • "It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
  • "All of my clients have this product included as part of their Microsoft license."
  • More SSIS Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
    769,789 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    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 There are many third-party vendors offering ETL solutions, but two of the most popular are PowerCenter Informatica and Microsoft SSIS (SQL Server Integration Services). Each technology has its advantages but there are also similarities on how they carry out the extract-transform-load processes and only differ in terminologies. If you’re in the process of choosing ETL tools and PowerCenter Informatica and Microsoft SSIS made it to your shortlist, here is a short comparative discussion detailing the differences between the two, as well as their benefits. Package Configuration Most enterprise data integration projects would require the capacity to develop a solution in one platform and test and deploy it in a separate environment without having to manually change the established workflow. In order to achieve this seamless movement between two environments, your ETL technology should allow the dynamic update of the project’s properties using the content or a parameter file or configuration. Both Informatica and SSIS support this functionality using different methodologies. In Informatica, every session can have more than one source and one or more destination connections. There are… Read more →
    Questions from the Community
    Top Answer:We use Qlik Replicate to change data capture of databases in production environments.
    Top Answer:Qlik Replicate is a little fuzzy sometimes as to how it's priced. It would be better if the solution’s pricing were more… more »
    Top Answer:Qlik Replicate is used when a company wants to make some sort of universal bus, a data chain where you have a continuous… more »
    Top Answer:SAP Replication Server is an application that I consider to be a robust system. It has proven to be highly reliable in… more »
    Top Answer:The reason why there has been a move toward cloud services and service as a software is because it's so much easier… more »
    Top Answer:The price could be cheaper. There is room for improvement in terms of pricing and faster support.
    Top Answer:SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called… more »
    Top Answer:The product's deployment phase is easy.
    Top Answer:If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to… more »
    Ranking
    16th
    out of 101 in Data Integration
    Views
    6,009
    Comparisons
    4,955
    Reviews
    6
    Average Words per Review
    362
    Rating
    8.2
    27th
    out of 101 in Data Integration
    Views
    929
    Comparisons
    834
    Reviews
    2
    Average Words per Review
    659
    Rating
    9.5
    2nd
    out of 101 in Data Integration
    Views
    19,105
    Comparisons
    15,500
    Reviews
    35
    Average Words per Review
    474
    Rating
    7.8
    Comparisons
    Also Known As
    Replicate, Qlik Replicate
    Sybase Replication Server
    SQL Server Integration Services
    Learn More
    Overview

    Qlik Replicate is a data replication solution for replicating data from one source database to another for business intelligence software. It offers data manipulation and transformations, replication without impacting source databases, and ease of use without needing ETL. The solution is stable and user-friendly, with detailed logging and support. 

    Qlik Replicate has improved the organization by allowing each team to replicate their data into a single-source data location. The most important feature of Qlik Replicate is its ability to replicate and update records without needing a programmer.

    Information and data-driven insight is what powers business today. But to get the most from your enterprise data, you need a way to bring transactional, streaming, social media, and other data together – regardless of its format and whether it’s structured or unstructured – and be able to analyze it. The challenge is moving, replicating, and centralizing a wide variety of data efficiently, cost-effectively, and quickly enough to meet business demands for active insight. SAP® Replication Server® can help. SAP Replication Server enables the continuous movement of mission-critical application data.

    SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

    Sample Customers
    American Cancer Society, Fanzz, SM Retail, Smart Modular, Tangerine Bank, Wellcare
    Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
    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
    Top Industries
    REVIEWERS
    Government29%
    Computer Software Company29%
    Manufacturing Company29%
    Financial Services Firm14%
    VISITORS READING REVIEWS
    Financial Services Firm18%
    Computer Software Company12%
    Manufacturing Company12%
    Insurance Company8%
    VISITORS READING REVIEWS
    Financial Services Firm15%
    Manufacturing Company14%
    Computer Software Company11%
    Healthcare Company7%
    REVIEWERS
    Financial Services Firm23%
    Healthcare Company8%
    Computer Software Company8%
    Manufacturing Company8%
    VISITORS READING REVIEWS
    Financial Services Firm18%
    Computer Software Company12%
    Government7%
    Healthcare Company6%
    Company Size
    REVIEWERS
    Small Business36%
    Large Enterprise64%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise10%
    Large Enterprise75%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise11%
    Large Enterprise72%
    REVIEWERS
    Small Business27%
    Midsize Enterprise17%
    Large Enterprise56%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    Buyer's Guide
    Data Integration
    April 2024
    Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration. Updated: April 2024.
    769,789 professionals have used our research since 2012.