Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Alteryx
Score 9.0 out of 10
N/A
Alteryx aims to be the launchpad for automation breakthroughs. Be it for personal growth, achieving transformative digital outcomes, or rapid innovation, Alteryx converges analytics, data science and process automation to enable users across organizations to make business-altering breakthroughs. Alteryx Designer can be used to automate every analytics step — from data prep to data science. Access any data source or type, then blend via drag-and-drop interface.…N/A
Matillion
Score 6.7 out of 10
N/A
Matillion is a productivity platform for data teams. Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality data at a speed and scale that matches the business’s data ambitions. The vendor states enterprises including Cisco,N/A
Pricing
AlteryxMatillion
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
AlteryxMatillion
Free Trial
YesYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
YesYes
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsBilled directly via cloud marketplace on an hourly basis, with annual subscriptions available depending on the customer's cloud data warehouse provider.
More Pricing Information
Community Pulse
AlteryxMatillion
Considered Both Products
Alteryx
Chose Alteryx
Alteryx stacks up against its competitors in the marketplace because from day one its goal was to simplify and democratize data processes. Its visual nature and transparent tool set, combined with its highly addictive joy to use make it stand out from the crowd.
Matillion
Chose Matillion
It's a GUI so we don't live just in the code in AWS. For what we neede alteryx wouldn't be best suited. altough as we move to more analytics focussed team it's something i will look at again.
Chose Matillion
Matillion is cheaper and we really like the customer support of Matillion as well as lerning materials provided by Matillion were far better. They also made connectors for us for free while others were charging us for it.
Chose Matillion
The out of the box connectors for various data sources especially for Salesforce is the main reason we chose Matillion in terms of source connectivity.
Aside connectors, Matillion provides some unique features like Shared jobs, Grid variables, etc that are very helpful in quick …
Chose Matillion
Matillion provided much more flexibility than the other products we tested, at a much lower price point. Other products, in my view, had a cleaner/simpler UI but I also felt that they offered much less functionality. A key design pattern we had to deliver was to perform delta …
Chose Matillion
Matillion easily integrates with Snowflake which is a huge selling point. It is also affordable fro the amount of data source connections that it comes with.
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.
Top Pros
Top Cons
TrustRadius Insights
AlteryxMatillion
Highlights

TrustRadius
Research Team Insight
Published

Alteryx Platforma is a business intelligence and data visualization software, while Matillion is an Extraction, Transformation, and Loading (ETL) tool. Matillion is used for centralizing, consolidating, and formatting data for analysis and reporting. Alteryx is used for more intensive analytics and reporting, but it also emphasizes its ETL capabilities relative to other BI tools. Given Alteryx’s broad feature set, it is more heavily used by enterprises, while Matillion has users across company sizes. 

Features

Both Alteryx and Matillion have distinct strengths tailored to certain needs.

Alteryx stands out for its full-service analytics capabilities, from data extraction to visualization and modeling. Users point to a robust set of predictive analytics models for various use cases. For repeated analyses or processes, Alteryx also provides automation and macros functionality to streamline data analytics. 

Matillion specializes in data centralization and preparation. In particular, it excels at extracting data from an extremely wide range of platforms, especially AWS environments and cloud-based data warehouses. It also features a very low learning curve, with greater accessibility via a drag-and-drop interface. 

Limitations

While Alteryx and Matillion both have strong features, they also have some limitations.

Alteryx has struggled with more polished visualizations. Users have described limited data visualization functionality and customization. Alteryx also has limited training, which can contribute to a more difficult learning curve. 

In contrast, Matillion’s ETL specialization trades off with any data analysis capabilities. Matillion does not provide post-data loading functionalities like analytics or reporting. Users have also struggled with a lack of documentation for updating the tool or tracking existing projects. 

Pricing

Alteryx has two offerings, Designer and Server. Designer, the core data analytics offering, is priced at $5,195/user/year for the base license, $11,700/user/year for added location data, and $33,800/user/year for additional demographic, spatial, and segmentation data. Alteryx provides a 14 day free trial for Designer. Alteryx Server’s base price is $78,975/year for greater scalability and collaboration, plus an additional $39,000/year for additional data management and discovery functionality. 

