We performed a comparison between AWS Glue and SSIS based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Of the two solutions, SSIS is slightly more favored by users because they report a positive ROI.
"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."
"AWS Glue is quite better than other tools, but you have to learn it properly before you start using it."
"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 solution is serverless so it allows us to transform data while optimizing the cost and performance of Spark jobs."
"It's fairly straightforward as a product; it's not very complicated."
"We have found it beneficial when moving data from one source to another."
"I like that it's flexible, powerful, and allows you to write your own queries and scripts to get the needed transformations."
"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."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"The interface is very user-friendly."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"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."
"It's already very user-friendly and has a good dashboard."
"The product's deployment phase is easy."
"It's saved time using visualization descriptions."
"While working on AWS Glue, I could not find any training material for it."
"AWS Glue is more costly compared to other tools like Airflow."
"The solution should offer features for streaming data in addition to batching data."
"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."
"I haven't looked into Glue in terms of seeking out flaws. I've not come across missing features."
"The solution’s stability could be improved."
"The product is expensive for data streaming. This area needs improvement."
"I have encountered challenges with multi-region support."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"The performance of SSIS could improve when comparing it to Oracle Database."
"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."
"Video training would be a helpful addition."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"The solution could improve by having quicker release updates."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
AWS Glue is ranked 1st in Cloud Data Integration with 37 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. AWS Glue is rated 7.8, while SSIS is rated 7.6. The top reviewer of AWS Glue writes "Provides serverless mechanism, easy data transformation and automated infrastructure management". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". AWS Glue is most compared with AWS Database Migration Service, Informatica PowerCenter, Informatica Cloud Data Integration, Talend Open Studio and Oracle Integration Cloud Service, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and Azure Data Factory. 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.
