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.
"The solution is highly user-friendly, and its features are easy to use. The new addition of AWS Glue Data Catalog is also very beneficial, making the tool even more helpful for its users."
"The most valuable feature of AWS Glue is scalability."
"The most valuable feature of AWS Glue is that it provides a GUI format with a drag-and-drop feature."
"I like the fact that AWS Glue works with Python scripts."
"What I like best about AWS Glue is its real-time data backup feature. Last week, there was a production push, and what used to take almost ten days to send out around fifty-six thousand emails now takes only two hours."
"It is AWS-integrated. There is end-to-end integration with the other AWS services. It is also user-friendly."
"We have found it beneficial when moving data from one source to another."
"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 performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"The performance and stability are good."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"SSIS' best feature is SFTP connectivity."
"The performance is good."
"We can connect with multiple data sources easily using an external connector in SSIS."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"SSIS' most valuable feature is its reporting services."
"In terms of performance, if they can further optimize the execution time for serverless jobs, it would be a welcome improvement."
"In terms of improvement, the performance of AWS Glue could be faster."
"There should be more connectors for different databases."
"There is a learning curve to this tool."
"The setup and installation is a bit complex without advanced knowledge or training."
"Glue could perform better. It sometimes takes too long to test a Glue job. Google Cloud Platform offers more Python scripts than AWS."
"One area that could be improved is the ETL view. The drag-and-drop interface is not as user-friendly as some other ETL tools."
"On occasion, the solution's dashboard reports that a project failed due to runtime but it actually succeeded."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"I would like to see better technical documentation because many times information is missing."
"The solution could improve by having quicker release updates."
"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."
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.