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

Matillion Data Productivity Cloud vs SSIS comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 31, 2025

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
Matillion Data Productivity Cloud users experience quick ROI, 15%-20% cost reduction, transparent billing, and efficient cloud-based operations across sectors.
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 Data Productivity Cloud offers responsive support, quick resolutions, knowledgeable staff, and proactive communication, with room for speed improvement.
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's seamless cloud integration enhances scalability, though heavy Python use may pose challenges, with recent updates improving efficiency.
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 Data Productivity Cloud is highly stable, rated nine out of ten, with responsive support and reliable performance.
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

Matillion Data Productivity Cloud requires updates for API, integrations, UI, performance, scalability, efficiency, and comprehensive documentation enhancements.
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 Data Productivity Cloud offers flexible, competitive pricing suitable for various team sizes, with cost-effective options for extensive use.
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 Data Productivity Cloud streamlines ETL with intuitive interface, diverse data integration, and automation, enhancing efficiency and agility.
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 Data Productivity...
Average Rating
8.4
Reviews Sentiment
7.4
Number of Reviews
26
Ranking in other categories
Cloud Data Integration (6th)
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.
844,944 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 Data Productivity Cloud vs. SSIS and other solutions. Updated: March 2025.
844,944 professionals have used our research since 2012.