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 46 AWS Glue reviews

9,512 Views
6,902 Comparison Views

91% willing to recommend

SSIS

Read 72 SSIS reviews

14,200 Views
11,375 Comparison Views

79% willing to recommend

AWS Glue

SSIS

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Oct 8, 2024

SSIS and AWS Glue are competing in the data integration solutions category. AWS Glue seems to have the upper hand due to its cloud-native features and advanced functionalities.

Features: SSIS includes a drag-and-drop design, comprehensive transformation tasks, and strong support for Windows environments. AWS Glue offers a serverless model, efficient data processing capabilities, and high flexibility and scalability.

Room for Improvement: SSIS could enhance its cloud integration, simplify maintenance, and modernize its interface. AWS Glue needs to improve its documentation, user guides, and support responsiveness.

Ease of Deployment and Customer Service: SSIS provides straightforward deployment in Windows environments and reliable customer support. AWS Glue provides flexibility and quick deployment in cloud environments with mixed feedback on support responsiveness.

Pricing and ROI: SSIS offers a predictable pricing model that aids in budgeting. AWS Glue provides better ROI for cloud-centric strategies with a pay-as-you-go model, making it appealing for scalability without upfront costs.

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

Buyer's Guide

AWS Glue vs. SSIS

December 2024

Download the complete report

Helped 824,053 peers since 2012

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

Ajaykumar Myana

Senior Software Developer at a computer software company with 10,001+ employees

Provides serverless mechanism, easy data transformation and automated infrastructure management

We no longer had to worry much about infrastructure management because AWS Glue is serverless, and Amazon takes care of the underlying infrastructure. This allowed us to focus on the code and application logic without concerns about scaling, CPU management, or handling fluctuations in flow. The serverless nature of Glue jobs relieved us from these infrastructure-related worries.

Read full review

Sakiru Dosumu

Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.

Its ability to transform and transport data is extremely valuable

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

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 features currently are glue studio, jobs, and triggers."

"The solution is highly user-friendly, and its features are easy to use. The new addition of AWS Glue Data Catalog is also very beneficial, making the tool even more helpful for its users."

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

"I like its integration and ability to handle all data-related tasks."

"The solution's technical support is good. Whenever we raise a use case where we face an issue in our company, we get a response from the solution's technical team."

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

"It is AWS-integrated. There is end-to-end integration with the other AWS services. It is also user-friendly."

"The AWS Glue Data Catalog provides metadata management and schema discovery. AWS Glue simplifies data transformation with automatic schema detection, incremental data updates, and integration with other AWS services."

More AWS Glue pros

"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."

"The performance and stability are good."

"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."

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

"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 is easy to set up the product."

"It's a competent product."

"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."

More SSIS pros

Cons

"The product has only a few built-in transformations."

"AWS Glue is more costly compared to other tools like Airflow."

"The drawbacks associated with the product stem from the fact that, based on the data volume, it can become very costly."

"It would be better if it were more user-friendly. The interesting thing we found is that it was a little strange at the beginning. The way Glue works is not very straightforward. After trying different things, for example, we used just the console to create jobs. Then we realized that things were not working as expected. After researching and learning more, we realized that even though the console creates the script for the ETL processes, you need to modify or write your own script in Spark to do everything you want it to do. For example, we are pulling data from our source database and our application database, which is in Aurora. From there, we are doing the ETL to transform the data and write the results into Redshift. But what was surprising is that it's almost like whatever you want to do, you can do it with Glue because you have the option to put together your own script. Even though there are many functionalities and many connections, you have the opportunity to write your own queries to do whatever transformations you need to do. It's a little deceiving that some options are supposed to work in a certain way when you set them up in the console, but then they are not exactly working the right way or not as expected. It would be better if they provided more examples and more documentation on options."

"AWS Glue should be more reliable and faster in processing. Enhancing the speed of data processing would be beneficial."

"We face performance issues when using AWS Glue for data transformation and integration."

"It is very difficult to learn the tool and remember the syntaxes comparatively."

"The solution’s technical support could be improved."

More AWS Glue cons

"We have a stability problem because when something works, it works one time. The next time, it doesn't work."

"SSIS is not stable."

"Improvement as per customer requirements."

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

"Tuning using this solution requires extensive expertise to improve performance."

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

"The solution could improve by having quicker release updates."

More SSIS cons

Pricing and Cost Advice

"Its price is good. We pay as we go or based on the usage, which is a good thing for us because it is simple to forecast for the tool. It is good in terms of the financial planning of the company, and it is a good way to estimate the cost. It is also simple for our clients. In my opinion, it is one of the best tools in the market for ETL processes because of the fact that you pay as you use, which separates it from other big tools such as PowerCenter, Pentaho Data Integration, and Talend."

"The solution's pricing is based on DPUs so it is a good idea to optimize use or it can get expensive."

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

"I would rate the solution a six or seven on a scale of one to ten, with ten being very expensive. Specifically, I rate its pricing a six out of ten."

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

"I rate pricing an eight out of ten."

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

"If you are using the solution for an enterprise business, it will be expensive."

More AWS Glue pricing and cost advice

"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."

"We have an enterprise license for this solution."

"All of my clients have this product included as part of their Microsoft license."

"It would be beneficial if the solution had a less costly cloud offering."

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

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

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

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

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

824,053 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 6% 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 23% of the time

Talend Open Studio vs SSIS

Compared 13% 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

December 2024

Download AWS Glue product report

Buyer's Guide

SSIS

November 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

December 2024

Free Report: AWS Glue vs. SSIS

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

DOWNLOAD NOW

824,053 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.