Matillion provides four packages for its ETL capabilities, priced per hour of usage. The “Medium” package, at $1.27/hr, provides 2 users and 6 environments. The “Large” package, at $2.74/hr, supports 5 concurrent users and 15 environments and clustering. The “XLarge” package, at $5.48/hr, supports 12 concurrent users and 35 environments. Enterprise package pricing is available by quote from the vendor.

Features
AlteryxMatillion
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Alteryx
-
Ratings
Matillion
7.3
124 Ratings
13% below category average
Connect to traditional data sources00 Ratings7.4123 Ratings
Connecto to Big Data and NoSQL00 Ratings7.183 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Alteryx
-
Ratings
Matillion
7.0
125 Ratings
16% below category average
Simple transformations00 Ratings7.8125 Ratings
Complex transformations00 Ratings6.3124 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Alteryx
-
Ratings
Matillion
7.0
117 Ratings
14% below category average
Data model creation00 Ratings9.133 Ratings
Metadata management00 Ratings9.140 Ratings
Business rules and workflow00 Ratings6.0109 Ratings
Collaboration00 Ratings4.5109 Ratings
Testing and debugging00 Ratings4.8110 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Alteryx
-
Ratings
Matillion
8.2
23 Ratings
1% below category average
Integration with data quality tools00 Ratings8.222 Ratings
Integration with MDM tools00 Ratings8.220 Ratings
Best Alternatives
AlteryxMatillion
Small Businesses
Klipfolio
Klipfolio
Score 7.7 out of 10
Skyvia
Skyvia
Score 9.7 out of 10
Medium-sized Companies
Klipfolio
Klipfolio
Score 7.7 out of 10
IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
Enterprises

No answers on this topic

IBM InfoSphere Information Server
IBM InfoSphere Information Server
Score 8.1 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
AlteryxMatillion
Likelihood to Recommend
9.2
(126 ratings)
6.7
(126 ratings)
Likelihood to Renew
8.5
(19 ratings)
8.3
(6 ratings)
Usability
9.2
(52 ratings)
5.8
(125 ratings)
Availability
8.0
(4 ratings)
-
(0 ratings)
Performance
9.1
(37 ratings)
-
(0 ratings)
Support Rating
9.3
(52 ratings)
7.4
(7 ratings)
In-Person Training
7.0
(1 ratings)
-
(0 ratings)
Online Training
8.6
(2 ratings)
-
(0 ratings)
Implementation Rating
8.2
(5 ratings)
8.2
(1 ratings)
Configurability
7.4
(2 ratings)
-
(0 ratings)
Ease of integration
8.3
(3 ratings)
-
(0 ratings)
Product Scalability
7.6
(3 ratings)
5.4
(118 ratings)
Vendor post-sale
8.3
(2 ratings)
9.1
(1 ratings)
Vendor pre-sale
7.3
(1 ratings)
9.1
(1 ratings)
User Testimonials
AlteryxMatillion
Likelihood to Recommend
Alteryx
We're trying right now to get more people using it at our company so we can send management documented cases for how we can expand and purchase Alteryx Server which will extend the capabilities even more and across more departments. It's been well suited for pretty much everything we do on a repeating schedule. It's worth the time to set up the workflows. When Treasury sends me the bank download now - I save it to a folder and run our workflows and send back 2 journal entries in .9 seconds. (yes - in less than a second it's finished running)
Read full review
Matillion
If the target dwh is one of the big players it could be a good option. Can retrieve data from multiple different sources and handle them internally. Expensive and being hosted by the client there's also the infrastructure burden of maintaining/paying for the server. Considering the resources needed hence the license cost that scales with them (despite the fact that you host and pay for them already) I wouldn't suggest the tool to a small company and, once you are big enough you probably want to jump on bigger more mature tools. Matillion is a nice niche player with some nice to have feature that are probably suited for a mid-size company with some money available to pay for the license but still a small infrastructure that just require one/two Matillion servers installed. A global company with multi regions needs will drown under the burden of handling/updating/maintaining all the servers independently and pay for the cost of each one of them.
Read full review
Pros
Alteryx
  • Pulling data from multiple disparate data sources.
  • Allows users to see the data at every step of the workflow to be able to cleanse, analyze, and optimize the data.
  • Provides an analytics platform that is easy for users of all levels to thrive in whether they are just starting out in their analytics journey or they have a master's degree in Data Science.
