Matillion Features

Matillion

Extract, transform, load platform for cloud data warehouses

4.29/5 (96 reviews)

Matillion Feature Summary

  • Non-Relational Transformations
  • Orchestration Components
  • Project Import/Export

Competitor Feature Comparison

API
Activity Dashboard
Analytics
Audit Trail
Auditing
Automated Scheduling
Collaboration Tools
Content Filter
Credential Management
Data Capture and Transfer
Data Connectors
Data Extraction
Data Filtering
Data Import
Data Import/Export
Data Migration
Data Storage Management
Data Synchronization
Data Transformation
Document Management
Document Review
Job Management
Job Scheduling
Job Tracking
Metadata Management
Multiple Data Sources
Permission Management
Real Time Data
Reporting & Statistics
Role-Based Permissions
SSL Security
Search Functionality
Security Auditing
Social Media Integration
Task Management
Task Scheduling
Third Party Integration
Version Control
Learn moreCompare App
API
Activity Dashboard
Analytics
Audit Trail
Auditing
Automated Scheduling
Collaboration Tools
Content Filter
Credential Management
Data Capture and Transfer
Data Connectors
Data Extraction
Data Filtering
Data Import
Data Import/Export
Data Migration
Data Storage Management
Data Synchronization
Data Transformation
Document Management
Document Review
Job Management
Job Scheduling
Job Tracking
Metadata Management
Multiple Data Sources
Permission Management
Real Time Data
Reporting & Statistics
Role-Based Permissions
SSL Security
Search Functionality
Security Auditing
Social Media Integration
Task Management
Task Scheduling
Third Party Integration
Version Control
Visit WebsiteCompare App
API
Activity Dashboard
Analytics
Audit Trail
Auditing
Automated Scheduling
Collaboration Tools
Content Filter
Credential Management
Data Capture and Transfer
Data Connectors
Data Extraction
Data Filtering
Data Import
Data Import/Export
Data Migration
Data Storage Management
Data Synchronization
Data Transformation
Document Management
Document Review
Job Management
Job Scheduling
Job Tracking
Metadata Management
Multiple Data Sources
Permission Management
Real Time Data
Reporting & Statistics
Role-Based Permissions
SSL Security
Search Functionality
Security Auditing
Social Media Integration
Task Management
Task Scheduling
Third Party Integration
Version Control
Visit WebsiteCompare App

Matillion Feature Reviews

25 reviewers had the following to say about Matillion's features:

neil sparrow

A good choice for GUI closed based ETL

2019-06-17

We use the tool for creating ETL data piplines.

Pros

Easy learning Curve Simple to work with Cloud based tool Great support Very easy to support shared code due to the GUI element.

Cons

Lack of DevOps style integration Lack of release management support.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Daily

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Graham Lannigan

Easy to use solution, allowing rapid delivery of ELT processes

2019-06-14

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

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

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Sandeep Mohnalkar

SalesLoft Matillion for Data Warehouse

2019-06-13

We shortlisted three different ETL tools based on the capabilities to perform full load, incremental load with change data capture (CDC), process chains, job scheduling and monitoring, job success/failure notification to name a few most important criteria.

Pros

Quick development capabilities to perform full load, incremental load with change data capture (CDC), process chains, job scheduling and monitoring, job success/failure notification, customer support to name a few

Cons

Wish to see Matillion having Github control

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 1-2 years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Łukasz Chłosta

Perfect ELT Tools

2019-06-13

ELT, daily basis extract of data and ad-hoc tasks

Pros

Workflow Layout and clarity of all components

Cons

Environment Management, licensing model

Rating breakdown

Ease of use
Features
Customer support

Time used: 1-2 years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
David Lyons

A Great ELT and warehousing toolset in a clean GUI

2019-06-16

We're pulling multiple datasets together and integrating them in star schemas with Matillion, as well as doing sophisticated data analysis.

Pros

