Matillion

Extract, transform, load platform for cloud data warehouses

About Matillion

Matillion is an extract, transform, load (ETL) solution for cloud data warehouses including Amazon Redshift, Snowflake and Google BigQuery. It enables users to gather data from various sources and deliver them in structured and semi-structured frameworks using platform's data transformation capabilities. The search functionality lets enterprises find specific results across notes, jobs, and components within projects through term-based searches.

Key features of Matillion include data export/import, collaboration, audit logs, scripting, job scheduling, version control and task management. Businesses can use the automation tools to schedule multiple orchestration jobs against a project at predefined time intervals. Plus, it enables administrators to ensure data security by managing user access across Active/LDAP directories, SSL certificates and authentication to use information from the local directory.

Matillion facilitates integration with several third-party applications to aid with data management across cloud warehouses such as Facebook, MailChimp, Amazon RDS, Hubspot, Salesforce, Elasticsearch, Google Analytics, JIRA, Marketo, and more. It also comes with an application programming interface (API) query component, which allows users to integrate the platform with any JSON or XML-based API.

Pricing starting from:

US$2.00

  • Free Version
  • Free Trial
  • Subscription

Top 5 alternatives to Matillion

Business size

S M L

Deployment

  • Cloud-based
  • On-premise

Markets

Australia, Brazil, Canada, China, Germany, India, Japan, Mexico, United States

Supported Languages

English

Pricing starting from:

US$2.00

  • Free Version
  • Free Trial
  • Subscription

Top 5 alternatives to Matillion

Images

Matillion Software - Matillion ETL workflow screenshot
Matillion Software - Matillion SQL editor screenshot
Matillion Software - Matillion component failure screenshot
Matillion Software - Matillion RDS query screenshot
Matillion Software - Matillion documentation screenshot
View 6 more
Matillion video
Matillion Software - Matillion ETL workflow screenshot
Matillion Software - Matillion SQL editor screenshot
Matillion Software - Matillion component failure screenshot
Matillion Software - Matillion RDS query screenshot
Matillion Software - Matillion documentation screenshot

Features

Total features of Matillion: 43

  • API
  • Access Controls/Permissions
  • Activity Dashboard
  • Audit Management
  • Audit Trail
  • Automated Scheduling
  • Collaboration Tools
  • Data Aggregation and Publishing
  • Data Analysis Tools
  • Data Capture and Transfer
  • Data Connectors
  • Data Extraction
  • Data Import/Export
  • Data Integration
  • Data Migration
  • Data Security
  • Data Storage Management
  • Data Transformation
  • Data Visualisation
  • Document Extraction
  • Document Management
  • Email Address Extraction
  • IP Address Extraction
  • Job Scheduling
  • Match & Merge
  • Metadata Management
  • Multiple Data Sources
  • Non-Relational Transformations
  • Phone Number Extraction
  • Pricing Extraction
  • Real Time Data
  • Reporting & Statistics
  • Reporting/Analytics
  • Role-Based Permissions
  • SSL Security
  • Search/Filter
  • Social Media Integration
  • Task Scheduling
  • Third Party Integrations
  • Version Control
  • Visual Analytics
  • Visualisation
  • Web Data Extraction

Alternatives

Fivetran

4.6
#1 Alternative to Matillion
Fivetran is a zero-maintenance data pipeline which enables businesses of all sizes to collect and analyze their...

Stitch Labs

4.5
#2 Alternative to Matillion
Stitch is an inventory and order management platform built for modern, high-growth brands.

Integrate.io

4.6
#3 Alternative to Matillion
Integrate.io is a data warehouse integration product suite including data transformation, data replication, API...

Talend Data Fabric

4.2
#4 Alternative to Matillion
Talend Data Fabric offers a single suite of apps to help enterprises collect, govern, transform and share data,...

Reviews

Overall rating

4.3 /5
(107)
Value for Money
4.1/5
Features
4.1/5
Ease of Use
4.4/5
Customer Support
4.5/5

Already have Matillion?

Software buyers need your help! Product reviews help the rest of us make great decisions.

