Matillion ETL vs SSIS comparison

Cancel
You must select at least 2 products to compare!
Matillion Logo
3,495 views|2,369 comparisons
Microsoft Logo
Read 68 SSIS reviews
19,950 views|16,201 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Matillion ETL and SSIS based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Matillion ETL vs. SSIS Report (Updated: March 2024).
765,234 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
"It has good integrations with Amazon Redshift and other AWS services.""We allow non-technical people to use Matillion to load data into our data warehouse for reporting. Thus, it is easy enough to use that we don't always have to get a technical person involved in setting up a data movement (ETL).""The most valuable feature of Matillion ETL is its user-friendly graphical interface.""The simplicity of this tool is nice. It has a good graphical user interface. You can also do a lot of generic stuff in the tool. If there is good connectivity to a cloud database, such as Snowflake, and you can have a lot of Snowflake functionality in the tool.""It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth""It has improved the costs of managing my customer’s data.""The most valuable feature of Matillion ETL is the ETL. The solution is open-source which provides advantages, such as good performance and high efficiency. Additionally, it supports three data types which eliminates predefining the data, and we can write script models in Python.""It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."

More Matillion ETL Pros →

"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools.""Overall, it's a good product.""The script component is very powerful, things that you cannot normally do, is feasible through C#.""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.""It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft.""It is easy to set up the product.""It's a competent product.""SSIS integrates well with SQL servers and Microsoft products."

More SSIS Pros →

Cons
"Matillion’s on-premises capabilities don’t allow you to build something customized.""Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion.""Ideally, I would like it to integrate with Secrets Manager as well as the AWS.""The product must enhance its near-real-time data capture feature.""While the UI is good, it could be improved in its efficiency and made easier to use.""The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine.""The cost of the solution is high and could be reduced.""The tool's lineage is very weak."

More Matillion ETL Cons →

"The performance of SSIS could improve when comparing it to Oracle Database.""I would like to see more standard components out of the box, such as SFTP, and Data Compression components.""We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse.""Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included.""Future releases should improve the data lineage, as it currently is not good.""There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon.""The performance of this solution is not as good as other tools in the market.""I would like to see better technical documentation because many times information is missing."

More SSIS Cons →

Pricing and Cost Advice
  • "I have heard from my manager and other higher ups, "This product is cheaper than other things on the market," and they have done the research."
  • "It is cost-effective. Based on our use case, it's efficient and cheap. It saves a lot of money and our upfront costs are less."
  • "The prices needs to be lower."
  • "It was very easy to purchase through the AWS Marketplace, but it was also expensive."
  • "Purchasing it through the AWS Marketplace is pretty convenient. There is a little bit of back and forth in terms of the licensing based on the machine size, but it seems to have worked out well. it is convenient to have it all as part of our AWS billing."
  • "It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."
  • "The AWS pricing and licensing are a cost-effective solution for data integration needs."
  • "It was procured through the AWS Marketplace because it keeps things simple. They offer retail-like checkout and bill through your existing Amazon Web Services account."
  • More Matillion ETL Pricing and Cost Advice →

  • "This solution has provided an inexpensive tool, and it is easy to find experienced developers."
  • "My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
  • "This solution is included with the MSSQL server package."
  • "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."
  • More SSIS Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    765,234 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations There are many third-party vendors offering ETL solutions, but two of the most popular are PowerCenter Informatica and Microsoft SSIS (SQL Server Integration Services). Each technology has its advantages but there are also similarities on how they carry out the extract-transform-load processes and only differ in terminologies. If you’re in the process of choosing ETL tools and PowerCenter Informatica and Microsoft SSIS made it to your shortlist, here is a short comparative discussion detailing the differences between the two, as well as their benefits. Package Configuration Most enterprise data integration projects would require the capacity to develop a solution in one platform and test and deploy it in a separate environment without having to manually change the established workflow. In order to achieve this seamless movement between two environments, your ETL technology should allow the dynamic update of the project’s properties using the content or a parameter file or configuration. Both Informatica and SSIS support this functionality using different methodologies. In Informatica, every session can have more than one source and one or more destination connections. There are… Read more →
    Questions from the Community
    Top Answer:It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth
    Top Answer:We pay $5.40 per EC2 running hour, and we can reduce costs by stopping and starting the EC2 instances strategically. For instance, in our production environment, we run it for sixteen hours a day… more »
    Top Answer:There's room for improvement in how it handles data streaming capabilities. Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes… more »
    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:I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows.
    Top Answer:The pricing of SSIS is generally considered reasonable in comparison to other data integration tools in the market. In terms of licensing, I find Microsoft's pricing policy generally favorable… more »
    Ranking
    4th
    Views
    3,495
    Comparisons
    2,369
    Reviews
    11
    Average Words per Review
    701
    Rating
    8.6
    2nd
    out of 94 in Data Integration
    Views
    19,950
    Comparisons
    16,201
    Reviews
    33
    Average Words per Review
    471
    Rating
    7.7
    Comparisons
    Also Known As
    Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
    SQL Server Integration Services
    Learn More
    Overview

    Matillion ETL is a powerful tool for extracting, transforming, and loading large amounts of data from various sources into cloud data warehouses like Snowflake. Its ability to load data dynamically and efficiently using metadata is a standout feature, as is its open-source ETL with good performance and high efficiency. 

    The solution has a graphical interface for jobs, is easily adjustable and extensible, and allows for scheduling and error reporting. Matillion ETL has helped organizations move to a cloud-based solution, bridge the gap between on-premises and on-cloud, and perform complex migration projects.

    SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

    Sample Customers
    Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc
    1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
    Top Industries
    REVIEWERS
    Manufacturing Company36%
    Financial Services Firm36%
    Healthcare Company9%
    Computer Software Company9%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Financial Services Firm14%
    Government8%
    Manufacturing Company8%
    REVIEWERS
    Financial Services Firm23%
    Healthcare Company8%
    Computer Software Company8%
    Manufacturing Company8%
    VISITORS READING REVIEWS
    Financial Services Firm17%
    Computer Software Company12%
    Government7%
    Healthcare Company6%
    Company Size
    REVIEWERS
    Small Business23%
    Midsize Enterprise36%
    Large Enterprise41%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise68%
    REVIEWERS
    Small Business27%
    Midsize Enterprise18%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    Buyer's Guide
    Matillion ETL vs. SSIS
    March 2024
    Find out what your peers are saying about Matillion ETL vs. SSIS and other solutions. Updated: March 2024.
    765,234 professionals have used our research since 2012.

    Matillion ETL is ranked 4th in Cloud Data Integration with 22 reviews while SSIS is ranked 2nd in Data Integration with 68 reviews. Matillion ETL is rated 8.6, while SSIS is rated 7.8. The top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Matillion ETL is most compared with Azure Data Factory, Snowflake, AWS Glue, Informatica PowerCenter and Informatica Cloud Data Integration, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), IBM InfoSphere DataStage and FME. See our Matillion ETL 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.