Read full review
Matillion
  • Matillion has a rich transformation library. It provides multiple functionalities, such as join, group by, pivot, various sources, and sinks.
  • It provides the security capability as well. All the credentials can be securely stored in Matillion.
  • Reusable templates can be built which reduces the redundancy.
  • Time to production is very minimal.
Read full review
Cons
Alteryx
  • Alteryx is great for processes that is has already "thought through". It's more difficult to get Alteryx to deal with some customization.
  • The data visualizations with Alteryx are generally good, although I don't think the color schemes are the best.
  • I think the data science capabilities are awesome with Alteryx, although not as well used as products built with Python or R.
Read full review
Matillion
  • The new DPC version of Matillion uses Git principals like Commit, Push, Merge etc. This is perfectly fine for engineers, but for our use-case it means our customers will need to understand a basic level of Git. It would be great if they had an auto-commit-push setting which does it all for them.
Read full review
Likelihood to Renew
Alteryx
We've developed a working partnership with Alteryx. As an enablement suite, we're continuing to innovate and deliver great products with use of Alteryx in our solutions. Alteryx use expands to our global product development teams and is in use in multiple parts of our organization. Alteryx also delivers Experian demographic content to other clients in their product offering. We're highly likely to renew, but that decision is way above my pay grade.
Read full review
Matillion
With the current experience of Matillion, we are likely to renew with the current feature option but will also look for improvement in various areas including scalability and dependability. 1. Connectors: It offers various connectors option but isn't full proof which we will be looking forward as we grow. 2. Scalability: As usage increase, we want Matillion system to be more stable.
Read full review
Usability
Alteryx
I've found that while some things might take a little longer to create, the flexibility of Alteryx allows you to perform any function needed. I haven't found a use that was not available in Alteryx yet. APIs and XMLs can be created to perform certain functions. In addition, CMD line commands can be sent using Alteryx to perform certain functions as well.
Read full review
Matillion
It has been easy to train new employees who don't have previous experience with Matillion. It is quite self-explanatory. There are quite a few things that can be done with Python, however, we have not really looked into this feature much but likely will do in the future. Mostly, it is drag and drop of components and environments can be set up so easy to set up connections as well.
Read full review
Reliability and Availability
Alteryx
I use many programs and compared to others, Alteryx virtually never goes down, freezes up or gives an application error. Over a 4 year time period that I have used this program, any of these may have happened 3 times. It is an incredibly stable program that I feel completely confident in.
Read full review
Matillion
No answers on this topic
Performance
Alteryx
Alteryx is an extremely reliable platform. If there is an error in my workflow, I feel pretty strongly it was probably my fault. The platform also handles large amounts of data very quickly and can join/match, sort, filter, calculate on that data quickly as well. One of my favorite things to build into a workflow are the messages based on data/metadata and error messages based on errors I have come across before.
Read full review
Matillion
No answers on this topic
Support Rating
Alteryx
Stellar, bar-none. Some of the best support folks of any vendor. The Alteryx Community is the most responsive and supportive. On the rare occasion of a release issue or bug, we've been able to get quick help to solve the core problem. Alteryx does not play the blame game. They genuinely help the users solve their issues or respond to questions
Read full review
Matillion
Overall, I've found Matillion to be responsive and considerate. I feel like they value us as a customer even when I know they have customers who spend more on the product than we do. That speaks to a motive higher than money. They want to make a good product and a good experience for their customers. If I have any complaint, it's that support sometimes feels community-oriented. It isn't always immediately clear to me that my support requests are going to a support engineer and not to the community at large. Usually, though, after a bit of conversation, it's clear that Matillion is watching and responding. And responses are generally quick in coming.
Read full review
In-Person Training
Alteryx
1st level of trainings which I've attended in Paris was easy and I was already knowing %90, that learning could have been an e-learning instead of in-person
Read full review
Matillion
No answers on this topic
Online Training
Alteryx
Very good, detailed online trainings which you can take at your own pace, and strong certifications exists, certifications are extremely detailed and hard...
Read full review
Matillion
No answers on this topic
Implementation Rating
Alteryx
There is really not much to it (the installation, that is). Once you get it installed, along with any of the add-ons (demographics, R, etc.), you are up and running almost immediately. There is really no additional setup. You can immediately begin blending data, running demographics, performing spatial queries, running predictive analysis, etc. And for many of these functions, the learning curve is quite easy.
Read full review
Matillion
We were able to control on access and built various enviroment for implementation
Read full review
Alternatives Considered
Alteryx
Alteryx is MUCH more user friendly. both provide the ability to code within them, but Alteryx has much nicer interface. The formula tools have a more simple language that is easier to learn than formulae in SSIS. Alteryx is easy to read with multi colored tools identifying what each one does. It also allows for macros. You can build your own tool to process records of data or batch records together.
Read full review
Matillion
Matillion ran circles around Stitch and Striim both in functionality, setup, and performance. There was no real comparison. Fivetran massively outperforms Matillion in pretty much every facet of the production from setup, maintenance, visibility, and usability. It already has the ability to connect any data source to a destination regardless of database type. Why we chose Matillion over Fivetran is that, for our current needs, Matillion provides us with the functionality that we need and a much more competitive price for a smaller company.
Read full review
Scalability
Alteryx
Individual analysts can quickly generate results using their own copy of Alteryx Designer. But using the Server and developing macros for more complex needs can be time consuming.
Read full review
Matillion
I have been able to connect Matillion to AWS Aurora Databases, MySQL databases, Rest APIs, Files in AWS S3, etc. Being able to load all of that disparate data into one datalake has made data mining and reporting a lot simpler. I wish everything could be implemented as easily as Matillion.
Read full review
Return on Investment
Alteryx
  • Error handling - allows controls to be built into workflows easily and allows them to be isolated and spat into control reports that can be easily reviewed and audited, thanks to the ability to create multiple outputs in one go.
  • Time-saving - saved huge amounts of time, especially when moving Excel processes into Alteryx.
  • Product development - allowed my firm to create products that we have been able to market and sell to clients.
