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.
"Its user interface is quite good. You just need to choose some options to create a job in AWS Glue. The code-generation feature is also useful. If you don't want to customize it and simply want to read a file and store the data in the database, it can generate the code for you."
"Our entire use case was very easily handled or solved using this solution."
"The product has a valuable feature for data catalog."
"One of the best features of the solution is its ability to easily integrate with other AWS services."
"The most valuable feature for me is the visual interface of AWS Glue."
"Data catalog and triggers are the two best features for me. AWS Glue has its own data catalog, which makes it great and really easy to use. Triggers are also really good for scheduling the ETL process."
"The solution integrates well with other AWS products or services."
"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."
"The scalability of SSIS is good."
"The solution is stable."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"The most important features are it works well and provides self-service BI."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"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."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"The setup and installation is a bit complex without advanced knowledge or training."
"AWS Glue is more costly compared to other tools like Airflow."
"Glue could perform better. It sometimes takes too long to test a Glue job. Google Cloud Platform offers more Python scripts than AWS."
"We face performance issues when using AWS Glue for data transformation and integration."
"In terms of improvement, the performance of AWS Glue could be faster."
"The solution could be cheaper. The price of the solution is an area that needs improvement."
"There is a learning curve to this tool."
"The solution should offer features for streaming data in addition to batching data."
"Generic processes should be used instead of custom code for each table."
"This solution needs full support for real-time processing."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"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."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
AWS Glue is ranked 1st in Cloud Data Integration with 37 reviews while SSIS is ranked 2nd in Data Integration with 68 reviews. AWS Glue is rated 7.8, while SSIS is rated 7.8. 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 Confluent, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), IBM InfoSphere DataStage 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.