AWS AppSync vs SSIS comparison

Amazon Web Services (AWS) and Microsoft are both solutions in the Cloud Data Integration category. Additionally, 100% of Amazon Web Services (AWS) users are willing to recommend the solution, compared to 79% of Microsoft users who would recommend it.

AWS AppSync

Read 2 AWS AppSync reviews

376 Views
188 Comparison Views

100% willing to recommend

SSIS

Read 74 SSIS reviews

13,168 Views
10,798 Comparison Views

79% willing to recommend

AWS AppSync

SSIS

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between AWS AppSync and SSIS based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed AWS AppSync vs. SSIS Report (Updated: July 2025).

Buyer's Guide

AWS AppSync vs. SSIS

July 2025

Download the complete report

Helped 865,384 peers since 2012

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

Ranking in other categories

Cloud Data Integration (23rd)

SSIS

Average Rating

7.6

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Data Integration (2nd)

Featured Reviews

Akil Saji

AWS Cloud Developer at Mobil80 Solutions and Services Pvt. Ltd.

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.

Read full review

Sean Achim

Managing Director at Knights Innovation Support Centre

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.

Read full review

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."

"Support for multiple data sources and formats is a fantastic feature."

"Like most Microsoft products, SSIS is user-friendly and easy to use."

"The setup was easy. All Microsoft products are easy to set up."

"The initial setup of this solution is very straightforward."

"The scalability of SSIS is good."

"The most valuable feature of SSIS is that it can handle real complex transformations."

"The setup is straightforward. It's very easy to install."

"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."

"It has good data integration and good processes."

More SSIS pros

Cons

"In AppSync, assigning roles and permissions to APIs is necessary for accessing other AWS services. Automating this task when creating APIs would be beneficial."

"Moving to other clouds is impossible without significantly rearchitecting your applications."

"Video training would be a helpful addition."

"SSIS is not stable."

"It hangs a lot of the time."

"The performance of SSIS could improve when comparing it to Oracle Database."

"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."

"SSIS has a difficult learning curve when dealing with complex transformations."

"Improvement as per customer requirements."

"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."

More SSIS cons

Pricing and Cost Advice

"Licensing fees are paid on a monthly basis, and it is a pay-as-you-go model."

"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."

"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."

"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."

"SSIS' licensing is a little high, but it gives good value for money."

"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."

"Our license with SSIS is annual."

"This solution is included with the MSSQL server package."

More SSIS pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.

See recommendations

865,384 professionals have used our research since 2012.

Comparison Review

it_user90069

BI Expert at a healthcare company with 1,001-5,000 employees

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…

Read full review

Top Industries

By visitors reading reviews

No data available

Financial Services Firm

18%

Computer Software Company

11%

Government

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

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...

See all answers

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...

See all answers

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...

See all answers

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...

See all answers

What do you like most about SSIS?

The product's deployment phase is easy.

See all answers

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.

See all answers

Comparisons

AWS Glue vs AWS AppSync

Compared 40% of the time

Zapier vs AWS AppSync

Compared 33% of the time

Workato vs AWS AppSync

Compared 28% of the time

More AWS AppSync Competitors

Informatica PowerCenter vs SSIS

Compared 14% of the time

Talend Open Studio vs SSIS

Compared 10% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% of the time

dbt vs SSIS

Compared 7% of the time

IBM InfoSphere DataStage vs SSIS

Compared 7% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Cloud Data Integration

August 2025

Download AWS AppSync product report

Buyer's Guide

SSIS

July 2025

Download SSIS product report

Also Known As

AppSync

SQL Server Integration Services

Overview

AWS AppSync simplifies application development by letting you create a flexible API to securely access, manipulate, and combine data from one or more data sources. AppSync is a managed service that uses GraphQL to make it easy for applications to get exactly the data they need.

With AppSync, you can build scalable applications, including those requiring real-time updates, on a range of data sources such as NoSQL data stores, relational databases, HTTP APIs, and your custom data sources with AWS Lambda. For mobile and web apps, AppSync additionally provides local data access when devices go offline, and data synchronization with customizable conflict resolution, when they are back online.

Amazon Web Services (AWS)

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.

Microsoft

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

Buyer's Guide

AWS AppSync vs. SSIS

July 2025

Free Report: AWS AppSync vs. SSIS

Find out what your peers are saying about AWS AppSync vs. SSIS and other solutions. Updated: July 2025.

DOWNLOAD NOW

865,384 professionals have used our research since 2012.

See our AWS AppSync vs. SSIS report.

See our list of best Cloud Data Integration vendors.

We monitor all Cloud 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.