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 appreciate AWS Glue for its cost-effectiveness."
"Transformations are valuable because you can modify or override complex data logic from an open source or Spark to solve issues."
"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."
"AWS Glue is a good solution for developers, they have the ability to write code in different languages and other software."
"It is AWS-integrated. There is end-to-end integration with the other AWS services. It is also user-friendly."
"The most valuable feature for me is the visual interface of AWS Glue."
"The solution's technical support is good. Whenever we raise a use case where we face an issue in our company, we get a response from the solution's technical team."
"It's fairly straightforward as a product; it's not very complicated."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"It is easy to set up the product."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"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 product's deployment phase is easy."
"It has good data integration and good processes."
"SSIS' best feature is SFTP connectivity."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"I haven't looked into Glue in terms of seeking out flaws. I've not come across missing features."
"AWS Glue would be improved by making it easier to switch from single to multi-cloud."
"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."
"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."
"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."
"Only people who can code, either in Java or Python, can use the product freely. Those who don't know Java or Python might find using AWS Glue difficult."
"The start-up time is really high right now. For instance, when you start up a new job, you have to wait for five or eight minutes before it starts. If the start-up time is reduced to one or two minutes, it will be great. It will be better to have a direct linkage to Redshift in AWS. If we can use data catalogs from Redshift, it will be so easy to create some data catalogs. Currently, we can only use data catalogs from S3."
"This solution needs full support for real-time processing."
"The security could be improved, as it is more important in our context."
"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."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"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.