Read full review
Matillion
  • Saving us time reduces our need for headcount
  • Allows us to collaborate on data-eng pipelines in a transparent way with non-technical stakeholders, ensuring accuracy and continuity
  • Allows us a single platform to log and manage all of our pipelines to pin-point where something failed and why
  • Always has a solution to very common data engineering tasks, i.e., real-time data, connectors, pre-built workflows, etc.
Read full review
ScreenShots

Alteryx Screenshots

Screenshot of Alteryx APA - Automating asset inputsScreenshot of Alteryx APA - Automating outcomesScreenshot of Alteryx APA - Data enrichment and insightsScreenshot of Alteryx APA - Data quality and preparationScreenshot of Alteryx APA - Data science and decisions

Matillion Screenshots

Screenshot of Matillion's GUI, used to orchestrate jobs with control data flow functionality, automating the ETL process.Screenshot of where structured and semi-structured data can be prepared to create clean data sets that can be used with any BI/reporting/visualization tool of choice. Matillion reads and combines data across a target warehouse external storage, such as S3 or Blob.Screenshot of Matillion's self-validating components, sample and row counts. If a job does fail, the warehouse queue services available with Matillion can be used get an alert to a connected email or Slack account.Screenshot of the SQL component used to run custom scripts from within Matillion. With hundreds of pre-built connectors out of the box, Matillion can handle complex transformation needs.