The GUI and design makes it easy to not only functionalize your ELTs, but also show a graphical DAG to stakeholders.

Cons

I wish it had an out-of-the-box API gateway to receive webhook requests from third-party data sources.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Arnaud Col

Best visual ELT on the market

2019-07-01

Matillion helped us develop various business use cases: Ambient temperature monitoring, ERP data centralization, data quality management.

Pros

With Matillion, you can harness the power of major cloud data warehouses in no time.

Cons

Error management and replay can be tricky to develop.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Weekly

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Chaitanya Muppalla

Simple and easy ELT

2019-06-14

Yet a lot possible with python scripting feature.

Pros

Integration with GCP API calls and cloud storage.

Cons

Having to use 3rd party add ons.

Rating breakdown

Ease of use
Features
Customer support

Time used: 1-2 years

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
PRANAVKUMAR Shah

Good tool for workflow management

2019-07-05

I am happy with this tool and it has good UI.

Pros

- It has very good UI to design the workflow. - It is easy to design the workflow. - It has very good support with persistence storage.

Cons

- It should also support Azure data warehouse.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Ryan Allen Abarquez

Matillion for BigQuery - United HealthGroup Data Engineer Review

2019-07-12

If you're looking for a tool for your analytics data warehouse which is fast, convenient and easy to learn, then this is the tool for you

Pros

Its very easy to learn. The UI is great and easy to navigate.

Cons

Its a one way ETL, I'm using the BigQuery product and all the destination are in BigQuery, it would also be nice if we can load data to the sources.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 1-2 years

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Computer Software company, 1001-5000 employees)

A good solution for a one man data shop

2019-06-20

In the scope of a sole user, it's a very powerful tool. One can get a production ETL job up and running in hours starting from scratch.

Pros

Easy to learn Visual interface Pretty reliable

Cons

Version control Search Explaining dependencies

Rating breakdown

Value for money
Ease of use
Features

Time used: 1-2 years

Frequency of use: Daily

Likelihood to recommend

7/10
Source: Capterra
Helpful?   Yes   No
Read more
Matthew Satti

Saved a lot of time

2019-06-23

We have been using Matillion for constructing data tables for analytical purposes.

Pros

It saves me a whole lot of time from writing SQL queries by hand.

Cons

Interactions with external custom APIs can be a bit of a pain, but we've always managed to get there one way or another.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Weekly

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Joe Ellerington

Matillion for Data Engineers

2019-06-28

I think the real complexity comes from optimising complex workflows, the more T you need in the ETL/ELT process, the more Matillion falls down.

Pros

It is easy to use and quick to get started, there are many inbuilt APIs and transformations that integrate it across a broad suite of systems, and enable you to transform data for the business without having to spend too much time thinking about scripts or bespoke batch files.

Cons

Both of these have easy to use workarounds but it is unfortunate it is not supported more at surface level.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: Less than 6 months

Frequency of use: Daily

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Łukasz Cieśla

Great piece of software

2019-06-13

Importing data from different sources.

Pros

Easy to use. Easy to move a lot of different processes into one place.

Cons

Problematic API support.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: Less than 6 months

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Michael Sprague

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

2019-06-13

We could sort of do it with Matillion, but it required a lot of custom programming and was not very intuitive.

Pros

It is extremely fast and easy to pull data from various sources and pipe it into Snowflake.

Cons

With it shut down, development can't happen.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Occasionally

Likelihood to recommend

6/10
Source: Capterra
Helpful?   Yes   No
Read more
Gary North

Intuitive ETL

2019-06-13

Speed of ETL development and templated approaches.

Pros

I could build a complete ETL process with absolutely no training at all in just a few hours. All of the components I expected to see where there, and heaps more. When I needed help - there it was!

Cons

Versioning and branching is difficult when developing, there is a total reliance on a unique component name.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: Less than 6 months

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Computer Software company, 10001+ employees)

