Try our new research platform with insights from 80,000+ expert users

Matillion ETL vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
7.3
Users achieve quick ROI with Matillion ETL, reducing costs and simplifying billing by consolidating platforms and shutting down legacy servers.
Sentiment score
7.3
SSIS provides cost-effective data management efficiency, delivering ROI without extra costs apart from the SQL Server license.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
 

Customer Service

Sentiment score
7.5
Matillion offers excellent customer service with fast, knowledgeable support and comprehensive resources, though speed improvements are possible.
Sentiment score
6.0
Many users prefer online resources over Microsoft's good but occasionally slow and expensive technical support for critical issues.
 

Scalability Issues

Sentiment score
7.7
Matillion ETL is praised for scalable cloud integration and efficient data transformation, though Python components may need monitoring.
Sentiment score
6.8
SSIS is moderately scalable, better for batch processing, with varied performance depending on infrastructure and implementation challenges.
 

Stability Issues

Sentiment score
7.8
Matillion ETL is stable, reliable, and well-supported, though issues may occur on smaller machines or with intensive tasks.
Sentiment score
7.4
SSIS is a reliable, mature tool with minor performance concerns, praised for stability in diverse projects despite occasional issues.
It processes large volumes of data quickly.
 

Room For Improvement

Users request API updates, better documentation, enhanced performance, UI improvements, and multi-environment support with cost and scalability concerns.
SSIS requires enhancements in error logging, real-time processing, and scalability while depending on external tools increases costs.
SSIS has a difficult learning curve when dealing with complex transformations.
 

Setup Cost

Matillion ETL offers competitive, flexible pay-as-you-go pricing on AWS, with discounts and no permanent commitments.
SSIS is cost-effective for enterprises, bundled with SQL Server, but add-ons can increase costs; overall valued for integration.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
 

Valuable Features

Matillion ETL offers efficient data integration with user-friendly interface, AWS compatibility, and features like scalability and CDC.
SSIS offers user-friendly, cost-effective ETL solutions with C# scripting, cloud deployment, and extensive support, enhancing data integration and automation.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
 

Categories and Ranking

Matillion ETL
Average Rating
8.4
Reviews Sentiment
7.4
Number of Reviews
26
Ranking in other categories
Cloud Data Integration (5th)
SSIS
Average Rating
7.6
Reviews Sentiment
6.8
Number of Reviews
73
Ranking in other categories
Data Integration (4th)
 

Featured Reviews

Jacques Du Preez - PeerSpot reviewer
Offers good user interface and easy to navigate
Our experience is mainly around using Snowflake Data Cloud with Matillion. And the two of them combined, offer superior performance and price point benefits. Using them together is very efficient because Matillion's processing and Snowflake's own scalability and consumption based on pushing down code work well together. They are very efficient. We've used Azure Data Factory (ADF) for integration. So that's an alternative, depending on customer choice for the integration. And then on AWS, a few of the other services, like Terraform, and S3 storage, and that's about it. It's on a case-by-case basis. If they've chosen ADF as a technology, then we implement using that choice.
Sakiru Dosumu - PeerSpot reviewer
Its ability to transform and transport data is extremely valuable
he ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs.
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
842,592 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
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…
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
15%
Manufacturing Company
9%
Energy/Utilities Company
5%
Financial Services Firm
19%
Computer Software Company
12%
Government
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Matillion ETL?
The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.
What is your experience regarding pricing and costs for Matillion ETL?
The solution's pricing is not based on the licensing cost but on the running hours when the Matillion instance is up and running. Its pricing model is different from the traditional pricing models ...
What needs improvement with Matillion ETL?
Depending on the use case, the solution's pricing could be improved. Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems.
Which is better - SSIS or Informatica PowerCenter?
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 compo...
What do you like most about SSIS?
The product's deployment phase is easy.
What is your experience regarding pricing and costs for SSIS?
Utilizing SSIS involves no extra charges beyond the SQL Server license. It's an economical choice for my clients.
 

Also Known As

Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
SQL Server Integration Services
 

Overview

 

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
Find out what your peers are saying about Matillion ETL vs. SSIS and other solutions. Updated: March 2025.
842,592 professionals have used our research since 2012.