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

198 Views
116 Comparison Views

100% willing to recommend

SSIS

Read 74 SSIS reviews

11,026 Views
7,140 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: June 2025).

Buyer's Guide

AWS AppSync vs. SSIS

June 2025

Download the complete report

Helped 859,129 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 (3rd)

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

"AWS has made it easy for developers like me to create and manage GraphQL APIs."

"It has good data integration and good processes."

"SSIS' most valuable feature is its reporting services."

"The solution is stable."

"The setup is easy to use and understand."

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

"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."

"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."

"We like that this solution includes a developer edition, free of charge, to allow for training."

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

"It's a legacy tool, that is nearing the end of its useful life."

"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."

"There's no support for it at all. If you haven't undergone the qualifications, you wouldn't even know you should phone someone."

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

"Improving the login procedure would make our reporting easier on monitoring our ETL processes."

"Future releases should improve the data lineage, as it currently is not good."

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

"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."

More SSIS cons

Pricing and Cost Advice

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

"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 purchased the standard edition of SQL Server and SSIS came with it free of charge."

"We have an enterprise license for this solution."

"SSIS is fairly well-priced - I would rate it at four out of five."

"SSIS is a cheaper option compared to the cost of other ETL tools."

"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."

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

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

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

859,129 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

Financial Services Firm

22%

Computer Software Company

17%

Healthcare Company

Real Estate/Law Firm

Financial Services Firm

19%

Computer Software Company

11%

Government

Manufacturing 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

Workato vs AWS AppSync

Compared 37% of the time

AWS Glue vs AWS AppSync

Compared 34% of the time

Zapier vs AWS AppSync

Compared 29% of the time

More AWS AppSync Competitors

Informatica PowerCenter vs SSIS

Compared 17% of the time

Talend Open Studio vs SSIS

Compared 11% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% of the time

IBM InfoSphere DataStage vs SSIS

Compared 7% of the time

dbt vs SSIS

Compared 6% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Cloud Data Integration

June 2025

Download AWS AppSync product report

Buyer's Guide

SSIS

May 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

June 2025

Free Report: AWS AppSync vs. SSIS

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

DOWNLOAD NOW

859,129 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.