Home/ETL Tools/Matillion ETL
Updated on: October 20, 2021

What is Matillion ETL ?

Matillion ETL - ETL Tools
98% The SW Score ranks the products within a particular category on a variety of parameters, to provide a definite ranking system. Read More

Matillion ETL

Avail full advantage of data storage
(266 Ratings) Write Review

Matillion ETL is a purpose-built tool designed to transform various cloud data warehouses. The software enables its users to take advantage of the flexibility, economics, and power of the cloud as it integrates with Google BigQuery, Amazon Redshift, and Snowflake. Users can use the software to load valuable data regarding their business into their cloud data warehouse. They can also transform this data in the cloud in order to unveil the hidden insights within the company. One can extract data from frequently used data sources and also load them into a cloud data warehouse with ease as Matillion ETL supports various data source connectors. The software helps the users to perform powerful transformations to prepare their data for consumption by the leading analytics tools such as Looker, Tableau, etc. The intuitive GUI provided by this ETL platform helps users to visually arrange sophisticated data workflows without any SQL coding. Users can avail the advantage of resource capacity by scheduling the data arrangements to run whenever the resources are available.

Matillion ETL Features Show All Features

Matillion ETL Technical details

Support 24/7 (Live rep) Online Customer Type Large Enterprises Medium Business Small Business
API Location / Phone Number Denver, Colorado / +1 (720) 930-4647
Deployment SaaS/Web/Cloud Category ETL Tools

Matillion ETL Pricing

Pricing ModelFree Trial , Subscription , Quotation Based
Medium
$1.37 Pay as you go

Starting at $1.37/hr

Estimated annual cost of $12K, assuming 24/7 usage

Suitable for individuals, small teams or POCs.

Features

  • Supports max 2 concurrent users
  • Max 6 saved environments (1 environment = 1 project connection to 1 Redshift cluster)
  • FREE support via email and phone
Large
$2.74 Pay as you go

Starting at $2.74/hr

Estimated annual cost of $24K

Assuming 24/7 usage

Features

  • Supports max 5 concurrent users
  • Max 15 saved environments (1 environment = 1 project connection to 1 Redshift cluster)
  • High availability clustering available
  • Additional features to support large enterprise environments
  • FREE 14-day trial available through your cloud platform marketplace
XLarge
$5.48 Pay as you go

Starting at $5.48/hr

Estimated annual cost of $48K

Assuming 24/7 usage

Features

  • Supports max 12 concurrent users
  • Max 36 saved environments (1 environment = 1 project connection to 1 Redshift cluster)
  • High availability clustering available
  • Additional features to support large enterprise environments
  • FREE 14-day trial available through your cloud platform marketplace
Enterprise
Custom

Features

  • One up-front cost to access a variety of instances for ultimate flexibility and scalability
  • Supports a range of concurrent users and environments
  • Volume discount available
Screenshot of the Vendor Pricing Page
View Full Screen

Disclaimer: The pricing details were last updated on 03/01/2020 from the vendor website and may be different from actual. Please confirm with the vendor website before purchasing.

Learn more about Matillion ETL pricing.

Matillion ETL FAQs

Matillion ETL is ETL Tools. Matillion ETL offers the following functionalities:

  • Version Control
  • Data Analysis
  • Compliance Tracking
  • Metadata Management
  • Data Quality Control
  • API Integration
  • Data Extraction
  • Data Filtering
  • Data Transformation

Learn more about Matillion ETL features.

Yes, Matillion ETL provides API.

Ask the Community View Community

Matillion ETL Alternatives Matillion ETL Alternatives

98% The SW Score ranks the products within a particular category on a variety of parameters, to provide a definite ranking system. Read More
Panoply
(58 RATINGS)
Panoply Panoply enables its users to sync and store their data from various sources while exploring their... read more
Visit Website
Matillion ETL vs Panoply
94% The SW Score ranks the products within a particular category on a variety of parameters, to provide a definite ranking system. Read More
Alooma
(11 RATINGS)
Alooma Alooma is an enterprise data pipeline that enables the data teams to have control and visibility... read more
Visit Website
Matillion ETL vs Alooma
93% The SW Score ranks the products within a particular category on a variety of parameters, to provide a definite ranking system. Read More
Skyvia
(135 RATINGS)
Skyvia Skyvia is a compact data integration, backup and access monitoring software helping out companies... read more
Visit Website
Matillion ETL vs Skyvia
93% The SW Score ranks the products within a particular category on a variety of parameters, to provide a definite ranking system. Read More
Rivery
(28 RATINGS)
Rivery Rivery is a big data management platform with SaaS ELT data integration services that enable teams... read more
Visit Website
Matillion ETL vs Rivery
93% The SW Score ranks the products within a particular category on a variety of parameters, to provide a definite ranking system. Read More
Xplenty
(108 RATINGS)
Xplenty Xplenty is a data integration cloud-based platform that is used by organizations to create simple... read more
Visit Website
Matillion ETL vs Xplenty
92% The SW Score ranks the products within a particular category on a variety of parameters, to provide a definite ranking system. Read More
Dexi.io
(17 RATINGS)
Dexi.io Dexi software is a Competitor Commerce Intelligence used to extract your competitors’ data and ... read more
Visit Website
Matillion ETL vs Dexi.io
92% The SW Score ranks the products within a particular category on a variety of parameters, to provide a definite ranking system. Read More
Stitch
(61 RATINGS)
Stitch Stitch is a cloud-first, open-source and developer-focused ETL tool that helps its users to move... read more
Visit Website
Matillion ETL vs Stitch
92% The SW Score ranks the products within a particular category on a variety of parameters, to provide a definite ranking system. Read More
CloverDX
(9 RATINGS)
CloverDX CloverDX is an enterprise data management platform helping businesses to solve multiple data... read more
Visit Website
Matillion ETL vs CloverDX
89% The SW Score ranks the products within a particular category on a variety of parameters, to provide a definite ranking system. Read More
Blendo
(17 RATINGS)
Blendo Blendo is an ETL data integration tool that helps its users to simplify their way of connecting to... read more
Visit Website
Matillion ETL vs Blendo
88% The SW Score ranks the products within a particular category on a variety of parameters, to provide a definite ranking system. Read More
AWS Glue
(52 RATINGS)
AWS Glue AWS Glue is a serverless data integration service that makes it easy to discover, prepare, and... read more
Visit Website
Matillion ETL vs AWS Glue

