Coming October 25: PeerSpot Awards will be announced! Learn more
Cancel
You must select at least 2 products to compare!
Amazon Logo
19,150 views|15,466 comparisons
Microsoft Logo
Read 21 SSIS reviews
26,385 views|20,452 comparisons
Comparison Buyer's Guide
Executive Summary
Updated on September 6, 2022

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.

  • Ease of Deployment: Users of both solutions report that the initial setup and deployment is straightforward and easy.
  • Features: Users of both products are happy with their stability and scalability.

    AWS Glue users like its user interface and say it is easy to implement ETL processes. Reviewers mention that the solution is slow when starting up.

    SSIS users like the solution’s ease of use, scripting, debugging capabilities, and the easy integration with Microsoft tools. Users mention they would like to see more supported programming languages.
  • Pricing: AWS Glue users share mixed reviews regarding pricing. SSIS users say that the solution is cost-effective, although the cloud offering is very costly.
  • Service and Support: Users of both products are satisfied with the level of support they receive.
  • ROI: AWS Glue users do not mention an ROI. SSIS users report a positive ROI.

Comparison Results: Of the two solutions, SSIS is slightly more favored by users because they report a positive ROI.

To learn more, read our detailed AWS Glue vs. SSIS report (Updated: August 2022).
633,572 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"AWS Glue is a good solution for developers, they have the ability to write code in different languages and other software.""I like that it's flexible, powerful, and allows you to write your own queries and scripts to get the needed transformations.""The facility to integrate with S3 and the possibility to use Jupyter Notebook inside the pipeline are the most valuable features.""It is AWS-integrated. There is end-to-end integration with the other AWS services. It is also user-friendly.""Glue is a NoSQL-based data ETL tool that has some advantages over IIS and ISAs.""AWS Glue's most valuable features are the data catalog, including crawlers and tables, and Glue Studio, which means you don't have to use custom code.""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.""One of the best features of the solution is its ability to easily integrate with other AWS services."

More AWS Glue Pros →

"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 performance and stability are good.""The performance is good.""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.""Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows.""SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code.""It's a competent product.""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."

More SSIS Pros →

Cons
"The technical support for this solution could be improved. In future, we would like to connect more services like Athena or Kinesis to help control more loads of data.""The crucial problem with AWS Glue is that it only works with AWS. It is not an agnostic tool like Pentaho. In PowerCenter, we can install the forms from Google and other vendors, but in the case of AWS Glue, we can only use AWS.""Currently, it supports only two languages in the background: Python and Scala. From our customization point of view, it would be helpful if it can also support Java in the background.""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 monitoring is not that good.""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.""There should be more connectors for different databases.""Overall, I consider the technical support to be fine, although the response time could be faster in certain cases."

More AWS Glue Cons →

"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.""We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package.""It's a legacy tool, that is nearing the end of its useful life.""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.""Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster.""The solution could improve on integrating with other types of data sources.""I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors.""It would be nice if you could run SSIS on other environments besides Windows."

More SSIS Cons →

