AWS Glue vs SSIS comparison

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

AWS Glue

Read 47 AWS Glue reviews

9,044 Views
6,563 Comparison Views

91% willing to recommend

SSIS

Read 72 SSIS reviews

13,383 Views
10,644 Comparison Views

79% willing to recommend

AWS Glue

SSIS

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Jan 12, 2025

SSIS and AWS Glue are both data integration tools competing in the ETL market. AWS Glue holds a notable advantage for cloud environments with its advanced cloud-native features.

Features: SSIS offers robust ETL capabilities and tight integration with Microsoft SQL Server environments, making it ideal for on-premises Microsoft ecosystems. It also features parallel processing and compatibility with the Microsoft BI stack, enabling comprehensive script options for customized tasks. AWS Glue stands out with serverless data preparation, flexible workload management, and deep integration with AWS services, enhancing its utility in cloud applications.

Room for Improvement: SSIS could improve in cloud integration and flexibility, as well as enhancing support for non-Microsoft environments. Additionally, providing more advanced automation features could broaden its appeal. AWS Glue could benefit from easier debugging processes and more intuitive user interfaces for users new to the cloud. Improvements in simplifying complex data transformations would also be advantageous.

Ease of Deployment and Customer Service: SSIS is recognized for its seamless on-premises deployment, especially when used with Microsoft tools, yet relies on self-service support. AWS Glue, conversely, offers a cloud-native, serverless model, reducing management overhead and providing strong customer support, which is highly regarded by users.

Pricing and ROI: SSIS requires significant upfront licensing costs, suitable for enterprises leveraging full Microsoft solutions, and provides a predictable ROI. AWS Glue utilizes a pay-as-you-go pricing model, favorable for businesses with fluctuating workloads, offering a flexible and scalable option that aligns well with cloud-based strategies.

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

Buyer's Guide

AWS Glue vs. SSIS

January 2025

Download the complete report

Helped 831,158 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 Glue

Average Rating

7.8

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

Cloud Data Integration (1st)

SSIS

Average Rating

7.6

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

Data Integration (4th)

Featured Reviews

Muthuvel Sivaraman

AVP at a manufacturing company with 10,001+ employees

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.

Read full review

BobAmy

Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.

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.

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

"The most valuable feature of AWS Glue is that it provides a GUI format with a drag-and-drop feature."

"I appreciate AWS Glue for its cost-effectiveness."

"The solution is serverless so it allows us to transform data while optimizing the cost and performance of Spark jobs."

"The solution’s most valuable feature is the ETL job."

"The solution is stable and reliable."

"The solution integrates well with other AWS products or services."

"Its user interface is quite good. You just need to choose some options to create a job in AWS Glue. The code-generation feature is also useful. If you don't want to customize it and simply want to read a file and store the data in the database, it can generate the code for you."

"You do not need many frameworks to run Glue."

More AWS Glue pros

"The performance is good."

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

"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."

"The setup is easy to use and understand."

"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."

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

"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."

"SSIS' best feature is SFTP connectivity."

More SSIS pros

Cons

"There is a learning curve to this tool."

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

"While working on AWS Glue, I could not find any training material for it."

"There could be an enhanced way of managing pure metadata management or data cataloging."

"The solution could be cheaper. The price of the solution is an area that needs improvement."

"I have encountered challenges with multi-region support."

"Only people who can code, either in Java or Python, can use the product freely. Those who don't know Java or Python might find using AWS Glue difficult."

"The process of entering environment variables in AWS Glue requires navigating to a different page, which could be streamlined."

More AWS Glue cons

"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."

"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."

"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."

"This solution needs full support for real-time processing."

"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."

"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."

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

"Options for scaling could be improved."

More SSIS cons

Pricing and Cost Advice

"The current cost is around forty to fifty thousand a month."

"AWS Glue is a paid service that doesn't come under the free trial of AWS."

"The pricing is a bit higher than other solutions like Athena and EC2. If the pricing becomes more scaled or flexible, it will be good because you have to pay 44 cents just for one DPU for an hour. If you increase DPUs to 5 or 10, the pricing gets multiplied. There are also some time limits like 0 to 10 minutes or 10 to 20 minutes. If the pricing is according to the minutes, it would be better because you have to limit your job to 10 minutes or 20 minutes."

"It is an expensive product. I rate its pricing a nine out of ten."

"Technical support is a paid service, and which subscription you have is dependent on that. You must pay one of them, and it ranges from $15,000 to $25,000 per year."

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

"AWS Glue is quite costly, especially for small organizations."

More AWS Glue pricing and cost advice

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

"This solution has provided an inexpensive tool, and it is easy to find experienced developers."

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

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

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

"People have to opt for a perpetual-based licensing model."

"Our license with SSIS is annual."

"We have an enterprise license for this solution."

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

831,158 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

13%

