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'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."
"The solution is serverless so it allows us to transform data while optimizing the cost and performance of Spark jobs."
"I like its integration and ability to handle all data-related tasks."
"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."
"It's fairly straightforward as a product; it's not very complicated."
"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."
"AWS Glue is a good solution for developers, they have the ability to write code in different languages and other software."
"AWS Glue is a stable and easy-to-use solution."
"The UI is very user-friendly."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"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."
"Overall, it's a good product."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The scalability of SSIS is good."
"The performance and stability are good."
"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."
"On occasion, the solution's dashboard reports that a project failed due to runtime but it actually succeeded."
"The product is expensive for data streaming. This area needs improvement."
"It fails to handle massive databases acquired from various sources."
"There should be more connectors for different databases."
"The solution should offer features for streaming data in addition to batching data."
"The solution’s stability could be improved."
"We face performance issues when using AWS Glue for data transformation and integration."
"I have encountered challenges with multi-region support."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"I would like to see better integration with Power BI."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"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."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
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.