AWS Glue vs SSIS | TrustRadius

What users are saying about

Score 8.1 out of 10

Based on 7 reviews and ratings

Score 8.3 out of 10

Based on 208 reviews and ratings

Feature Rating Comparison

AWS Glue

SSIS

Connect to traditional data sources

Connecto to Big Data and NoSQL

AWS Glue

SSIS

Simple transformations

Complex transformations

AWS Glue

SSIS

Data model creation

Metadata management

Business rules and workflow

Collaboration

Testing and debugging

feature 1

AWS Glue

SSIS

Integration with data quality tools

Integration with MDM tools

Pros

Very quick for ETL job.
UI as well Command Interface with very few steps to create and schedule ETL Job.

Read full review

Verified User

Employee in Research & Development

Computer Software Company, 501-1000 employees

View all 1 answers on this topic

SSIS works very well pulling well-defined data into SQL Server from a wide variety of data sources.
It comes free with the SQL Server so it is hard not to consider using it providing you have a team who is trained and experienced using SSIS.
When SSIS doesn't have exactly what you need you can use C# or VBA to extend its functionality.

Read full review

Verified User

Team Lead in Information Technology

Information Technology and Services Company, 10,001+ employees

View all 35 answers on this topic

Cons

Sample Code is very basic and not available in most of the scenario.

Read full review

Verified User

Employee in Research & Development

Computer Software Company, 501-1000 employees

View all 1 answers on this topic

SSIS memory usage can be quite high particularly when SSI and SQL server are on the same machine
SSIS is not available on any environment other than Microsoft Windows
SSIS does not function with any database engine back-end other than Microsoft SQL Server

Read full review

Verified User

Engineer in Information Technology

Automotive Company, 10,001+ employees

View all 35 answers on this topic

Likelihood to Renew

No score

No answers yet

No answers on this topic

SSIS 10.0

Based on 3 answers

Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure

Read full review

Luca Campanelli

Database Administrator

Intralot Italia S.p.A.Gambling & Casinos, 51-200 employees

View all 3 answers on this topic

Usability

No score

No answers yet

No answers on this topic

SSIS 9.2

Based on 8 answers

If you use any of the Microsoft tools, it is easy to get using and understand since it uses Visual Studio and SSMS to work with. There are extensions you can get and some of those can be difficult to work with but usually they slide in nicely. The one thing to understand though is there is some installation and configuration on the SQL Server side that can take some time.

Read full review

Steven Gockley, MBA, MCSA

DBA / Sr. Data Analyst

BoostabilityMarketing and Advertising, 201-500 employees

View all 8 answers on this topic

Performance

No score

No answers yet

No answers on this topic

SSIS 8.7

Based on 6 answers

You can, of course, accidentally make sloppy code or workflows but it’s not a tools issue if you run packages in an inefficient way. With a company of our size, we never had any performance issues but I can imagine for larger companies that this will have a greater focus.

Read full review

Verified User

Technician in Information Technology

Medical Devices Company, 201-500 employees

View all 6 answers on this topic

Support Rating

AWS Glue 7.0

Based on 1 answer

Amazon responds in good time once the ticket has been generated but needs to generate tickets frequent because very few sample codes are available, and it's not cover all the scenarios.

Read full review

Verified User

Employee in Research & Development

Computer Software Company, 501-1000 employees

View all 1 answers on this topic

SSIS 8.1

Based on 8 answers

The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.

Read full review

Chemist, LIMS Specialist

USDA-FSISGovernment Administration, 5001-10,000 employees

View all 8 answers on this topic

Implementation Rating

No score

No answers yet

No answers on this topic

SSIS 10.0

Based on 1 answer

The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools

Read full review

Luca Campanelli

Database Administrator

Intralot Italia S.p.A.Gambling & Casinos, 51-200 employees

View all 1 answers on this topic

Alternatives Considered

We are already in AWS services, so AWS glue is the first choice for us. But for the comparison of ETL job making and process time, it's way faster for other services.

Read full review

Verified User

Employee in Research & Development

Computer Software Company, 501-1000 employees

View all 1 answers on this topic

Look for where you are going to load the data and from where are you extracting it. A lot of those who sell you the DB already have tools for ETL. I have heard good things at an enterprise level from great colleagues about Informatica, but honestly, I prefer SSIS.Although I did like TIBCO Jaspersoft and it can be mixed with TIBCO Spotfire for data analysis. If your ERP is SAP, then you must keep in mind using SAP BusinessObjects. As for free tools, and if you have a great and constant team of scripting (Perl, Python) engineers, then you can think about going open source.

Read full review

Systems/Software Engineer V

Hewlett Packard EnterpriseComputer Hardware, 10,001+ employees

View all 35 answers on this topic

Return on Investment

Helps to leverage the data in realtime.
Leads to quick and clear business decision making.

Read full review

Verified User

Employee in Research & Development

Computer Software Company, 501-1000 employees

View all 1 answers on this topic

I use SSIS to automate tasks that I'm repeatedly asked to do. "Hey, can you go into the system and close any open orders that we've fully filled?" Sure....then I schedule a package to do that for me every hour so I'm never asked again. It saves me time, which gives value to the company.
It removes the risk of human error. When people build files and send them, there's the risk that it doesn't happen the same way every time or gets forgotten. With SSIS, you spend some up front time building a process, but then you deploy it and forget it (unless it emails you that there was an error. You are putting error handling in your ETL, right?). Very repeatable and consistent business solution.

Read full review

SQL Database and Business Intelligence Manager

Ten CateTextiles, 1001-5000 employees

View all 35 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

AWS Glue Editions & Modules

Edition

per DPU-Hour	$0.44¹

billed per second, 1 minute minimum

Additional Pricing Details

—

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

SSIS Editions & Modules

—

Additional Pricing Details

—

Rating Summary

AWS Glue

SSIS

AWS Glue

SSIS

AWS Glue

SSIS

AWS Glue

SSIS

AWS Glue

SSIS

AWS Glue

SSIS

Add comparison