Matillion ETL Reviews

OVERALL RATING
4.2
Based on 266 Rating(s)
Rating Distribution
  • 52 %
  • 44 %
  • 4 %
  • 0 %
  • 0 %
SHARE YOUR EXPERIENCE Write a Review
Sort By
Filter by Source
Anup K
Anup KSource : g2crowd.com
(Reviewed on 29 November 2020) "Matillion Review"

What do you like best?

Matillion has various source integration encapulated

What do you dislike?

Nothing as such.. But yes... making UI more smoother would be better

Recommendations to others considering the product:

its win-win situation for client and provider

What problems are you solving with the product? What benefits have you realized?

I have been ingesting data from multilple source system ie. site link, S3, Relational database. Ease of use..

...more
Vibhuti P
Vibhuti PSource : g2crowd.com
(Reviewed on 31 July 2020) "Application Review"

What do you like best?

Best user interface and user freindly. Nice customer support. Also like suggestions while working in it. Best part is it is browser - based UI with modern technologies.

What do you dislike?

Little lagging part rest all other is great.

What problems are you solving with the product? What benefits have you realized?

We were about to built our project on cloud database platforms including Amazon Redshift, Google BigQuery, and Snowflake.Also, used to to large convert (transform) databases from one format or type to another. And we wanted best platform and Matillion ETL solved that problem.

...more
User in Financial Services
User in Financial ServicesSource : g2crowd.com
(Reviewed on 05 January 2018) "Powerful yet simple ETL tool"

What do you like best?

Matillion has a huge selection of pre-built connectors out of the box...twitter, salesforce, AWS services, etc... The interface is extremely easy to use and requires no coding at all. For more custom tasks however, you can always add a Python component and write whatever code you need.

What do you dislike?

So far there is very little that I dislike. The one thing that comes to mind is that there is no on-prem installation option, so I can't use the tool to access databases behind our firewall.

Recommendations to others considering the product:

Start by subscribing to the Matillion Youtube channel, or at least watch their videos...there are quite a few. This is a great introduction into the interface of Matillion and its power and ease of use

What problems are you solving with the product? What benefits have you realized?

We are able to access our data lake in Redshift and create star-schema/dimensional data models. This allows us to offer analytics to our major customers, increasing satisfaction and revenue.

...more
Kundan S
Kundan SSource : g2crowd.com
(Reviewed on 01 December 2020) "Achieving best ETL Solution with Matillion"

What do you like best?

The ability to be able to integrate with many and many no. of components available in the market to achieve the data warehousing and scheduling options.

What do you dislike?

downside is the poor marketing of the matillion tool.

What problems are you solving with the product? What benefits have you realized?

Enhancing the current data warehousing solution by moving the current setup to cloud - AWS with Matillion setup. This has given broad range of integration capabilities even one cannot have imagined in their prod setup.

...more
Shivam Singh R
Shivam Singh RSource : g2crowd.com
(Reviewed on 28 November 2020) "I have used Matillion ETL to load the data from S3 to Redshift."

What do you like best?

Matillion is very fast and responds quickly. There are many components in Matillion that makes easy to transform the data as per the requirements.

What do you dislike?

Matillion is available only for cloud databases.

Recommendations to others considering the product:

Matillion can be considered as a good option for ETL when you are using cloud based database.

What problems are you solving with the product? What benefits have you realized?

I can create the the jobs as per requirement, and transform the data based very quickly with all sort of Matillion components.

...more
Yerriswamy S
Yerriswamy SSource : g2crowd.com
(Reviewed on 27 November 2020) "Sr IT Project Manager"

What do you like best?

Automation/scheduling of Matillion jobs to run the end-to-end process.

What do you dislike?

None as such, but sometimes it is confusing to set the properties.

Recommendations to others considering the product:

