Matillion vs. SQL Server Integration Services

Matillion

219 Reviews and Ratings

SQL Server Integration Services

259 Reviews and Ratings

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
Matillion	Score8.1 out of 10	N/A	Matillion is a data pipeline platform used to build and manage pipelines. Matillion empowers data teams with no-code and AI capabilities to be more productive, integrating data wherever it lives and delivering data that’s ready for AI and analytics.	$2.50 Pay as you go per user
SSIS	Score6.5 out of 10	N/A	Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.	N/A

Pricing

Matillion

SSIS

Developer: For Individuals: $2.50/credit
Pay as you go per user
Basic: $1000
per month 500 prepaid credits (additional credits: $2.18/credit)
Advanced: $2000
per month 750 prepaid credits (additional credits: $2.73/credit)
Enterprise: Request a Quote

No answers on this topic

Pricing Offerings
Matillion	SSIS
Free Trial
Yes	No
Free/Freemium Version
No	No
Premium Consulting/Integration Services
Yes	No

No setup fee

No setup fee

Billed directly via cloud marketplace on an hourly basis, with annual subscriptions available depending on the customer's cloud data warehouse provider.

—

Community Pulse
Key User Insights
	Matillion	SSIS
Considered Both Products	Matillion Steve Bramblet Senior Data Specialist in Engineering at Lime Intelligence (Information Technology & Services, 11-50 employees) Chose Matillion The only other ETL tool I've used was SSIS. At first I thought Matillion seemed "kiddish" after using the polished Microsoft tool but now I think Matillion is easier and can do much more as it has so many built-in connectors etc. We selected Matillion at our job because of … Incentivized Helpful? Dan Zielinski Senior Database Architect in Information Technology at InnovAge (Hospital & Health Care, 1001-5000 employees) Chose Matillion We selected Matillion primarily because of it's ability to connect to numerous data sources and easily create transformation jobs. While Fivetran does a better job managing and examining deltas, it is not easy to use and is very non user friendly. SSIS was not a good fit for … Incentivized Helpful? Matthew Burr Sr. Data Engineer in Research & Development at HireVue (Information Technology and Services, 201-500 employees) Chose Matillion SQL Server Integration Services (SSIS) is built around the Microsoft ecosystem; we needed something that was either "ecosystem-agnostic" or focused on AWS, which Matillion is. SSIS has very limited ability to parameterize jobs/packages compared to Matillion, reducing the … Incentivized Helpful? Verified User Chose Matillion Matillion has more security and better version control features. The support of amazing with new connectors introduced every day. Incentivized Helpful? Verified User Chose Matillion The Matillion selection was not my decision. But I think it's a good enough choice. It is especially valuable that the team can learn Matillion easily and that the project can be understood by the entire team with the visual environment instead of complex ETLs. Incentivized Helpful? Verified User Chose Matillion Matillion is much easier to set up and easier to work for the team. Offers a lot more connections which are easier to set up. Environment variables make it easy to set up once and job creation is easy. We use Metadata tables to just loop through the list of tables that need to … Incentivized Helpful? Verified User Chose Matillion Matillion was chosen by Schibsted due to the seamless integration with Snowflake. The ease of use and fast workflow have made it an essential tool in our setup, and with the option to integrate nearly every data source there is, plus the ease of use, it really gives a lot of … Incentivized Helpful? Verified User Chose Matillion It's browser-based and well suited for snowflake and redshift DWH. Matillion is Python-scripting friendly. Incentivized Helpful? Verified User Chose Matillion Matillion is cloud-native, therefore it doesn't need virtual machines to set up. It is easier to use compared with some of them. It always does query pushdown, while other ones don't'. It is integrated with Snowflake, while other ETLs need to use workarounds in order to perform … Incentivized Helpful? Avishua Stein Business Intelligence Engineer in Information Technology at 3Q Digital (Marketing & Advertising, 201-500 employees) Chose Matillion Similar simple GUI but Matillion's is much cleaner, easier to manage and debug, and easier to connect to cloud databases. Matillion is also much faster. Incentivized Helpful? Arnob Bordoloi Data Analyst in Engineering at SquadLocker (Sporting Goods, 51-200 employees) Chose Matillion 1. Cloud Solution 2. Easy to create and manage ELT pipelines. 3. Works great with redshift databases. Incentivized Helpful? Verified User Chose Matillion Matillion ease of use and feature set along with integration capabilities and built in integrations are definitely a step ahead than the other tools and it provides the ability for us ti integrate with refshift, Snowflake and on premise data sources and hence becomes a … Incentivized Helpful? Verified User Chose Matillion Matillion seemed more robust than Fivetran and was easier to use. Incentivized Helpful? Brian Bickell Data Practice Lead in Engineering at InterWorks, Inc (Utilities, 201-500 employees) Chose Matillion Matillion is much easier to use than the other tools that I've worked with in the past and has a more complete forward-thinking cloud strategy. Legacy ETL tools struggle to make use of modern cloud data warehouse patterns. Incentivized Helpful? Verified User Chose Matillion Matillion works better in the AWS context Incentivized Helpful? Verified User Chose Matillion Being a fairly new player in the market, Matillion is coming up against some well-established names such as Pentaho and Talend. The primary benefit for our use case was the fact that Matillion is built specifically for Amazon Redshift. While Pentaho and Talend are more mature … Incentivized Helpful? Verified User Chose Matillion Overall from an ease of use and set up standpoint, it stacks up better than most of the other tools I've used. However, Matillion doesn't quite expand and scale up as well as the other solutions. Incentivized Helpful?	Microsoft Verified User Chose SSIS When looking to evaluate different options, we looked first to the experience and software we had in-house that would accomplish the job. When assessing alternatives outside we were looking for the tool that would offer the most flexibility. SSIS provided the most robust set of … Incentivized Helpful?
	Would buy again
	No answers on this topic	No answers on this topic
	Delivers good value for the price
	No answers on this topic	No answers on this topic
	Happy with the feature set
	No answers on this topic	No answers on this topic
	Lived up to sales and marketing promises
	No answers on this topic	No answers on this topic
	Implementation went as expected
