TrustRadius: an HG Insights company

Matillion

Score8.5 out of 10

236 Reviews and Ratings

Get a Demo!

What is Matillion?

Matillion is a data pipeline platform used to build and manage pipelines. Matillion empowers data teams with no-code and AI capabilities to be more productive, integrating data wherever it lives and delivering data that’s ready for AI and analytics.

Categories & Use Cases

Media

Matillion's GUI, used to orchestrate jobs with control data flow functionality, automating the ETL process.
where structured and semi-structured data can be prepared to create clean data sets that can be used with any BI/reporting/visualization tool of choice. Matillion reads and combines data across a target warehouse external storage, such as S3 or Blob.
Matillion's self-validating components, sample and row counts. If a job does fail, the warehouse queue services available with Matillion can be used get an alert to a connected email or Slack account.
the SQL component used to run custom scripts from within Matillion. With hundreds of pre-built connectors out of the box, Matillion can handle complex transformation needs.

1 / 4

Key Features

Learn about the best (and worst!) features Matillion has to offer, as determined by TrustRadius' reviewers.
Based on 236 ratings of Matillion's features
View all features

Top Performing Features

  • Simple transformations

    Simple data transformations are calculations, data type conversions, aggregations and search and replace operations

    Category average: 8.9

  • Data model creation

    Ability to create and maintain data models using a graphical tool to define relationships between data

    Category average: 8.4

  • Metadata management

    Automated discovery of metadata with ability to synchronize and share metadata with other tools like Master Data Management

    Category average: 7.5

Areas for Improvement

  • Complex transformations

    Complex data transformations are data normalization, advanced data parsing, etc.

    Category average: 7.4

  • Testing and debugging

    Tool to debug and tune for optimal performance

    Category average: 7.2

  • Collaboration

    Collaboration is enabled by a shared repository of project information and metadata

    Category average: 7.8

Reviews

What users are saying about Matillion.
View all reviews

Streamlined ETL with Powerful No-Code Capabilities

Souvendra ApiahView profile
Business Intelligence Solution Architect in Information Technology at Optimum Group (201-500 employees employees)

Use Cases and Deployment Scope

We use Matillion to build, manage and control our data pipelines for our various data warehouses in Snowflake data cloud platform.

Pros

  • Data connectivity between Source and Target Database
  • Manage different ETL environments
  • Job components for data transformation

Cons

  • Handle automatic saving of Jobs differently. User should have the option to ssave or discard any changes made.
  • External access to the execution log history in addition to see the logs from the UI.

Return on Investment

  • Matillion ETL has allow us to build and deploy rapidly ETL workloads
  • The tool is also very intuitive for ETL developer
  • The diffrent pricing options are also very interesting

Usability

Other Software Used

Snowflake, Microsoft Power BI, Oracle Database

Matillion - A great tool for building data pipelines

Incentivized
Verified User
Consultant in Information Technology (1001-5000 employees employees)

Use Cases and Deployment Scope

Matillion is used as the preferred ETL / ELT tool in our organization and has everything that we need for managing and maintaining our data warehouse in Snowflake. The built in connectors and integration with DevOps git makes pipeline creation very easy resulting in high productivity of Data Engineers. There is very detailed documentation available and Matillion support is very responsive. We have moved from a traditional on premise data warehouse to a cloud data warehouse and Matillion has made this transformation easy and sustainable.

Pros

  • Hundreds of connectors for easy integration with data sources
  • Integration with git repositories for version control and recovery of pipelines
  • Really good customer support

Cons

  • Major upgrades are frequent and require change freezes
  • Post upgrades, certain things require reconfiguration and fixing
  • Pay per hour is not the best billing mechanism as sometimes only a few minutes are needed to do some tasks

Return on Investment

  • Easier access to data
  • Improved productivity of Data Engineers
  • Automated version control and documentation
  • Faster data delivery

Usability

Alternatives Considered

SQL Server Integration Services, Apache Airflow, Alteryx Platform and Looker Studio

Matillion powers our BI stack

Incentivized
Verified User
Manager in Finance and Accounting (201-500 employees employees)

Use Cases and Deployment Scope

As a digital company we do have several different B2B and B2C systems. Mostly their data is about the same but as anywhere else, nothing is unified. We use Matillion in order to load all of the different source systems and transform and unify the data. It fully empowers our DWH based on AWS redshift.

Pros

  • Using different type of sources
  • Simplify SQL statements by providing an nice UI
  • Team collaboration between the data engineers

Cons

  • Template system
  • Data inspection playground

Return on Investment

  • Speeding up the process of having data available in the DWH
  • Transparent overview for everyone what happens during the DWH build

Usability

Other Software Used

DBeaver, Tableau Desktop, Tableau Server

Matillion experience

Incentivized
Verified User
Engineer in Engineering (201-500 employees employees)

Use Cases and Deployment Scope

We use Matillion for data warehousing solution and building scalable and optimized pipelines to transfrom data. Also we use it to schedule the data pipelines to ensure the data refresh will happen on time.

Pros

  • Transform data
  • Inbuild toggles to use python and related libraries
  • Git integration

Cons

  • Task optimization
  • Memory optimization

Return on Investment

  • Easier to debug
  • Easy to build pipelines from scratch

Usability

Alternatives Considered

Dataiku and Azure Databricks

My Matillion Review

Incentivized
Verified User
Professional in Engineering (5001-10,000 employees employees)

Use Cases and Deployment Scope

Use Matillion to fetch data from third-party apps to our own app

Pros

  • Its AI is very smart and helpful
  • UI is pretty good, easy to use
  • Support is fast and useful

Cons

  • Support more external apps
  • Support more features, for example file&image download
  • Support more extensions, for example let end user can add some code to handle data

Return on Investment

  • Faster ETL workloads
  • Easy to configure how to connect to external apps
  • Transformation is simple

Usability

Other Software Used

Eclipse, ChatGPT, Apache Camel

Related Products

Products similar to Matillion that may also meet your needs.
All comparisons
Informatica Intelligent Data Management Cloud
CompareLearn more
Qlik Talend Cloud
CompareLearn more
Fivetran
CompareLearn more