Pricing and Cost Advice
  • "It is not expensive. AWS Glue works on the serverless architecture. We get charged for the time the server is up. For our use case, we have to use it once in a day, and it is not expensive for us."
  • "Its price is good. We pay as we go or based on the usage, which is a good thing for us because it is simple to forecast for the tool. It is good in terms of the financial planning of the company, and it is a good way to estimate the cost. It is also simple for our clients. In my opinion, it is one of the best tools in the market for ETL processes because of the fact that you pay as you use, which separates it from other big tools such as PowerCenter, Pentaho Data Integration, and Talend."
  • "Technical support is a paid service, and which subscription you have is dependent on that. You must pay one of them, and it ranges from $15,000 to $25,000 per year."
  • "This solution is affordable and there is an option to pay for the solution based on your usage."
  • "AWS Glue is quite costly, especially for small organizations."
  • "AWS Glue uses a pay-as-you-go approach which is helpful. The price of the overall solution is low and is a great advantage."
  • More AWS Glue Pricing and Cost Advice →

  • "It would be beneficial if the solution had a less costly cloud offering."
  • "Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
  • "We have an enterprise license for this solution."
  • "It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
  • "All of my clients have this product included as part of their Microsoft license."
  • "SSIS is a cheaper option compared to the cost of other ETL tools."
  • "Our license with SSIS is annual."
  • "t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."
  • More SSIS Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    633,572 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:AWS Glue and Azure Data factory for ELT best performance cloud services.
    Top Answer:We reviewed AWS Glue before choosing Talend Open Studio. AWS Glue is the managed ETL (extract, transform, and load) from Amazon Web Services. AWS Glue enables AWS users to create and manage jobs in… more »
    Top Answer:The facility to integrate with S3 and the possibility to use Jupyter Notebook inside the pipeline are the most valuable features.
    Top Answer:SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free… more »
    Top Answer:What is the OLAP that you are using? Hosted in Cloud or on-premise?  The target DB should have its tool to extract data.
    Top Answer:Like most Microsoft products, SSIS is user-friendly and easy to use.
    Ranking
    2nd
    Views
    19,150
    Comparisons
    15,466
    Reviews
    10
    Average Words per Review
    472
    Rating
    8.1
    3rd
    Views
    26,385
    Comparisons
    20,452
    Reviews
    16
    Average Words per Review
    494
    Rating
    7.9
    Comparisons
    Also Known As
    SQL Server Integration Services
    Learn More
    Overview

    AWS Glue is a fully managed extract, transform, and load (ETL) service that makes it easy for customers to prepare and load their data for analytics. You can create and run an ETL job with a few clicks in the AWS Management Console. You simply point AWS Glue to your data stored on AWS, and AWS Glue discovers your data and stores the associated metadata (e.g. table definition and schema) in the AWS Glue Data Catalog. Once cataloged, your data is immediately searchable, queryable, and available for ETL.

    SQL Server Integration Services (SSIS) is a Microsoft platform designed to build enterprise-level data integration and data transformation solutions. Users now have the ability to solve intricate business queries by downloading and copying files, cleansing and mining data, loading data warehouses, and managing SQL Server objects and data through Integration Services. SSIS is a component of the Microsoft SQL Server data software used for many data migration tasks.

    SSIS loads data into one or more destinations by extracting and transforming data from a wide variety of sources such as XML data files, flat files, and relational data sources.

    Integration Services include:

    • An SSIS catalog database to manage, store, and run packages.
    • An ample set of built-in transformations and tasks.
    • Graphical tools for building packages.

    Create packages programmatically and code custom tasks through programming the extensive Integration Services. With graphical Integration Services, you can create solutions without writing any code.

    Benefits of SSIS

    There are many benefits of SSIS, such as:

    • Solve complex business problems - encrypt files with SSIS and send them to various network locations.

    • Migration of DTS packages to SSIS - users can migrate DTS packages to SSIS while choosing to run DTS packages using DTS runtime or incorporate DTS packages into SSIS.

    • Development of ETL processes - Microsoft’s SSIS packages provide the ability to extract, transform, and load data into data warehouses. This service takes data from various sources, like CSV files, XML files, flat files, and relational data sources and transforms and loads them to their destinations.

    • Data migration from other databases - with Integrations Services, users can transform data to make sure it complies with the rules of the database they are migrating to.

    • Managing and automating SQL server objects - SSIS packages can manage and automate SQL server objects which will help save you time and resources.

    Reviews from Real Users

    The SSIS platform stands out among its competitors for a variety of reasons. Two major ones are its debugging capabilities during data flow execution and its easy connectivity with other Microsoft tools.

    Muhammad J., a senior manager software developer at Techlogix, notes, "The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."

    Ismail L., a data engineer at a tech service company, writes, "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."

    Offer
    Learn more about AWS Glue
    Learn more about SSIS
    Sample Customers
    bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
    PKP Energetyka, UniCredit Bank, Mostar, waldwasser, Ashok leyland, Florida Atlantic University, Stadt Frankfurt am Main
    Top Industries
    VISITORS READING REVIEWS
    Computer Software Company18%
    Financial Services Firm13%
    Insurance Company8%
    Media Company8%
    REVIEWERS
    Financial Services Firm22%
    Healthcare Company8%
    Government8%
    Manufacturing Company8%
    VISITORS READING REVIEWS
    Computer Software Company17%
    Financial Services Firm15%
    Comms Service Provider11%
    Insurance Company7%
    Company Size
    REVIEWERS
    Small Business17%
    Midsize Enterprise25%
    Large Enterprise58%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise11%
    Large Enterprise75%
    REVIEWERS
    Small Business30%
    Midsize Enterprise21%
    Large Enterprise49%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise14%
    Large Enterprise69%
    Buyer's Guide
    AWS Glue vs. SSIS
    August 2022
    Find out what your peers are saying about AWS Glue vs. SSIS and other solutions. Updated: August 2022.
    633,572 professionals have used our research since 2012.

    AWS Glue is ranked 2nd in Cloud Data Integration with 10 reviews while SSIS is ranked 3rd in Data Integration Tools with 21 reviews. AWS Glue is rated 8.2, while SSIS is rated 7.8. The top reviewer of AWS Glue writes "Easy to perform ETL on multiple data sources, and easy to use after you learn it". On the other hand, the top reviewer of SSIS writes "SSIS 2016 - The good, the bad, and the ugly". AWS Glue is most compared with AWS Database Migration Service, Informatica PowerCenter, Talend Open Studio, Informatica Cloud Data Integration and IBM InfoSphere DataStage, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), IBM InfoSphere DataStage and Alteryx Designer. See our AWS Glue vs. SSIS report.

    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.