Matillion

Matillion

Top Rated
TRUE
About TrustRadius Scoring
Score 8.1 out of 100
Top Rated
TRUE
Matillion

Overview

Recent Reviews

Matillion Review

9 out of 10
July 09, 2021
I have been using Matillion since March and it has been a nice experience. It's helping a lot during our ETL process from RDS to Redshift, …
Continue reading

Easy to implement and scale

8 out of 10
June 29, 2021
We are implementing ETL workflows for other organizations that we consult for. It is currently being used for smaller sized clients across …
Continue reading

Good at what it does.

9 out of 10
November 27, 2020
Being used by the financial services department for ETL processes. It does the job of cleaning and transforming our data for internal and …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 12 features

Connect to traditional data sources (91)

9.0
90%

Testing and debugging (82)

8.9
89%

Simple transformations (92)

8.7
87%

Complex transformations (91)

7.4
74%

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Matillion, and make your voice heard!

Pricing

View all pricing
N/A
Unavailable

What is Matillion?

Matillion is data transformation for cloud data warehouses. According to the vendor, only Matillion is purpose-built for Amazon…

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Would you like us to let the vendor know that you want pricing?

7 people want pricing too

Alternatives Pricing

What is Fivetran?

Fivetran replicates applications, databases, events and files into a high-performance data warehouse, after a five minute setup. The vendor says their standardized cloud pipelines are fully managed and zero-maintenance. The vendor says Fivetran began with a realization: For modern companies using…

What is Boomi?

Boomi is a cloud-based, on-premise, or hybrid integration platform. It offers a low-code/no-code interface with the capacity for API and EDI connections for integrating with external organizations and systems, as well as compliance with data protection regulations.

Features Scorecard

Data Source Connection

8.6
86%

Data Transformations

8.1
81%

Data Modeling

8.8
88%

Data Governance

8.1
81%

Product Details

What is Matillion?

Matillion is data transformation for cloud data warehouses. According to the vendor, only Matillion is purpose-built for Amazon Redshift, Snowflake, and Google BigQuery enabling businesses to achieve new levels of simplicity, speed, scale, and savings.

Users can develop custom Transformation jobs by combining Filters, Joins, Aggregates, Calculators, Ranks, as well as more complex transformations such as Rankings, window calculations, and change-detection by dragging and dropping these onto a canvas GUI. Use Orchestration features to automate ETL workflows with scheduling, notifications and alerting, and control flow.

Once jobs are built, run them with component level validation and data sampling. For any custom or unique needs, Matillion also has Bash and Python Script components to give users extensibility and flexibility.

Shared Job templates, Dynamic and Grid variables, and Version control help development teams share resources across Matillion instance.

Enterprise customers gain additional auditing and permissions, automatic job documentation, data lineage and more. Learn more about enterprise features here.

Each product comes with a set of warehouse specific features to help users get the most out of the platform. Their Product Feature pages on matillion.com provides more information.



Matillion Features

Data Source Connection Features

  • Supported: Connect to traditional data sources
  • Supported: Connecto to Big Data and NoSQL

Data Transformations Features

  • Supported: Simple transformations
  • Supported: Complex transformations

Data Modeling Features

  • Supported: Business rules and workflow
  • Supported: Collaboration
  • Supported: Testing and debugging

Matillion Screenshots

Matillion uses an easy to follow GUI. Orchestrate your jobs quickly and simply with control data flow functionality, automating the ETL process.Bring your data together. Use Matillion to read and combine data across your target warehouse external storage, such as S3 or Blob. Then prepare your structured and semi-structured data to create clean data sets that can be used with your BI/reporting/visualization tool of choice.Develop confidence in your ETL jobs with self-validating components, sample and row counts. If a job does fail, use warehouse queue services with Matillion to get an alert to your email or Slack account.With hundreds of pre-built connectors out of the box, Matillion is well equipped to handle your most complex transformation needs. In case you need a bit more flexibility for unique use cases, use the SQL component to run custom scripts from within Matillion.

Matillion Videos

Matillion ETL for Amazon Redshift
Matillion ETL for Snowflake
Matillion ETL for BigQuery
Siemens Power and Gas Use Matillion ETL for Redshift from AWS Marketplace to Speed Data Analytics
Thrive Market Use Matillion ETL for Amazon Redshift to Revolutionize Their Data Warehousing Strategy

Matillion Integrations

Matillion Competitors

Matillion Technical Details

Deployment TypesSaaS
Operating SystemsUnspecified
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

Frequently Asked Questions

Reviewers rate Connect to traditional data sources and Data model creation and Metadata management highest, with a score of 9.

The most common users of Matillion are from Mid-sized Companies (51-1,000 employees) and the Information Technology & Services industry.

Comparisons

View all alternatives

Reviews

(1-25 of 93)
Companies can't remove reviews or game the system. Here's why
June 09, 2022

Matillion review

Sonali Aggarwal | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
I have used Matillion in various projects in my company for different pharma clients for Life Sciences data. We were building solutions for clients which can help the analytic users and other down streams to consume data as per their requirements. In other Healthcare Analytics Projects, we were extracting the data from different sources like Facebook and Google Analytics and building a repository using Matillion ETL. Matillion was user-friendly and easy to learn and easily integrated with AWS Redshift and Snowflake DBs.
Jay Archer | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
We are using Matillion to centralize our data to a new data warehouse. Our primary use case is pulling data from a relational database (MySQL). I've been able to implement three different flavors of data sourcing, the two primary types being a full table load and incremental data loading of changed data into Slowly Changing Dimension and Fact tables in the DW. The performance of Matillion combined with Snowflake is astoundingly fast. We are also able to hit APIs to Zendesk and Hubspot easily to round out our integration with other SaaS vendors in our stack.
Score 10 out of 10
Vetted Review
Verified User
Review Source
Matillion is helping resolve use-cases related to transparent orchestration workflows. These workflows often involve custom Python, SQL, staging locations, and sending data to external systems such as Salesforce and cross-channel marketing platforms all in one workflow. When FiveTran & DBT don't meet our exact requirements and use-case, we use Matillion to help resolve these use-cases in an easily understandable workflow that technical users, new engineers, or non-technical users can understand/troubleshoot.
Austin Lee | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Matillion is being used to transform and integrate data in our organization. Most of the data that we highly rely in decision making and planning is well analyzed by this great product. Data is safe for use in our departments can easily be saved in the cloud for free for future use.
July 09, 2021

