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

AWS Glue vs SSIS comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 12, 2025

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 Glue
Average Rating
7.8
Reviews Sentiment
7.0
Number of Reviews
48
Ranking in other categories
Cloud Data Integration (1st)
SSIS
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
72
Ranking in other categories
Data Integration (4th)
 

Featured Reviews

Muthuvel Sivaraman - PeerSpot reviewer
Handles a huge volume of data and is serverless, but it can be considered costly by some users
We use Amazon's services to provide technical support for the product. If you want to have support, Oracle and others offer a single support, and other tools have a direct support window. For Amazon, we need to pay 10 percent of my billing amount for the tool to get support services. Whether to raise a support ticket or not is an issue since ten percent is a huge amount. My company ends up using all the options without help from support. It is very difficult for any common man to understand why there is a need to pay ten percent for support. If I find an issue in the product, and I need to get support from AWS to fix it, then I need to pay ten percent of the tool's bill amount to Amazon. AWS is a very tricky tool because everything is evolving nowadays. AWS engineers are getting hired from other places, and even after that, if I am not getting any technical support, then things will be very nasty. There are some good engineers who help users outside the normal support cycle, but it doesn't meet their needs. I rate the technical support a four out of ten.
BobAmy - PeerSpot reviewer
Robust and does a good job of handling overload conditions
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. I believe there are ways to build a model and set variables so that it can be a generic process. In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded. I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.

Quotes from Members

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

Pros

"The most valuable features currently are glue studio, jobs, and triggers."
"I also like that you can add custom libraries like JAR files and use them. So, the ability to use a fast processing engine and embed basic jobs easily are significant advantages."
"It is a very scalable solution."
"The solution’s most valuable feature is the ETL job."
"One of the best features of the solution is its ability to easily integrate with other AWS services."
"We have found it beneficial when moving data from one source to another."
"AWS Glue is fast and managed by AWS. Hence, you don't have to worry about capacity and the performance of Glue jobs. It has integrations with other data stores of AWS. The product offers metadata management, logging, and ETL processing capabilities. It comes with a powerful feature, Glue Studio, which helps to do queries interactively within the community. It is a managed service and very secure. Another popular and mature service is S3."
"AWS Glue's most valuable features are the data catalog, including crawlers and tables, and Glue Studio, which means you don't have to use custom code."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The most valuable feature of the solution is performance."
"It is easy to set up the product."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The data reader is the most valuable feature."
"We like that this solution includes a developer edition, free of charge, to allow for training."
 

Cons

"The technical support for this solution could be improved. In future, we would like to connect more services like Athena or Kinesis to help control more loads of data."
"Cost-wise, AWS Glue is expensive, so that's an area for improvement. The process for setting up the solution was also complex, which is another area for improvement."
"On occasion, the solution's dashboard reports that a project failed due to runtime but it actually succeeded."
"If there's a cluster-related configuration, we have to make worker notes, which is quite a headache when processing a large amount of data."
"The solution's visual ETL tool is of no use for actual implementation."
"The setup and installation is a bit complex without advanced knowledge or training."
"The solution’s stability could be improved."
"AWS Glue should be more reliable and faster in processing. Enhancing the speed of data processing would be beneficial."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"We'd like more integration capabilities."
"The security could be improved, as it is more important in our context."
"Performance could be better."
"The performance of SSIS could improve when comparing it to Oracle Database."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"This solution needs full support for real-time processing."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
 

Pricing and Cost Advice

"AWS Glue is a paid service that doesn't come under the free trial of AWS."
"The overall cost of AWS Glue could be better. It cost approximately $1,000 a month. There is paid support available from AWS Glue."
"If you are using the solution for an enterprise business, it will be expensive."
"The current cost is around forty to fifty thousand a month."
"I rate the product's pricing a five on a scale of one to ten, where one is a high price, and ten is a low price."
"AWS Glue uses a pay-as-you-go approach which is helpful. The price of the overall solution is low and is a great advantage."
"It is an expensive product. I rate its pricing a nine out of ten."
"AWS Glue is a high-priced solution that bills the client $150,000 to $250,000 annually."
"People have to opt for a perpetual-based licensing model."
"The solution comes free of cost."
"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."
"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."
"The solution is available at a lesser price than that of Informatica."
"SSIS is a cheaper option compared to the cost of other ETL tools."
"Our license with SSIS is annual."
"SSIS is fairly well-priced - I would rate it at four out of five."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
838,640 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
22%
Computer Software Company
13%
Manufacturing Company
8%
Insurance Company
6%
Financial Services Firm
18%
Computer Software Company
12%
Government
8%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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.
 

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: January 2025.
838,640 professionals have used our research since 2012.