Great ETL/ELT tool that I have seen/used recently. Very good for orchestration of the ETL jobs.

What problems are you solving with the product? What benefits have you realized?

1. Orchestration of the data driven solutions.

2. Integration with Snowflake and AWS services

3. Automating the Data Analytics and Visualization processes

...more
Uddipan M
Uddipan MSource : g2crowd.com
(Reviewed on 09 November 2020) "Easy to use - Bigdata ELT for variety of use cases"

What do you like best?

1) The flexibility of having several transformations and orchestration components

2) Integration with many source systems

3) Easy to build

4) Easy monitoring

5) Integration with Snowflake, Redshift

What do you dislike?

non-availibilty of complete CI/CD support

Recommendations to others considering the product:

Its an easy to use, cloud-based ELT platform which can support big data ingestion and processing requirements

What problems are you solving with the product? What benefits have you realized?

Extract, load, and transform use cases for big data. Connecting with a variety of sources and extract data into a single data lake

...more
User in Computer Software
User in Computer SoftwareSource : g2crowd.com
(Reviewed on 19 August 2020) "Matillion makes data transformations easy!"

What do you like best?

Easy to use, graphical interface makes creating data workflows easy and fun!

What do you dislike?

Can be difficult to collaborate with teammates...available tools don't provide much info on potential merge conflicts.

What problems are you solving with the product? What benefits have you realized?

Pulling client data from various sources and transforming it for our own software.

...more
Paulo Henrique O
Paulo Henrique OSource : g2crowd.com
(Reviewed on 30 November 2020) "Complete ETL tool but could have a better support."

What do you like best?

Their tool is almost complete and helps a lot during the ETL process.

The interface is pretty cool and easy to be understood.

The tool performance is also something relevant and brings a lot of gains.

It was really easy to create a connection between my RDS Database, Matillion, and Redshift.

Their idea of flow it's pretty cool and easy to follow every day.

I am also using the feature of schedule the runs, which works as a job, running the entire flow as set by myself, reducing the amount of data that we would transfer if the often was less frequently.

Another nice thing is how to subscribe to their tool, I could easily manage that using the AWS Market Place where I have the option to subscribe for the product and all the costs goes directly to my AWS account and I pay per hour, so I can run and stop my instance anytime and avoid some undesired costs.

What do you dislike?

Their support team is not that fast and sometimes it's hard to find solutions on their documentation.

I had a support case which stayed open for 4 days and I didn't get any reply, I had to find a workaround by myself.

Some data types for Redshift they do not support.

Recommendations to others considering the product:

Check their documentation before subscribe and be sure that they have all you need.

What problems are you solving with the product? What benefits have you realized?

I could solve our problem by doing the whole ETL process using Matillion to extract data from RDS and send it to RedShift and do not creating a homemade tool.

...more
Mandar D
Mandar DSource : g2crowd.com
(Reviewed on 26 November 2020) "User friendly and intuitive tool for almost anyone."

What do you like best?

User Friendly (but simple) user interface is big plus point. Tools which I have used are either power full with complex User interface or simple and basic. Because of simple user interface and drag and drop functionality it provides various components right from AWS, Google Cloud, Azure and also can execute python, R scripts or custom programs.

This enables users / developer to learn it very quickly than any other tool or scripts.

What do you dislike?

Many cloud base tools always provides trial of 7 / 14 / 30 days (or some credit) so that more people can try it out. I am sure there must be reason but if you can provide such facility then more people get opportunity to try it out and provide. like google provides $300 credit along with it if Matillion provides then clients can try end to end data flow.

Recommendations to others considering the product:

There are few factors can be considered in mind

1) Minimal Learning Curve: Matillion has pre-defined courses which are very practical and takes your practical implementation. within a couple days of efforts any developer can get familier with tool and get started with project.

2) User Interface: User Interface is such that it is easier for anyone (Like business analyst) to review the flow and rectify rather than line by line coding. This makes it easier for long run

3) Cloud base: This is light weight as zero installation is required. So from developer perspective this is best thing one can get

4) Execution and validation is very quick so it can be done easily.

So I would definitely recommend tool for anyone who is starting data management project.

What problems are you solving with the product? What benefits have you realized?

our proposed flow is where we need to connect data sources from AWS (Redshift) , SQL Server and load into Big Query. So Matillion comes very handy with connectors and all possible combinations of joining, combining data at interface.

Connecting diverse datasets is huge benefit. Lot of tools do not offer cloud components. As compare to it, this is big advantage.

...more
Read All Reviews

Videos on Matillion ETL

Using an SSL HTTPS Certificate | Matillion ETL
Using an SSL HTTPS Certificate | Matillion ETL
Introducing Matillion ETL for Amazon Redshift | Available on AWS Marketplace
Tutorial | Building Your First Job | Matillion ETL for Snowflake

Customers

Tui
Tui
Docusign
Docusign
TravisPerkins
TravisPerkins

Matillion ETL Integration

98%
Google Analytics
(7955 RATINGS) Web Analytics Software

Disclaimer

The research is compiled using multiple sources, let us know of any feedback on feedback@saasworthy.com