Matillion ETL vs SSIS comparison

Matillion and Microsoft are both solutions in the Cloud Data Integration category. Additionally, 96% of Matillion users are willing to recommend the solution, compared to 79% of Microsoft users who would recommend it.

Matillion ETL

Read 26 Matillion ETL reviews

1,941 Views
1,340 Comparison Views

96% willing to recommend

SSIS

Read 72 SSIS reviews

13,383 Views
10,644 Comparison Views

79% willing to recommend

Matillion ETL

SSIS

Comparison Buyer's Guide

Download the report

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: January 2025).

Buyer's Guide

Matillion ETL vs. SSIS

January 2025

Download the complete report

Helped 831,020 peers since 2012

Review summaries and opinions

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

Categories and Ranking

Matillion ETL

Average Rating

8.4

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

Cloud Data Integration (5th)

SSIS

Average Rating

7.6

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

Data Integration (4th)

Featured Reviews

Tomáš Hronek

Data Engineer at Merck

Used for wrangling or transforming data from sources like S3 and Databricks

I use Matillion ETL for wrangling or transforming data from sources like S3 and Databricks The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation. Sometimes, we have issues with the solution's stability and need to restart it for…

Read full review

BobAmy

Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.

Robust and does a good job of handling overload conditions

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. I believe there are ways to build a model and set variables so that it can be a generic process. In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded. I believe they should add some features that help to create the code using a model. This would allow for continuous improvement of the model uses and easy replication of all the different programs that use the model.

Read full review

Quotes from Members

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

Pros

"The tool's middle-dimensional structure significantly simplifies obtaining the right data at the appropriate level. This feature makes deploying our applications easier since we utilize a single source without publishing data from various sources."

"It is pretty user-friendly, even for people who aren't super technical."

"Matillion ETL has great Git integration that is perfect and convenient to use."

"It has good integrations with Amazon Redshift and other AWS services."

"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."

"The loading of data is the most valuable feature of Matillion ETL."

"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines."

"It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"

More Matillion ETL pros

"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."

"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."

"Overall, it's a good product."

"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."

"It is easy to set up the solution."

"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."

"It's already very user-friendly and has a good dashboard."

"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."

More SSIS pros

Cons

"Performance can be improved for efficiency, and it can be made faster."

"In the next release, we would like to have connections to more databases."

"Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level."

"The tool's lineage is very weak."

"The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."

"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."

"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."

"It can have multi-environment support. We should be able to deploy it in different environments. Its integration with SAP connection is not so nice, which should be improved. It can also support an on-prem database."

More Matillion ETL cons

"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."

"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."

"Integration and the user interface are areas with certain shortcomings that require some improvements."

"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."

"Options for scaling could be improved."

"I would like to see better technical documentation because many times information is missing."

"SSIS has room for improvement, mainly because the overall package can be buggy. It often locks up, requiring a restart, which is annoying. However, since it's free, we tolerate these performance issues. I'd like to see better debugging tools in future releases and improvements in API calls; It would be helpful if SSIS had a built-in API engine so we wouldn't have to rely solely on database connections."

"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."

More SSIS cons

Pricing and Cost Advice

"Matillion ETL has a pay-as-you-go pricing model of a few dollars per hour of runtime."

"The solution is very cheap. You're paying $2.50 an hour and if you set your service up, which you can do, you're not getting charged. Currently, our ETL process is just an overnight process that runs for about an hour. I can start and stop my server just for an hour if I want to and spent $2.50 a day for an ETL solution. There are no additional costs."

"The solution's pricing is not based on the licensing cost but on the running hours when the Matillion instance is up and running."

"It was very easy to purchase through the AWS Marketplace, but it was also expensive."

"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 not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."

"The price of Matillion ETL is reasonable."

"The absence of licensing commitments makes it easy to experiment with the tool, and if we decide it's not suitable, we can simply stop the ETL instance and cease incurring charges."

More Matillion ETL pricing and cost advice

"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."

"The solution comes free of cost."

"This solution is included with the MSSQL server package."

"All of my clients have this product included as part of their Microsoft license."

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

"It would be beneficial if the solution had a less costly cloud offering."

More SSIS pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.

See recommendations

831,020 professionals have used our research since 2012.

Comparison Review

it_user90069

BI Expert at a healthcare company with 1,001-5,000 employees

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…

Read full review

Top Industries

By visitors reading reviews

Financial Services Firm

17%

Computer Software Company

14%

Manufacturing Company

Government

Financial Services Firm

18%

Computer Software Company

12%

Government

Manufacturing Company

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.

See all answers

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 ...

See all answers

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.

See all answers

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...

See all answers

What do you like most about SSIS?

The product's deployment phase is easy.

See all answers

What is your experience regarding pricing and costs for SSIS?

The solution comes free of cost.

See all answers

Comparisons

Azure Data Factory vs Matillion ETL

Compared 14% of the time

AWS Glue vs Matillion ETL

Compared 10% of the time

Snowflake vs Matillion ETL

Compared 8% of the time

Informatica PowerCenter vs Matillion ETL

Compared 6% of the time

SnapLogic vs Matillion ETL

Compared 5% of the time

More Matillion ETL Competitors

Informatica PowerCenter vs SSIS

Compared 22% of the time

Talend Open Studio vs SSIS

Compared 12% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 8% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Ab Initio Co>Operating System vs SSIS

Compared 2% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Matillion ETL

December 2024

Download Matillion ETL product report

Buyer's Guide

SSIS

December 2024

Download SSIS product report

Also Known As

Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery

SQL Server Integration Services

Learn More

Matillion

Microsoft

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

Buyer's Guide

Matillion ETL vs. SSIS

January 2025

Free Report: Matillion ETL vs. SSIS

Find out what your peers are saying about Matillion ETL vs. SSIS and other solutions. Updated: January 2025.

DOWNLOAD NOW

831,020 professionals have used our research since 2012.

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.