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

AWS AppSync vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary

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

AWS AppSync
Average Rating
8.0
Reviews Sentiment
6.6
Number of Reviews
2
Ranking in other categories
Cloud Data Integration (23rd)
SSIS
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
75
Ranking in other categories
Data Integration (2nd)
 

Featured Reviews

Akil Saji - PeerSpot reviewer
Ease of creating APIs with ongoing updates needed for automation
AWS has made it easy for developers like me to create and manage GraphQL APIs. The ease of use is a main advantage, allowing even beginners to start from scratch and learn through AppSync. Before AWS, developing and managing APIs was quite complex. AWS provided AppSync, which assists developers and startup founders. Startups blooming everywhere benefit from this service, welcoming those who lack prior knowledge. When working on AWS, I notice that Amazon regularly implements new features. For instance, with the Lambda service, AWS is transitioning from an old editor to a new one. Similarly, AppSync frequently introduces updates and changes. This trend is making the user interface more accessible, even for individuals without a technical background. Additionally, the cost is attractive, as AWS operates on a pay-as-you-go basis. These factors make AppSync both easy to use and cost-effective.
Chris Farris - PeerSpot reviewer
User-friendly interface facilitates efficient data migration and reduces operational overhead
Its usability and ease of use are standout features. It is really easy to use - almost too easy at times. Users don't have to be experts to use their tool set and utilize the clicking mechanisms, drop down boxes, and other features to build a package and run it. The configuration is very easy and the system is very stable. I would rate it at a 10 as it is highly reliable; we have never had any problems with it. Very little maintenance is required on my side. While you need to keep the product up to date, the maintenance requirements are minimal. SSIS integrates with all Microsoft tools seamlessly. We have used it against Oracle, DB2 and SQL. It integrates and can move data around from any data platforms, making it very diverse in that standpoint. It is a very robust tool that can work with many data sources, and its main strength is that it is extremely easy to use.

Quotes from Members

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

Pros

"AWS has made it easy for developers like me to create and manage GraphQL APIs."
"AWS has made it easy for developers like me to create and manage GraphQL APIs."
"Support for multiple data sources and formats is a fantastic feature."
"The initial setup was easy."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The initial setup of this solution is very straightforward."
"The solution is easy to use and developer friendly."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"It is easy to set up. The deployment is also very quick."
"The technical support is very good."
 

Cons

"Moving to other clouds is impossible without significantly rearchitecting your applications."
"In AppSync, assigning roles and permissions to APIs is necessary for accessing other AWS services. Automating this task when creating APIs would be beneficial."
"In AppSync, assigning roles and permissions to APIs is necessary for accessing other AWS services. Automating this task when creating APIs would be beneficial."
"It's a legacy tool, that is nearing the end of its useful life."
"Tuning using this solution requires extensive expertise to improve performance."
"Future releases should improve the data lineage, as it currently is not good."
"SSIS is not stable."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"Integration and the user interface are areas with certain shortcomings that require some improvements."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
 

Pricing and Cost Advice

"Licensing fees are paid on a monthly basis, and it is a pay-as-you-go 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."
"This solution is included with the MSSQL server package."
"The solution is available at a lesser price than that of Informatica."
"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."
"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."
"Our license with SSIS is annual."
"It would be beneficial if the solution had a less costly cloud offering."
"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 licensing, SSIS can be expensive."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
869,566 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
No data available
Financial Services Firm
18%
Computer Software Company
10%
Government
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business26
Midsize Enterprise19
Large Enterprise57
 

Questions from the Community

What is your experience regarding pricing and costs for AWS AppSync?
We initially had limited knowledge about AWS costs. As beginners, we ran many instances for over a month. Consequently, we received a bill from Amazon for around $20, which was unexpected. This hig...
What needs improvement with AWS AppSync?
In AppSync, assigning roles and permissions to APIs is necessary for accessing other AWS services. Automating this task when creating APIs would be beneficial. Regular updates might soon address th...
What is your primary use case for AWS AppSync?
Our company handles in-house projects and serves clients globally. My role with AppSync involves creating GraphQL APIs. There are different types of APIs, such as REST API, GraphQL API, and WebSock...
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?
It was included in our licensing for SQL server, and our licensing for SQL server was extremely cheap, making it a very good price point for us.
 

Comparisons

 

Also Known As

AppSync
SQL Server Integration Services
 

Overview

 

Sample Customers

ACBL, Puresec, IDT, ASU, Public Good, cookpad, ALDO, ticketmaster
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 AWS AppSync vs. SSIS and other solutions. Updated: September 2025.
869,566 professionals have used our research since 2012.