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.
"We have found it beneficial when moving data from one source to another."
"The most valuable feature for me is the visual interface of AWS Glue."
"I like its integration and ability to handle all data-related tasks."
"The solution helps organizations gain flexibility in defining the structure of the data."
"One of the best features of the solution is its ability to easily integrate with other AWS services."
"The solution is stable and reliable."
"AWS Glue is quite better than other tools, but you have to learn it properly before you start using it."
"I appreciate AWS Glue for its cost-effectiveness."
"It is easy to set up. The deployment is also very quick."
"The performance is good."
"The technical support is very good."
"The product's deployment phase is easy."
"We can connect with multiple data sources easily using an external connector in SSIS."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"I haven't looked into Glue in terms of seeking out flaws. I've not come across missing features."
"On occasion, the solution's dashboard reports that a project failed due to runtime but it actually succeeded."
"The solution should offer features for streaming data in addition to batching data."
"If there's a cluster-related configuration, we have to make worker notes, which is quite a headache when processing a large amount of data."
"The setup and installation is a bit complex without advanced knowledge or training."
"Overall, I consider the technical support to be fine, although the response time could be faster in certain cases."
"I would like to see stable libraries at the moment they are not there."
"The interface for AWS Glue could improve, they do not put a lot of details. You can write the code, in PySpark or in Scala, which is a big advantage, it is only easy to use for a developer. It will be difficult for new users to enter the cloud environment."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"At one point, we did have to purchase an add-on."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"The performance of this solution is not as good as other tools in the market."
"The solution could improve on integrating with other types of data sources."
"I would like to see better technical documentation because many times information is missing."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"Future releases should improve the data lineage, as it currently is not good."
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.