Matiilion - Cloud based, scalable, available ELT for Big data

2020-11-10

Overall it is user-friendly, easy to develop & deploy, secure ELT for big data use cases.

Pros

1) Easy to use 2) Several ingestion integrations 3) Custom RDBMS ingestion support 4) Robust transformation and Orchestration components

Cons

No availability of change data capture feature for many databases

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Internet company, 51-200 employees)

Great ETL Tool for Business Users

2019-06-28

Pros

Logic drag & drop of ETL steps makes the design and documentation of each ETL processes much simpler.

Cons

Getting it setup and connected to our data warehouse seemed to be unnecessarily complicated.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Weekly

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Information Technology and Services company, 201-500 employees)

Matillion is the lead in ETL space.

2019-07-05

Matillion's cloud model is leading the trend in this industry. It's cost effective and manageable.

Pros

I've worked with a larger number of clients that have uses Matillion as well as other tools and Matillion is definitely the most reliable. The UI is easy to follow and understand and the learning curve is small.

Cons

It does require some training or knowledge of workflow development though it's the most reliable.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 1-2 years

Frequency of use: Occasionally

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Jesse Bulpit

Great turnkey solution to ETL and data migrations

2019-06-13

Pros

There are other options but none have the ease of onboarding that Matillion offers. The API adds a powerful layer to do advanced integrations.

Cons

This has been rare and was easy enough to resolve by resetting the service.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Ravi Kumar

Review of Matillion as ETL cloud Engineer

2019-07-08

It was great working as well learning experience , hope Matillion will come up as industry leader.

Pros

Matillion integration with AWS services is flawless and has real time impact in batch jobs pulling data from on-premises to cloud platform.

Cons

Restricting the number of user can access Matillion, Lot's of time huge data set get stuck and fail with many other issues lastly better full log specifically for Developer to debug the issues.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Daily

Likelihood to recommend

4/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Financial Services company, 11-50 employees)

Starting out with Matillion

2019-06-13

We were trying to quickly set up multiple ETL pipeline into our Analytic Data-warehouse and Matillion did just that.

Pros

GUI was easy to navigate, most default functions works well, it has the ability to connect to all of our required cloud data sources, and any custom function can be scripted using Python.

Cons

We tried using the python module to run heavy CPU data cleansing process and the software timed out.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Weekly

Likelihood to recommend

6/10
Source: Capterra
Helpful?   Yes   No
Read more
Dana Morrison

Matillion is working great!

2019-06-13

We are using Matillion to pull API JSON data from various systems and push that data into Snowflake.

Pros

Using automation and integration with AWS, I can get messages if there are issues with any orchestration jobs.

Cons

Getting the API pulls working was a little clunky, but it came together relatively quickly utilizing Matillion's support.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Brayden Jackson

Matillion ETL For Medium to Large Company

2019-06-18

I recommend this ETL tool to any company of any size as it can be scaled to any business needs and you only pay for what you use.

Pros

It is slick and intuitive and has a great user interface.

Cons

The account will log you out, but it works in real time so it usually does not delete any of your work.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Daily

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Shivkumar Mallesappa

For AWS one of the best tool to go for

2019-06-14

We are using Matillion to process real-time data

Pros

Ease of deployment Migration Multiple users Pay as you go - cost saving

Cons

Software updates cause sometimes an error

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 1-2 years

Frequency of use: Daily

Likelihood to recommend

7/10
Source: Capterra
Helpful?   Yes   No
Read more
Roger Eyre

Initial Feedback

2019-06-13

It means we are getting real insight into our business.

Pros

User interface and range of connections.

Cons

Licensing is not flexible, Why cant you specify the number of concurrent users for a given instance? It comes with a fixed amount, if you don't like it, update to a much large and expensive instance that we do not need.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 1-2 years

Frequency of use: Daily

Likelihood to recommend

5/10
Source: Capterra
Helpful?   Yes   No
Read more