Write a Review!
Showing 5 reviews of 107
James
Overall rating
  • Industry: Consumer Services
  • Company size: 51-200 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

The best ELT tool on the market

Reviewed on 31/8/2021

Matillion is the single most important piece of software I use on a day-to-day basis. Its' ability...

Matillion is the single most important piece of software I use on a day-to-day basis. Its' ability to blend a ton of out-of-the-box functionality with the ability to script custom components in Python to author our own integrations is invaluable. It has enabled us to build transformed data within our warehouse, use pre-authored integrations to pull data from vendors, write our own integrations to pull from vendors, and is the single tool we use along with Redshift to provide visibility to all of the data within our business. I am a huge fan of Matillion and have used it in 2 different orgs. It is one of the only software tools I will champion across any org I move to.

Pros

-Extremely easy deployment with cloud formation template.
-Excellent pre-authored integrations that are easily extensible/customizable.
-Easy to use UI to build complex transformations.
-Extremely flexible logic with static and grid variables to intelligently execute jobs and branch as needed.

Cons

-No automated scheduling based on dependent table updates. (This is possible to set up, but not out of the box.)
-Support SLAs have gotten worse over time.

Alternatives Considered

Pentaho, AWS Glue and Fivetran
Graham
Overall rating
  • Industry: Marketing & Advertising
  • Company size: 51-200 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Easy to use solution, allowing rapid delivery of ELT processes

Reviewed on 14/6/2019

We came to Matillion while looking for a tool that would allow us to orchestrate our load processes...

We came to Matillion while looking for a tool that would allow us to orchestrate our load processes for Amazon Redshift. We'd used other ETL tools previously, were blown away by how easy it was to pick up and understand Matillion. We liked the simplicity, and the fact that we could always dig into the SQL that was generated. New features are added frequently, and we usually find one or two improvements that directly impact us with each release.

Their support team are also very responsive, and Matillion are always keen to help you get the most out of their software, so there's a lot of support if you want it.

2+ years later, and we're using Matillion to run all our ELT jobs across various data warehouse projects, and very happy with it.

Pros

- Very intuitive design environment - super quick to learn.
- Components map closely to SQL capabilities in Redshift.
- Easy to view the SQL generated.
- Sample, row count, and data lineage make it easy to unit test as you build.
- Powerful management options via REST API (orchestration, Github integration, etc.).
- Native AWS integration.
- Aggressive release cycle, constantly adding new features.
- Easy to document in-workflow.
- Lots of third party integrations.

Cons