No answers on this topic	No answers on this topic

Features

Matillion

SSIS

Comparison of Data Source Connection features of Matillion and SQL Server Integration Services
Feature	Matillion 8.5 131 Ratings	SQL Server Integration Services 7.5 53 Ratings
Connect to traditional data sources	8.9130 Ratings	8.853 Ratings
Connecto to Big Data and NoSQL	8.190 Ratings	6.240 Ratings

Comparison of Data Transformations features of Matillion and SQL Server Integration Services
Feature	Matillion 7.0 132 Ratings	SQL Server Integration Services 8.1 53 Ratings
Simple transformations	7.6132 Ratings	8.553 Ratings
Complex transformations	6.5131 Ratings	7.752 Ratings

Comparison of Data Modeling features of Matillion and SQL Server Integration Services
Feature	Matillion 8.3 124 Ratings	SQL Server Integration Services 7.4 51 Ratings
Data model creation	9.133 Ratings	8.627 Ratings
Metadata management	9.140 Ratings	7.133 Ratings
Business rules and workflow	8.4116 Ratings	8.242 Ratings
Collaboration	7.5116 Ratings	7.338 Ratings
Testing and debugging	7.8117 Ratings	6.148 Ratings

Comparison of Data Governance features of Matillion and SQL Server Integration Services
Feature	Matillion 8.2 23 Ratings	SQL Server Integration Services 6.9 41 Ratings
Integration with data quality tools	8.222 Ratings	7.436 Ratings
Integration with MDM tools	8.220 Ratings	6.436 Ratings

User Ratings
	Matillion	SSIS
Likelihood to Recommend	8.0 (133 ratings)	8.0 (53 ratings)
Likelihood to Renew	8.6 (6 ratings)	10.0 (3 ratings)
Usability	7.2 (132 ratings)	9.3 (8 ratings)
Performance	- (0 ratings)	8.8 (6 ratings)
Support Rating	7.4 (7 ratings)	8.2 (7 ratings)
Implementation Rating	8.2 (1 ratings)	10.0 (1 ratings)
Data Sharing and Collaboration	9.0 (1 ratings)	- (0 ratings)
Data Sources	9.0 (1 ratings)	- (0 ratings)
Product Scalability	7.6 (126 ratings)	- (0 ratings)
Vendor post-sale	9.1 (1 ratings)	- (0 ratings)
Vendor pre-sale	9.1 (1 ratings)	- (0 ratings)