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

AWS Glue vs SSIS comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Nov 2, 2025

Review summaries and opinions

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

ROI

Sentiment score
5.9
Organizations find AWS Glue efficient and cost-effective despite overhead costs, though some consider alternatives due to budget constraints.
Sentiment score
7.6
SSIS is praised for cost-effective, efficient data management with significant savings, but users may switch with more budget.
I advocate using Glue in such cases.
Data Architect at a financial services firm with 10,001+ employees
The tool has made us tremendously more efficient and saved us a significant amount of money.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
Managing Partner at Dynamis Informatica
 

Customer Service

Sentiment score
6.5
AWS Glue customer service is praised for responsiveness and effectiveness, with mixed feedback on support speed, costs, and consistency.
Sentiment score
6.0
Users rely on forums for SSIS issues; Microsoft support is mixed, with some finding response times and quality lacking.
Upgrades occur every four months, and new developments coincide with version updates.
Principal Consultant at a retailer with 1,001-5,000 employees
For complex Glue-related problems such as job failures or permission issues, their documentation is good, but having direct access to support helps cut down troubleshooting time significantly.
application security engineer at Hyperspace IT India
The first line of support needs to be more knowledgeable.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
 

Scalability Issues

Sentiment score
7.8
AWS Glue is highly scalable and serverless, praised for easy resource management, but needs better parallel computation.
Sentiment score
6.7
SSIS is scalable and excels in data integration, but efficiency varies with large datasets and real-time processing challenges.
It is beneficial to upgrade jobs, and we conduct extensive testing in development before migrating to production.
Principal Consultant at a retailer with 1,001-5,000 employees
It can easily handle data from one terabyte to 100 terabytes or more, scaling nicely with larger datasets.
Python AWS & AI Expert at a tech consulting company
 

Stability Issues

Sentiment score
7.9
AWS Glue is stable and reliable with minor issues, scaling well, and efficient due to serverless architecture and tool integration.
Sentiment score
7.4
SSIS is generally praised for stability and reliability, though some users note issues and the need for strong infrastructure.
AWS Glue is highly stable, and I would rate its stability as nine.
Python AWS & AI Expert at a tech consulting company
It processes large volumes of data quickly.
Managing Partner at Dynamis Informatica
 

Room For Improvement

AWS Glue faces challenges with startup times, interface complexity, language limitations, cost, performance, integration, and multi-cloud compatibility.
SSIS needs improved scalability, data source support, real-time processing, cloud integration, and user-friendly interfaces for better performance.
Migrating jobs from version 3.0 to 4.0 can present compatibility issues.
Principal Consultant at a retailer with 1,001-5,000 employees
With AWS, I gather data from multiple sources, clean it up, normalize it, de-duplicate it, and make it presentable.
Data Architect at a financial services firm with 10,001+ employees
A more user-friendly and simpler process would help speed up the deployment process.
Python AWS & AI Expert at a tech consulting company
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
Managing Director at Knights Innovation Support Centre
SSIS has a difficult learning curve when dealing with complex transformations.
Managing Partner at Dynamis Informatica
The logging capabilities could be improved, particularly for error logging.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
 

Setup Cost

AWS Glue offers flexible, efficient serverless architecture but can be costly and unpredictable, especially for smaller organizations.
SSIS offers a cost-effective ETL solution for enterprises using Microsoft, enhancing affordability by integrating with SQL Server licenses.
Costing depends on resource usage, and cost optimization may involve redesigning jobs for flexibility.
Principal Consultant at a retailer with 1,001-5,000 employees
AWS charges based on runtime, which can be quite pricey.
Data Architect at a financial services firm with 10,001+ employees
The smallest cost for a project is around €700, while the largest can reach up to €7,000 based on the scale of the usage.
Python AWS & AI Expert at a tech consulting company
Utilizing SSIS involves no extra charges beyond the SQL Server license.
Managing Partner at Dynamis Informatica
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.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
 

Valuable Features

AWS Glue excels with its easy interface, scalable ETL processing, seamless AWS integration, affordability, and serverless architecture.
SSIS provides user-friendly drag-and-drop functionality, excellent integration, scalability, cost-efficiency, and robust data transformation features.
For ETL, I feel the performance is excellent. If I create jobs in a standard way, the performance is great, and maintenance is also seamless.
Principal Consultant at a retailer with 1,001-5,000 employees
AWS Glue's most valuable features include its transformation capabilities, which provide data quality and shape for processing in ML or AI models.
Python AWS & AI Expert at a tech consulting company
AWS Glue has reduced efforts by 60%, which is the main benefit.
application security engineer at Hyperspace IT India
I would rate it at a 10 as it is highly reliable; we have never had any problems with it.
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
Managing Partner at Dynamis Informatica
SSAS is included in the base installation of SQL Server.
Managing Director at Knights Innovation Support Centre
 

Categories and Ranking

AWS Glue
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
50
Ranking in other categories
Cloud Data Integration (1st)
SSIS
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
75
Ranking in other categories
Data Integration (1st)
 

Featured Reviews

NS
Principal Consultant at a retailer with 1,001-5,000 employees
The solution improves ETL performance but faces challenges with version upgrades
For ETL, I feel the performance is excellent. If I create jobs in a standard way, the performance is great, and maintenance is also seamless. It is serverless, so I do not need to worry about other integrations. It runs on a serverless VM. Glue services from AWS are regularly upgraded with new properties and functions. We use PySpark and other frameworks, which help customize our ETL process in a standard way. During our process, we utilized the typical SQL ITIL process standard in Glue-oriented ETL services, which helped us improve performance and time. AWS running time, mostly during the morning, saved us time compared to the old ETL method. There are many email notifications once a job is successful or fails, and we get notifications using SES or AWS's Simple Notification Service. Glue is integrated with both email alerts, and we are responsible for managing the full data journey from end to end.
Chris Farris - PeerSpot reviewer
Manager, Data Operations at a manufacturing company with 5,001-10,000 employees
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.
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
879,455 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
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…
 

Top Industries

By visitors reading reviews
Financial Services Firm
21%
Computer Software Company
12%
Manufacturing Company
8%
Government
6%
Financial Services Firm
17%
Computer Software Company
9%
Government
8%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business11
Midsize Enterprise6
Large Enterprise32
By reviewers
Company SizeCount
Small Business26
Midsize Enterprise19
Large Enterprise57
 

Questions from the Community

How do you select the right cloud ETL tool?
AWS Glue and Azure Data factory for ELT best performance cloud services.
How does Talend Open Studio compare with AWS Glue?
We reviewed AWS Glue before choosing Talend Open Studio. AWS Glue is the managed ETL (extract, transform, and load) from Amazon Web Services. AWS Glue enables AWS users to create and manage jobs in...
What are the most common use cases for AWS Glue?
AWS Glue's main use case is for allowing users to discover, prepare, move, and integrate data from multiple sources. The product lets you use this data for analytics, application development, or ma...
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.
 

Also Known As

No data available
SQL Server Integration Services
 

Overview

 

Sample Customers

bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
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 Glue vs. SSIS and other solutions. Updated: December 2025.
879,455 professionals have used our research since 2012.