7 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>Score 8.1 out of 100
Based on 7 reviews and ratings
208 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>Score 8.3 out of 100
Based on 208 reviews and ratings
Likelihood to Recommend
AWS Glue
AWS glue is best if your organization is dealing with large and sensitive data like medical record. Its comes with scheduler and easy deployment for AWS user. The data catalog keeps the reference of the data in a well-structured format. If you are already part of the AWS services, then AWS Glue is the best choice; otherwise, it's not a simple one for deployment.

Verified User
Employee in Research & Development
Computer Software Company, 501-1000 employeesSSIS
- SSIS is particularly well suited for jobs that need to be consistent, repeatable, and error managed.
- Ongoing extract, transform, load [ETL] jobs that are scheduled or manual.
- One-time ETL with complex datasets.
- Migrations of large datasets.

Verified User
Project Manager in Information Technology
Computer Software Company, 201-500 employeesFeature Rating Comparison
Data Source Connection
AWS Glue
—
SSIS
8.6
Connect to traditional data sources
AWS Glue
—
SSIS
9.4
Connecto to Big Data and NoSQL
AWS Glue
—
SSIS
7.8
Data Transformations
AWS Glue
—
SSIS
9.2
Simple transformations
AWS Glue
—
SSIS
9.8
Complex transformations
AWS Glue
—
SSIS
8.6
Data Modeling
AWS Glue
—
SSIS
7.5
Data model creation
AWS Glue
—
SSIS
7.6
Metadata management
AWS Glue
—
SSIS
7.5
Business rules and workflow
AWS Glue
—
SSIS
8.2
Collaboration
AWS Glue
—
SSIS
7.0
Testing and debugging
AWS Glue
—
SSIS
7.6
feature 1
AWS Glue
—
SSIS
7.0
Data Governance
AWS Glue
—
SSIS
8.3
Integration with data quality tools
AWS Glue
—
SSIS
8.7
Integration with MDM tools
AWS Glue
—
SSIS
7.8
Pros
AWS Glue
- Very quick for ETL job.
- UI as well Command Interface with very few steps to create and schedule ETL Job.

Verified User
Employee in Research & Development
Computer Software Company, 501-1000 employeesSSIS
- 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.

Verified User
Team Lead in Information Technology
Information Technology and Services Company, 10,001+ employeesCons
AWS Glue
- Sample Code is very basic and not available in most of the scenario.

Verified User
Employee in Research & Development
Computer Software Company, 501-1000 employeesSSIS
- 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

Verified User
Engineer in Information Technology
Automotive Company, 10,001+ employeesLikelihood to Renew
AWS Glue
No score
No answers yet
No answers on this topic
SSIS
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
Database Administrator
Intralot Italia S.p.A.Gambling & Casinos, 51-200 employees
Usability
AWS Glue
No score
No answers yet
No answers on this topic
SSIS
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.
DBA / Sr. Data Analyst
BoostabilityMarketing and Advertising, 201-500 employees
Performance
AWS Glue
No score
No answers yet
No answers on this topic
SSIS
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.

Verified User
Technician in Information Technology
Medical Devices Company, 201-500 employeesSupport Rating
AWS Glue
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.

Verified User
Employee in Research & Development
Computer Software Company, 501-1000 employeesSSIS
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.
Chemist, LIMS Specialist
USDA-FSISGovernment Administration, 5001-10,000 employees
Implementation Rating
AWS Glue
No score
No answers yet
No answers on this topic
SSIS
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
Database Administrator
Intralot Italia S.p.A.Gambling & Casinos, 51-200 employees
Alternatives Considered
AWS Glue
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.

Verified User
Employee in Research & Development
Computer Software Company, 501-1000 employeesSSIS
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.
Systems/Software Engineer V
Hewlett Packard EnterpriseComputer Hardware, 10,001+ employees
Return on Investment
AWS Glue
- Helps to leverage the data in realtime.
- Leads to quick and clear business decision making.

Verified User
Employee in Research & Development
Computer Software Company, 501-1000 employeesSSIS
- 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.
SQL Database and Business Intelligence Manager
Ten CateTextiles, 1001-5000 employees
Pricing Details
AWS Glue
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.441 |
---|
- billed per second, 1 minute minimum
Additional Pricing Details
—SSIS
General
Free Trial
—Free/Freemium Version
—Premium Consulting/Integration Services
—Entry-level set up fee?
No
SSIS Editions & Modules
—