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,761 Views
1,247 Comparison Views

96% willing to recommend

SSIS

Read 72 SSIS reviews

13,122 Views
10,210 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 838,533 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

Sunny Kumar

Specialist Programmer at Infosys

High efficiency, performs well, and price well

The decision to use Matillion ETL depends on the specific requirements. If the requirements can be met without Matillion ETL in a short amount of time, then using it would be unnecessary. However, if dealing with large data sets and frequent data migrations to and from the cloud, then Matillion ETL would be a suitable choice. I have a lot of experience in this field of data and I was able to achieve results with Matillion ETL that I was not able to with the traditional approach. The solution is helpful for large amounts of data. I rate Matillion ETL an eight out of ten.

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

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

"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."

"The technical support treats us well. They already have a support portal, and they are responsive, which helps."

"It's been able to do everything we require."

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

"The most valuable feature of Matillion ETL is its user-friendly graphical interface."

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

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

More Matillion ETL pros

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

"The technical support is very good."

"The data reader is the most valuable feature."

"The performance is good."

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

"It is easy to set up. The deployment is also very quick."

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."

"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."

More SSIS pros

Cons

"I am looking forward to seeing the expansion of the source range for their data loader product."

"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."

"Unlike Snowflake which automatically takes care of upgrading to the latest version and includes additional features, with Matillion ETL we need to do this ourselves."

"The cost of the solution is high and could be reduced."

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

"While the UI is good, it could be improved in its efficiency and made easier to use."

"It needs integration with more data sources."

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

More Matillion ETL cons

"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."

"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."

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

"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."

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

"We have a stability problem because when something works, it works one time. The next time, it doesn't work."

"Future releases should improve the data lineage, as it currently is not good."

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

More SSIS cons

Pricing and Cost Advice

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

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

"A rough estimation of the cost is around 20,000 dollars a month, however, this is dependent on the machine used and how Matillion ETL is used."

"Its price depends on what you expect. You pay on a monthly basis, but there is a possibility to have special contracts depending on the installation."

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

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

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

"The prices needs to be lower."

More Matillion ETL pricing and cost advice

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

"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."

"We have an enterprise license for this solution."

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

"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."

"We purchased the standard edition of SQL Server and SSIS came with it free of charge."

"The solution is available at a lesser price than that of Informatica."

"SSIS is fairly well-priced - I would rate it at four out of five."

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

838,533 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

15%

Manufacturing Company

Healthcare Company

Financial Services Firm

18%

Computer Software Company

12%

Government

Healthcare 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 13% 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

IBM InfoSphere DataStage vs Matillion ETL

Compared 5% of the time

More Matillion ETL Competitors

Informatica PowerCenter vs SSIS

Compared 21% of the time

Talend Open Studio vs SSIS

Compared 13% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% 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

February 2025

Download Matillion ETL product report

Buyer's Guide

SSIS

January 2025

Download SSIS product report

Also Known As

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

SQL Server Integration Services

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.

Matillion

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.

Microsoft

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

838,533 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.