- User concurrency/licencing model (simple, but can't be customised to fit your need).
- Exception handling could be improved.
- A single Task View would be helpful for multi-environment/project support.

Alternatives Considered

Alteryx Designer

Reasons for Switching to Matillion

Simplicity, and the fact that Matillion was built specifically for Redshift, meant it was ideal for our needs.
Roger
Overall rating
  • Industry: Marketing & Advertising
  • Company size: 51-200 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Responsive to User Needs

Reviewed on 13/6/2019

Gets better and better with each release. Keep up the good work!

Gets better and better with each release. Keep up the good work!

Pros

I've been using Matillion for about 2 and a half years. I've seen the software improve so much in that time. If I ever found a feature to be lacking, it would be included within the next couple release cycles. The software really seems to adapt as user needs have been evolving. Some of my favorite recent features are the ability to configure some components with just text (really saves me time) and the many Grid orchestration components which allow me to greatly reduce the complexity of the orchestration jobs.

Cons

UX is sometimes lacking or inconsistent. For example, let's say my goal is to replace an existing job with a new job of the same name. I delete the old job, and import the new one with the same name. All Orchestration components that used that job will understand to use the new job, but for some reason the scheduler doesn't.
Also, jobs will have validation errors simply because the components haven't been validated (grey borders). It can be confusing because you may be searching for an error in your work when all you actually have to do is revalidate the job.

Michael
Overall rating
  • Industry: Higher Education
  • Company size: 501-1,000 Employees
  • Used for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 6.0 /10

Great for pipelining data to warehouse/lake, not getting it back

Reviewed on 13/6/2019

It was easy to get set up, and it worked great for pushing data into Snowflake as a data warehouse....

It was easy to get set up, and it worked great for pushing data into Snowflake as a data warehouse. However, we quickly realized that we would need yet another tool to get the data back out to the source systems to synchronize/integrate it. We could sort of do it with Matillion, but it required a lot of custom programming and was not very intuitive. We ended up using a different iPaaS tool that could handle traffic/integration in both directions.

Pros

It is extremely fast and easy to pull data from various sources and pipe it into Snowflake. The graphic interface lets this happen without programming.

Cons

There is almost no ability to get data back from your warehouse into the other systems to synchronize the data. It's great to have it all in the warehouse, but it seems pretty critical to have that data flowing back to other systems that are part of your environment.

The pricing model is frustrating. You are billed for when the machine instance is ON, not when it is actively doing something. So, if you have a couple hours of job that run in a day, you have to shut down the machine to save money the rest of the day. With it shut down, development can't happen. So, we had to turn it on and off all the time. It would be much better if they billed as it is used, not as it is on.

Alternatives Considered

SSIS Data Flow Components

Reasons for Switching to Matillion

Matillion was written for Snowflake, which is our preferred solution over MS SQL Server.
Daniel
Overall rating
  • Industry: Information Technology & Services
  • Company size: 201-500 Employees
  • Used Weekly for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 8.0 /10

A good tool for large-scale ETL into Cloud Data Warehouses

Reviewed on 26/8/2021

We're able to rapidly load large amounts of data into Snowflake and schedule any SQL tasks to run...

We're able to rapidly load large amounts of data into Snowflake and schedule any SQL tasks to run against snowflake.

Pros

Web-based, Runs in AWS so it can sit close to your data if you're using a cloud warehouse. You only have to pay per minute that you have the instance on which is a BIG plus.

Cons

Not nearly as many features and user-friendly data transformation tools as a competing software such as Alteryx has. As such, this tool is not as convenient or flexible for detailed data transformations. We mostly use it for bulk loading which it is very fast and good at.

Alternatives Considered

Fivetran

Reasons for Choosing Matillion

We still use Alteryx for detailed ETL tasks, but Matillion is way faster for bulk loading operations into Snowflake. If Matillion could build out more data transformation tools then we may consider switching entirely.

Switched From

Alteryx Designer

Reasons for Switching to Matillion

Cost is based on how much data you're processing vs. how much time you are using the server. This means fivetran is not cost effective for bulk loading tasks.
Showing 5 reviews of 107 Read all reviews

Matillion FAQs

Below are some frequently asked questions for Matillion.

Matillion offers the following pricing plans:

  • Starting from: US$2.00
  • Pricing model: Free Version
  • Free Trial: Available

Pricing is available using Credits, starting at $2.00/credit. Matillion Credits are used to pay for the consumption of Virtual Core hours while running Matillion ETL instances. One Matillion Credit equals one Virtual Core hour. Annual pricing is also available. Please contact Matillion for additional information.

Matillion has the following typical customers:

11-50, 51-200, 201-500, 501-1,000, 1,001-5,000

Matillion supports the following languages:

English

Matillion supports the following devices:

Matillion integrates with the following applications:

Amazon Aurora, Amazon DynamoDB, Amazon S3, Amplitude, Apache Hive, Apache Spark, Dropbox Business, Dynamics 365 Business Central, Gmail, Google Ads, Google Analytics 360, HubSpot CRM, Instagram, Jira, Mailchimp, Marketo Engage, Meta for Business, Microsoft Excel, Mixpanel, NetSuite, NetSuite CRM, Oracle Eloqua, PayPal, QuickBooks Online Advanced, ServiceNow, Shopify, Stripe, SugarCRM, Twitter, Xero, ZenDesk Chat, Zendesk, Zuora

Matillion offers the following support options:

Email/Help Desk, FAQs/Forum, Phone Support, 24/7 (Live rep)

Related categories

See all software categories found for Matillion.