What users are saying about

AWS Glue vs SSIS

AWS Glue
14 Ratings
SSIS
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
255 Ratings

AWS Glue

14 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.1 out of 100

Based on 14 reviews and ratings

SSIS

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
255 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Based on 255 reviews and ratings

Feature Set Ratings

    Data Source Connection

    AWS Glue

    Feature Set Not Supported
    N/A
    7.5

    SSIS

    75%
    SQL Server Integration Services ranks higher in 2/2 features
    SQL Server Integration Services ranks higher in 2/2 features

    Connect to traditional data sources

    N/A
    0 Ratings
    8.7
    87%
    56 Ratings

    Connecto to Big Data and NoSQL

    N/A
    0 Ratings
    6.3
    63%
    43 Ratings

    Data Transformations

    AWS Glue

    Feature Set Not Supported
    N/A
    8.3

    SSIS

    83%
    SQL Server Integration Services ranks higher in 2/2 features
    SQL Server Integration Services ranks higher in 2/2 features

    Simple transformations

    N/A
    0 Ratings
    8.8
    88%
    56 Ratings

    Complex transformations

    N/A
    0 Ratings
    7.7
    77%
    55 Ratings

    Data Modeling

    AWS Glue

    Feature Set Not Supported
    N/A
    7.6

    SSIS

    76%
    SQL Server Integration Services ranks higher in 6/6 features
    SQL Server Integration Services ranks higher in 6/6 features

    Data model creation

    N/A
    0 Ratings
    8.6
    86%
    30 Ratings

    Metadata management

    N/A
    0 Ratings
    7.5
    75%
    36 Ratings

    Business rules and workflow

    N/A
    0 Ratings
    7.8
    78%
    45 Ratings

    Collaboration

    N/A
    0 Ratings
    7.5
    75%
    41 Ratings

    Testing and debugging

    N/A
    0 Ratings
    6.9
    69%
    51 Ratings

    feature 1

    N/A
    0 Ratings
    7.3
    73%
    4 Ratings

    Data Governance

    AWS Glue

    Feature Set Not Supported
    N/A
    7.3

    SSIS

    73%
    SQL Server Integration Services ranks higher in 2/2 features
    SQL Server Integration Services ranks higher in 2/2 features

    Integration with data quality tools

    N/A
    0 Ratings
    8.0
    80%
    39 Ratings

    Integration with MDM tools

    N/A
    0 Ratings
    6.6
    66%
    39 Ratings

    Attribute Ratings

    • AWS Glue is rated higher in 1 area: Likelihood to Recommend
    • SQL Server Integration Services is rated higher in 1 area: Support Rating

    Likelihood to Recommend

    9.0

    AWS Glue

    90%
    1 Rating
    8.2

    SSIS

    82%
    56 Ratings

    Likelihood to Renew

    AWS Glue

    N/A
    0 Ratings
    10.0

    SSIS

    100%
    3 Ratings

    Usability

    AWS Glue

    N/A
    0 Ratings
    9.3

    SSIS

    93%
    8 Ratings

    Performance

    AWS Glue

    N/A
    0 Ratings
    8.8

    SSIS

    88%
    12 Ratings

    Support Rating

    7.0

    AWS Glue

    70%
    2 Ratings
    8.2

    SSIS

    82%
    14 Ratings

    Implementation Rating

    AWS Glue

    N/A
    0 Ratings
    10.0

    SSIS

    100%
    2 Ratings

    Likelihood to Recommend

    AWS Glue

    AWS glue is best if your organization is dealing with large and sensitive data like medical record. Its comes with scheduler and easy deployment for AWS user. The data catalog keeps the reference of the data in a well-structured format. If you are already part of the AWS services, then AWS Glue is the best choice; otherwise, it's not a simple one for deployment.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 1 answers on this topic

    SSIS

    There are always alternative options available to meet the demand for integration. In my opinion, SQL Server Integration Services has a wide variety of capabilities that makes it a very versatile tool for developing dependable integration strategies. When determining which tools to utilize, vendor interfaces may play a significant role, and technologies like PowerShell have been used by colleagues to aid in this decision. For even more user-friendliness, our SSIS solution additionally makes use of a third-party plugin.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 56 answers on this topic

    Pros

    AWS Glue

    • Very quick for ETL job.
    • UI as well Command Interface with very few steps to create and schedule ETL Job.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 1 answers on this topic

    SSIS

    • Standard ETL use cases for daily loads
    • Loading incoming data from Vendors which is placed on FTP and adding them to the SQL Warehouse
    • Creating outgoing data files and writing them to Vendor FTPs
    • Easy Active Directory integration for seamless connections to SQL Server
    • CI/CD by hosting the code on visualstudio.com

    Read full review

    Vishal Shah | TrustRadius Reviewer
    Vishal Shah
    View all 56 answers on this topic

    Cons

    AWS Glue

    • Sample Code is very basic and not available in most of the scenario.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 1 answers on this topic

    SSIS

    • Connection managers for online data sources can be tricky to configure.
    • Performance tuning is an art form and trialing different data flow task options can be cumbersome. SSIS can do a better job of providing performance data including historical for monitoring.
    • Mapping destination using OLE DB command is difficult as destination columns are unnamed.
    • Excel or flat file connections are limited by version and type.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 56 answers on this topic

    Pricing Details

    AWS Glue

    General

    Free Trial
    —
    Free/Freemium Version
    —
    Premium Consulting/Integration Services
    —
    Entry-level set up fee?
    No

    Starting Price

    $0.44 billed per second, 1 minute minimum

    AWS Glue Editions & Modules

    Edition
    per DPU-Hour$0.441
    1. billed per second, 1 minute minimum
    Additional Pricing Details
    —

    SSIS

    General

    Free Trial
    —
    Free/Freemium Version
    —
    Premium Consulting/Integration Services
    —
    Entry-level set up fee?
    No

    Starting Price

    —

    SSIS Editions & Modules

    —
    Additional Pricing Details
    —

    Likelihood to Renew

    AWS Glue

    No score
    No answers yet
    No answers on this topic

    SSIS

    SSIS 10.0
    Based on 3 answers
    Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure

    Read full review

    Luca Campanelli | TrustRadius Reviewer
    Luca Campanelli
    View all 3 answers on this topic

    Usability

    AWS Glue

    No score
    No answers yet
    No answers on this topic

    SSIS

    SSIS 9.3
    Based on 8 answers
    SSIS is a great tool for most ETL needs. It has the 90% (or more) use cases covered and even in many of the use cases where it is not ideal SSIS can be extended via a .NET language to do the job well in a supportable way for almost any performance workload.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 8 answers on this topic

    Performance

    AWS Glue

    No score
    No answers yet
    No answers on this topic

    SSIS

    SSIS 8.8
    Based on 12 answers
    SQL Server Integration Services performance is dependent directly upon the resources provided to the system. In our environment, we allocated 6 nodes of 4 CPUs, 64GB each, running in parallel. Unfortunately, we had to ramp-up to such a robust environment to get the performance to where we needed it. Most of the reports are completed in a reasonable timeframe. However, in the case of slow running reports, it is often difficult if not impossible to cancel the report without killing the report instance or stopping the service.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 12 answers on this topic

    Support Rating

    AWS Glue

    AWS Glue 7.0
    Based on 2 answers
    Amazon responds in good time once the ticket has been generated but needs to generate tickets frequent because very few sample codes are available, and it's not cover all the scenarios.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 2 answers on this topic

    SSIS

    SSIS 8.2
    Based on 14 answers
    The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.

    Read full review

    Chris Morgan | TrustRadius Reviewer
    Chris Morgan
    View all 14 answers on this topic

    Implementation Rating

    AWS Glue

    No score
    No answers yet
    No answers on this topic

    SSIS

    SSIS 10.0
    Based on 2 answers
    The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools

    Read full review

    Luca Campanelli | TrustRadius Reviewer
    Luca Campanelli
    View all 2 answers on this topic

    Alternatives Considered

    AWS Glue

    We are already in AWS services, so AWS glue is the first choice for us. But for the comparison of ETL job making and process time, it's way faster for other services.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 1 answers on this topic

    SSIS

    I had nothing to do with the choice or install. I assume it was made because it's easy to integrate with our SQL Server environment and free. I'm not sure of any other enterprise level solution that would solve this problem, but I would likely have approached it with traditional scripting. Comparably free, but my own familiarity with trad scripts would be my final deciding factor. Perhaps with some further training on SSIS I would have a different answer.

    Read full review

    Sean Ford | TrustRadius Reviewer
    Sean Ford
    View all 56 answers on this topic

    Return on Investment

    AWS Glue

    • Helps to leverage the data in realtime.
    • Leads to quick and clear business decision making.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 1 answers on this topic

    SSIS

    • Data integrity across various products allows unify certain processes inside the organization and save funds by reducing human labour factor.
    • Automated data unification allows us plan our inputs better and reduce over-warehousing by overbuying
    • The employee number, responsible for data management was reduced from 4 to 1 person

    Read full review

    Vladimir Salnikov | TrustRadius Reviewer
    Vladimir Salnikov
    View all 56 answers on this topic

    Add comparison