Manufacturing Company

Insurance Company

Financial Services Firm

18%

Computer Software Company

12%

Government

Healthcare Company

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.

See all answers

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

See all answers

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

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?

The solution comes free of cost.

See all answers

Comparisons

AWS Database Migration Service vs AWS Glue

Compared 35% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs AWS Glue

Compared 7% of the time

Informatica PowerCenter vs AWS Glue

Compared 5% of the time

Talend Open Studio vs AWS Glue

Compared 4% of the time

SnapLogic vs AWS Glue

Compared 4% of the time

More AWS Glue Competitors

Informatica PowerCenter vs SSIS

Compared 22% of the time

Talend Open Studio vs SSIS

Compared 12% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 8% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Alteryx Designer vs SSIS

Compared 3% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

AWS Glue

January 2025

Download AWS Glue product report

Buyer's Guide

SSIS

December 2024

Download SSIS product report

Also Known As

No data available

SQL Server Integration Services

Learn More

Amazon Web Services (AWS)

Microsoft

Overview

AWS Glue is a serverless cloud data integration tool that facilitates the discovery, preparation, movement, and integration of data from multiple sources for machine learning (ML), analytics, and application development. The solution includes additional productivity and data ops tooling for running jobs, implementing business workflows, and authoring.

AWS Glue allows users to connect to more than 70 diverse data sources and manage data in a centralized data catalog. The solution facilitates visual creation, running, and monitoring of extract, transform, and load (ETL) pipelines to load data into users' data lakes. This Amazon product seamlessly integrates with other native applications of the brand and allows users to search and query cataloged data using Amazon EMR, Amazon Athena, and Amazon Redshift Spectrum.

The solution also utilizes application programming interface (API) operations to transform users' data, create runtime logs, store job logic, and create notifications for monitoring job runs. The console of AWS Glue connects all of these services into a managed application, facilitating the monitoring and operational processes. The solution also performs provisioning and management of the resources required to run users' workloads in order to minimize manual work time for organizations.

AWS Glue Features

AWS Glue groups its features into four categories - discover, prepare, integrate, and transform. Within those groups are the following features:

Automatic schema discovery: AWS Glue crawlers connect to the organization's source or target data source through a prioritized list of classifiers to determine the schema for users' data. This feature creates metadata in companies' AWS Glue Data Catalog.
Schemas for data stream management: The AWS Glue Schema Registry enables users to validate and control the evolution of streaming data through registered Apache Avro schemas for no additional charge.
Automatic scaling based on workload: This feature dynamically scales resources up and down based on workload. The feature controls job resources, removing them depending on how much the workload can be split up.
FindMatches: This feature is for machine learning-based data deduplication and cleansing, and works by finding records that are imperfect matches of each other to remove useless data copies.
Edit, debug, and test ETL code: This feature helps users who have chosen to interactively develop their ETL code by providing development endpoints for editing, debugging, and testing the code it generates for them.
AWS Glue DataBrew: An interactive, point-and-click visual interface for specialists to clean and normalize data without the need to write any code.
AWS Glue Interactive Sessions: This feature simplifies the development of data integration jobs by enabling data engineers to interactively prepare and explore data.
AWS Glue Studio Job Notebooks: This AWS Glue feature provides serverless notebooks with minimal setup, allowing developers to start working in a timely manner.
Complex ETL pipeline building: This feature allows the product to be invoked on a schedule, on demand, or based on an event, allowing users to start multiple jobs in parallel or specify dependencies to build complex ETL pipelines.
AWS Glue Studio: This AWS Glue feature allows users to visually transform data through a drag-and-drop interface. The product automatically generates the code for ETL processes for users' data.

AWS Glue Benefits

AWS Glue offers a wide range of benefits for its users. These benefits include:

Users of other AWS products can easily onboard with AWS Glue, as it is integrated across a wide range of the company's services.
The solution is serverless, which allows for a lower total cost of ownership.
AWS Glue offers more power for users, as it automates much of the effort in building, maintaining, and running ETL jobs.
The product allows customers to easily discover and search across all their AWS datasets through AWS Glue Data Catalog.
AWS Glue does not require additional payment for managing and enforcing schemas for data streams.
The solution facilitates the authority of scalable ETL jobs for beginners and non-coding experts through a drag-and-drop interface.

Reviews from Real Users

Mustapha A., a cloud data engineer at Jems Groupe, likes AWS Glue because it is a product that is great for serverless data transformations.

Liana I., CEO at Quark Technologies SRL, describes AWS Glue as a highly scalable, reliable, and beneficial pay-as-you-go pricing model.

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.

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

Buyer's Guide

AWS Glue vs. SSIS

January 2025

Free Report: AWS Glue vs. SSIS

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

DOWNLOAD NOW

831,158 professionals have used our research since 2012.

See our AWS Glue 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.