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

Typical Customers

  • Freelancers
  • Small Businesses (2-50)
  • Mid-size Companies (51-500)
  • Large enterprises (500 and more)

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

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

Microsoft SQL Server

4.6
#0 Alternative to Matillion
SQL Server is a relational database management system (RDMS) designed to help businesses of all sizes analyze structured...

SSIS Data Flow Components

4.7
#1 Alternative to Matillion
High-performance SSIS components for popular databases and cloud applications

Domo

4.3
#2 Alternative to Matillion
Domo is a data app platform that transforms businesses by putting data to work for everyone.

Treasure Data Suite

5
#3 Alternative to Matillion
Treasure Data is a cloud-based customer data platform that powers the entire business to shape customer-centricity in...

Reviews

Overall rating

4.3 /5
(108)
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.

Showing 5 reviews of 108
Edward
Overall rating
  • Industry: Computer Software
  • Company size: 2-10 Employees
  • Used Weekly for 6-12 months
  • Review Source

Overall rating

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

Geographically disparate data to the cloud in 3 days flat

Reviewed on 13/6/2019

Piping and transformation billions of rows of data from geographically dispersed machines into...

Piping and transformation billions of rows of data from geographically dispersed machines into Snowflake

Pros

* If you've done any type of ETL work before, this will be a breeze. If you haven't it might take a few hours as opposed to minutes to get up and running
* The trial is full featured, get started today without waiting
* The software is on a EC2 instance in your own VPC in AWS. If you have company policies for how/where data can be processed -- you have complete control
* You can pay by the hour or the year, no hassle no fuss!

If you do encounter an issue the support organization is amazing. All questions were answered the same day, many within the hour.

Cons

More examples to work through on the transformation components would be helpful, but again... it's pretty easy

Alternatives Considered

Fivetran
Sandeep
Overall rating
  • Industry: Information Technology & Services
  • Company size: 501-1,000 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

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

Need on the fly connectivity to different instance of Redshift

Reviewed on 14/6/2019

Pros

I like the bunch of API integrated in Matillion it helps me to directly grab the data from different sources without manually extra and import in my database.

Cons

I am using Matillion for Redshift from last more than 2 years. When i setup a project in Matillion with connection to a Redshift cluster, sometimes there is a need to extract the data from other instance of Redshift while running job in Matillion. In that case there is straight forward way of getting the data from other instance of Redshift like you have comments to extract the data from databases like SQL Server, Oracle etc. instead of first i need to run another job by connection second Redshift cluster and extract the records after that run different job to load the extracted records from S3 to main Redshift cluster.

Maksymilian
Overall rating
  • Industry: Hospital & Health Care
  • Company size: 201-500 Employees
  • Used Daily for 1+ year
  • Review Source

Overall rating

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

Scaling with Matillion

Reviewed on 13/6/2019

The experience is very positive at the beginning but as the project grows and there are more and...

The experience is very positive at the beginning but as the project grows and there are more and more workloads and data being processed Matillion starts to become a bottleneck.

Pros

It is very easy to implement features and changes to existing workload. It is very good for creating POCs

Cons

It is not scalable and has numerous limitations. Concurrency setting for Matillion limits the possibility of using it for multiple warehouses. It is highly insufficient when executing commands parallel and does not utilise the resources to it's full potential.
The environment limitation is also very problematic when trying to scale.

KOTESWAR RAO
Overall rating
  • Industry: Information Technology & Services
  • Company size: 201-500 Employees
  • Used Daily for 6-12 months
  • Review Source

Overall rating

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

Matillion_Koti_Feedback

Reviewed on 24/6/2019

I like working on matillion , but this tool can be made more flexible by providing some of the...

I like working on matillion , but this tool can be made more flexible by providing some of the additional features.

Pros

1) Most of the components are user friendly.
2) Development of ETL orchestrations and transformation consumes less time.
3) Advanced features are available in some of the components makes the complex scenarios achievable.

Cons

1) OAuth document does not provide the details of proper permissions and access levels on account_id or client_id which are required for a connector.
2) Differentiation of naming convention of metrics between the console and matillion data model , mapping document of these naming conventions is not available.
3) Connector for Outbrain is not available.
4) Indirect file loading concept is not available , for example if we have five files with same structure , reg ex can not be used to load all files in a single component(s3 load,s3 put or excel)
and need to use the file iterator.
5) Loss of properties when the component configuration is changed from Basic to Advanced features , ideally the component should include all the properties of basic and then additional setting should be provided.

Joe
Overall rating
  • Industry: Publishing
  • Company size: 501-1,000 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

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

Matillion for Data Engineers

Reviewed on 28/6/2019

An easy to use tool that has allowed me to build a fully automated data warehouse to report to the...

An easy to use tool that has allowed me to build a fully automated data warehouse to report to the business, it was easy to learn and implement, and as difficult as SQL to master. 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. This being said it is a very good tool for 90% of your work.

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

The filter transformer is pretty minimal considering the power of the SQL it is utilising, it cannot use compound logic or reference other columns/objects in the query.
There is also optimisation issues in very complex workspaces.
Both of these have easy to use workarounds but it is unfortunate it is not supported more at surface level.

Showing 5 reviews of 108 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 Suite, 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.