Matillion Review

Score 9 out of 10
Vetted Review
Verified User
Review Source
I have been using Matillion since March and it has been a nice experience. It's helping a lot during our ETL process from RDS to Redshift, both on AWS. I really appreciate the software features and their support team is always able to clarify doubts and lead us to the best solution for our business.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We have been using Matillion for a specific project in the SupplyChain area. The ETL works well and it was really easy to implement. We didn't use many objects, but we still were able to implement everything we needed, such us datamarts and file exports. We also tested the connection with SAP and we were happy to see it worked correctly. Something I think could be useful is a tool to move jobs between different environments: export/import upload. Json is ok but doesn't allow us to manage to version, and moreover, if you are moving many files, you need to manually substitute the original job with the new one.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Matillion is being used by the BI Team to orchestrate the population of the Data Warehouse. The Warehouse, in turn, is used to produce a range of reports across all business functions in the organisation. We use Matillion to ingest data from an application database (hosted in AWS), Salesforce, Netsuite and Google Analytics
Score 9 out of 10
Vetted Review
Verified User
Review Source
Used by developers and business analysts in the IT department to extract and transform data into our Snowflake data warehouse. We have different data sources after a company merger and needed combined reporting. We also needed to pull data from third-party data sources such as Xero, Google Analytics, and so on.
Score 8 out of 10
Vetted Review
Verified User
Review Source
We are implementing ETL workflows for other organizations that we consult for. It is currently being used for smaller sized clients across the whole organization. We use Matillion to automate the ingestion and transformation of data pipelines. We utilize Snowflake as a data warehouse, so we use Matillion as the tool to load data into the Snowflake database.
June 29, 2021

Matillion Review

Sudarshan Kothari | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
iQuanti is a Digital Marketing organization, which drives strategic decisions based on a data-driven approach and for this we use Matillion as our ETL solution tool for our organization, which is consumed by our Data Management team. We have large numbers of the digital platform from which we report and analyze the performance. Matillion helps us to automate most of our reporting needs by providing connectors to digital platforms like Google Analytics, Google Adwords, Facebook, Bing, JIRA, Google BigQuery, and various Data source connectors like Postgres, SQL, MongoDB along with AWS support as SNS, S3 etc, which provides lots of flexibility in today's world.
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use Matillion for Redshift to ETL data from various sources into our data warehouse which is used across the organization with the desire to share it with external users in the market too. It allows us to seamlessly integrate within the AWS stack and even outside so we don't have to think twice about whether we will be able to ingest data from any new source.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Matillion to bring together data from multiple sources - our application, Salesforce, Qualtrics, etc. - into a central data warehouse for use throughout the business in reporting, both internally and externally. Matillion performs the ETL that transforms this raw data into a structure in Redshift useful for reporting.
Adel Helal | TrustRadius Reviewer
Score 3 out of 10
Vetted Review
Verified User
Review Source
We still have an old-fashioned process in our monolith environment to extract-transform-load from a SQL server data store. Currently the monolith is the main product of the CM brand and is still being heavily maintained. The way we are moving forward is to "unlock" the data from its current storage in order to have better analytics using event streaming. For the time being, the only way we are able to extract large amounts of data from our relational SQL data store is using the ETL process through Matillion into our data warehouse solution in Redshift.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Matillion was used in order to create a Redshift Data warehouse solution. Where the Data warehouse followed the Inmon module and on top of that is a Data mart with multiple aggregations. It was the product of choice for BI needing to move from an old ETL tool and DB.
October 05, 2020

Simple and Powerful

Score 7 out of 10
Vetted Review
Verified User
Review Source
Matillion is being used only by data engineering team, which is part of Data Science department. It's our ETL tool to populate our data warehouse on Snowflake. Orchestration jobs are running on a daily basis and are basis of BI reports, which are used across the whole organization. Except that, it's used to generate new feature sets for data scientist for modelling.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Matillion is primarily used by our Data Engineering team to produce highly curated datasets for use by our clients. We transform extensive volumes of client and vendor data into a highly clean and valuable artifact. Matillion is our primary ELT tool and has displaced a number of other tools previously used by our organization.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Matillion is our ETL tool to populate our data warehouse running in Google BigQuery. In conjunction with Google Data Studio, we have a daily process used across the whole business with up to date financial, commercial and project data. It is managed by the Technology Team but the whole business sees the results.
Score 10 out of 10
Vetted Review
Verified User
Review Source
Matillion has been used to clean, integrate and transform data from multiple sources are prepare data for data visualisation to answer key business questions at our organisation. Our business problem was finding an ETL solution as we moved towards Cloud data warehouse. We right away knew Matillion is the best fit for us.
Paul Cebulski | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We started using Matillion a couple years ago across all areas of our business. We use this tool to gather data from various data sources (SQL, Google Sheets, API calls, etc.), and transforming it and eventually outputting to our data warehouse for data visualisation.