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

Quest SharePlex 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:
 

Categories and Ranking

Quest SharePlex
Ranking in Data Integration
48th
Average Rating
9.0
Reviews Sentiment
7.3
Number of Reviews
5
Ranking in other categories
No ranking in other categories
SSIS
Ranking in Data Integration
3rd
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
74
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of June 2025, in the Data Integration category, the mindshare of Quest SharePlex is 0.7%, up from 0.7% compared to the previous year. The mindshare of SSIS is 7.7%, down from 7.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

KW
It reduces the downtime and migration time exponentially
I would rate SharePlex's high availability, and disaster recovery features highly. It works as advertised in terms of rapid fill-over and switch-over opportunities. It reduces the migration time for a multi-terabyte database to an hour or less because it performs real-time replication. SharePlex reduces downtime and migration time exponentially. Something that could take 12 to 24 hours is cut down to one to two hours. By the time you start to migrate, the only remaining replication is a slight difference in data from the point when SharePlex has shut down, and the application has to also switch over to the new database. It allowed the company to replicate data more transparently. Some of the business executives probably don't even know it's there. It works 100 percent of the time, with little downtime or problems. It provides what is needed. There's little concern about whether or not it functions. It's allowed the company to achieve its objectives with its clients, reducing and minimizing downtime for substantial migrations and upgrades. It can reduce hardware and storage costs, but my company doesn't utilize it with high-availability architecture.
Sean Achim - PeerSpot reviewer
Building impactful organizational KPIs with ease and precision
Stability is rated at 10. One other important aspect I appreciate is that SSAS is included in the base installation of SQL Server. Obviously, it requires installation, but it is readily available, which is a major strength. It's all about setting it up, configuring it, and then using it. If there are additional costs associated with it or separating it as a second product, that would be a disadvantage. The area of improvement is really in education. Microsoft is trying to push everything as a Power BI solution or trying to get people to solve the problems which are solved with SSAS in another space in Power BI, or in Power Pivot, is not enough. There's not enough marketing, conversation, and support around that space. As a result, we end up with people not understanding that you need to build your models correctly, and then they try to model everything inside of Power BI, or another visualization tool, without first building the data model. That leads people to consider alternate solutions because SAP and others argue that their whole thing is in memory, and they disseminate misleading information. Additionally, what would be very helpful is local user group developments, so getting people around the table and teaching them how to use it. That is the biggest problem; it's not the technology itself. The challenge lies in Microsoft withdrawing a lot of the qualifications and watering down its emphasis, leading to a perception that this is supposed to be an elite product.

Quotes from Members

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

Pros

"There are some capabilities within SharePlex where you can see how the data is migrating and if it still maintains good data integrity. For example, if there are some tables that get out of sync, there are ways to find them and fix the problem on the spot. Since these are very common issues, we can easily fix these types of problems using utilities, like compare and repair. So, if you find something is out of sync, then you can just repair that table. It basically syncs that table from source to target to see if there are any differences. It will then replicate those differences to the target."
"The core replication and its performance. Performance is crucial, and SharePlex is by far the fastest. The way it handles replication to multiple targets along with basic filtering, as well as from multiple sources to a single target, is very efficient."
"I like SharePlex's Compare and Repair tool."
"Because of the volume of the transactions, we heavily use a feature that allows SharePlex to replicate thousands of transactions. It's called PEP, Post Enhancement Performance, and that has helped us scale tremendously."
"The core features of the solution we like are the reliability of the data transfer and the accuracy of data read and write. The stability of the solution is also excellent."
"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 initial setup of this solution is very straightforward."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."
"Overall, it's a good product."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"It's saved time using visualization descriptions."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
 

Cons

"I would like the solution to have some kind of machine learning and AI capabilities. Often, if we want to improve the performance of posting, we have to bump up a parameter. That means we need to stop the process, come up with a figure that we want to bump the parameter up to, and then start SharePlex. Machine learning and AI capabilities for these kinds of improvement would tremendously help boost productivity for us."
"For its function in relation to replication (i.e. filtering), I'd give it a six or seven out of 10. GoldenGate has much more functionality by comparison."
"The reporting features need improvement. It would be very good for users to have a clear understanding of the status of replication."
"I don't know how easy it would be to change the architecture in an already implemented replication. For example, if we have a certain way of architecting for a particular database migration and want to change that during a period of time, is that an easy or difficult change? There was a need for us to change the architecture in-between the migration, but we didn't do it. We thought, "This is possibly complicated. Let's not change it in the middle because we were approaching our cutover date." That was one thing that we should have checked with support about for training."
"I would like more ability to automate installation and configuration in line with some of the DevOps processes that are more mature in the market. That would be a considerable improvement."
"It needs more integration tools, so you can connect to different sources."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"I would like to see better technical documentation because many times information is missing."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"I would like to see more features in terms of the integration with Azure Data Factory."
"It would be nice if you could run SSIS on other environments besides Windows."
"Future releases should improve the data lineage, as it currently is not good."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
 

Pricing and Cost Advice

"It is not as expensive as Oracle GoldenGate and has worked really well within our budgets."
"It's really good value for the money. There are some things they could improve on, but in terms of the pricing, features, and support, as a holistic package, we are not thinking of anything else at this point in time."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
"All of my clients have this product included as part of their Microsoft license."
"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."
"People have to opt for a perpetual-based licensing model."
"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."
"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."
"SSIS is fairly well-priced - I would rate it at four out of five."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
856,873 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%
Real Estate/Law Firm
6%
Healthcare Company
6%
Financial Services Firm
19%
Computer Software Company
12%
Government
8%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

Ask a question
Earn 20 points
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.
 

Comparisons

 

Also Known As

Dell SharePlex, SharePlex
SQL Server Integration Services
 

Overview

 

Sample Customers

Bodybuilding.com, Priceline.com, Ameco Beijing, Viasat, SK Broadband
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 Quest SharePlex vs. SSIS and other solutions. Updated: May 2025.
856,873 professionals have used our research since 2012.