Skip to main content
TrustRadius
Matillion

Matillion

Overview

What is Matillion?

Matillion is a productivity platform for data teams.Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality data at a speed…

Read more
Recent Reviews

in my opinion, Meh

1 out of 10
March 29, 2024
Incentivized
We are moving away from Matillion to MWAA Airflow with dbt.
Maintaining source control in github is important to us.

We have used Matillion …
Continue reading

Matillion - Decent

6 out of 10
March 19, 2024
Incentivized
We use Matillion to schedule and run our ETL jobs. This helps our company to have accurate and timely data in order to make data-driven …
Continue reading

Matillion Review

8 out of 10
February 07, 2024
Incentivized
We use Matillion for loading data from various sources into Snowflake Data Lake. We have data in various source systems such as SQL …
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 11 features
  • Connect to traditional data sources (125)
    7.5
    75%
  • Simple transformations (127)
    6.7
    67%
  • Complex transformations (126)
    5.5
    55%
  • Testing and debugging (112)
    4.6
    46%

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is Matillion?

Matillion is a productivity platform for data teams. Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality…

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://www.matillion.com/pricing

Offerings

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

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

26 people also want pricing

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 Dataloader.io?

Dataloader.io delivers a cloud based solution to import and export information from Salesforce.

Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

7.3
Avg 8.3

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

6.1
Avg 8.2

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

6.9
Avg 8.1

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

8.2
Avg 8.3
Return to navigation

Product Details

What is Matillion?

Matillion is a productivity platform for data teams.

Matillion's Data Productivity Cloud helps data teams – coders and non-coders alike – to move, transform, and orchestrate data pipelines with the goal of empowering teams to deliver quality data at a speed and scale that matches the business’s data ambitions.

The vendor states enterprises including Cisco, DocuSign, Pacific Life, Slack, and TUI use Matillion to move, transform, and orchestrate their data for a wide range of use cases from insights and operational analytics, to data science, machine learning, and AI.

Native integration with popular cloud data platforms such as Snowflake, Databricks, Amazon Redshift and Google BigQuery lets data teams at every skill level automate management, refinement, and data delivery for every data integration need.


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

Screenshot of Matillion's GUI, used to orchestrate jobs with control data flow functionality, automating the ETL process.Screenshot of 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.Screenshot of 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.Screenshot of 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.

Matillion Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

Frequently Asked Questions

Reviewers rate Data model creation and Metadata management highest, with a score of 9.1.

The most common users of Matillion are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(207)

Attribute Ratings

Reviews

(1-25 of 128)
Companies can't remove reviews or game the system. Here's why
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • easy to develop ETL or ELT.
  • Possibility of creating templates with its strong parametric structure.
  • ready-made components.
  • Matillion support.
  • APIs.
  • poor git integration.
  • Having some bugs (eg, the Table creation component doesn't support the CURRENT_DATE() function).
  • Expensive
Score 4 out of 10
Vetted Review
Verified User
Incentivized
  • Ingestion of data from popular systems (Salesforce, Trustpilot.
  • Orchestration of jobs with complex decision flows (retries, parameterized jobs, conditional flows).
  • Error notifications.
  • Git integration is limited and cumbersome.
  • GUI-based data transformation makes it very hard to apply good engineering practices to data pipelines.
  • Web-based development (there is no offline version) introduces a single point of failure for developers' interaction with the platform.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
  • Web interface is good enough
  • Set of built in components available for orchestration/transformation
  • Integration with target database (Snowflake for us)
  • Static and monolithic, it will show its limits when running multiple concurrent jobs.
  • Github and versioning implementation is messy and broken. Don't use it.
  • There's not way to see/query the system resources, just wait for a server to crash due to out of memory. An admin panel would be appreciated + some env variables with updated info.
  • API implementation is cumbersome and limited.
  • There's no concept of hub and worker engine, everything happens of the same server (designing workflows and executing them). Having separate light ETL engines to run job could be better. (sort of docker/kubernetes/lambda functions).
  • Handling of variables is limited especially for returned values from sub components.
  • Some components could return more metadata at the end of their execution instead of the standard one.
  • Billing is badly designed not taking into account that the server is hosted by the client. Expensive.
  • We had several issue with migration where starting a new instance was required and then migrating the content. It was painful and time consuming also have to deal with support and engineering team on Matillion side.
  • CDC doesn't work as expected or it is not a mature product yet.
March 29, 2024

in my opinion, Meh

Score 1 out of 10
Vetted Review
Verified User
Incentivized
  • graphical user interface
  • Moving around widgets
  • options for out of box operations
  • connections
  • source control maintenance (sync w/ github)
  • poor logging, in my experience, can't see clearly what error is if something fails
  • in my experience, difficult to connect with outside tooling
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • The jobs logging UI is very unique and helps in easy debugging
  • It has a proper hierarchical structure. One can easily organise projects and related pipelines
  • Access control and sharing necessary access is easy and quick
  • I have seen good performance even with complex pipelines
  • More features should be available with Git integration such as passing environment variables, schedules from git
  • Need improvement in parallelism of job runs
  • Sometimes cancelling a job gets stuck which can be improved
Score 7 out of 10
Vetted Review
Verified User
Incentivized
  • Matillion has a rich transformation library. It provides multiple functionalities, such as join, group by, pivot, various sources, and sinks.
  • It provides the security capability as well. All the credentials can be securely stored in Matillion.
  • Reusable templates can be built which reduces the redundancy.
  • Time to production is very minimal.
  • There is a scope of making it more developer friendly in terms of reusability.
  • Many configurations required to set up the Matillion pipeline can be reduced significantly.
  • In built python executable is quite slow.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Easy to use interface - even for users without data engineering background.
  • Many native components that do not require any "programming".
  • Powerful generic profile creation to easily extract data from any API.
  • Minor topic: adjusting a generic API Query profile can be a bit tricky. It would be great if we had proper EDIT functionality/flow.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
  • Executing Snowflake scripts
  • Oracle Database Connection and Data Retrieval
  • Low Code programming by setting properties of the different components
  • Parameter Passing between jobs
  • New components for supporting other programming languages like R
  • Upgrade Send Email component with more features
  • Upgrade GIT Integration features
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • Extracts Nested JSON
  • Had good DB support for multiple products.
  • Runs in Azure where your Cloud is (may be).
  • Upgrade process is sometimes quirky with no updates listed when there are clearly newer versions.
  • Support is sometimes long winded and multiple people have to get involved.
  • Docs could be expanded as not enough installed base to make forums or Google results useful in many cases.
Callum O'Connor | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • We leveraged Matillion’s no-code principals to make data manipulation easy for our internal customers. People who don't know how to use SQL no longer need to. Everything in Matillion is self-explained with no or little coding.
  • We connected Matillion to our data warehouse to allow people to read raw data, transform it, then write results back to their sandbox databases. The drag and drop component design allowed customers to create complex data models at the speed of thought without any risk to production data.
  • With sharing capabilities between projects enabled, everyone was able to help each other when questions arose which instilled a strong sense of collaboration and community.
  • The new DPC version of Matillion uses Git principals like Commit, Push, Merge etc. This is perfectly fine for engineers, but for our use-case it means our customers will need to understand a basic level of Git. It would be great if they had an auto-commit-push setting which does it all for them.
February 07, 2024

Matillion Review

Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • ELT - Extract Load and Transform
  • Mostly a direct copy of data into the destination is handled very well
  • Managing secrets and all connections being handled using parameters/variables
  • Some connections are not straightforward to set up
  • Upgrades can get a bit complicated and require a backup instance to be created
  • Ability to email data files
Matthew Belo | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Provides seamless, end-to-end replication
  • Works tirelessly with the customer if there are any issues
  • The customer service team needs to improve interaction with the customer
  • Provide documentation to current customers on new features that are added so that we don't have to find out either ourselves or have to search through the FAQ pages
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • Executing Python scripts
  • Data Lineage
  • Easy to search of objects included in our project
  • Creating job templates
  • Jobs metadata to be available in Snowflake
  • Error messages some times are not so clear
  • Job Optimization recommendation
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Transformation of data
  • Efficient SQL query generation passed down to DB engine
  • Structured and unstructured data handling options
  • Data exploration and data transformation option availability
  • Monitoring and reporting on errors
  • Expansive API profile options
  • Data quality testing / monitoring options
  • Extended grid iterator limits
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Checking the sample records to verify the code has been correctly implemented
  • Generation of SQL in Matillion helps to debug the code easily
  • Use of grid variables helps in solving complex scenarios
  • Implementing slowly changing dimensions
  • Scheduling the tasks based on events
  • Implementation in change data capture
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • Really good user interface
  • No complexity for anyone without much technical experience to get familiar with the tool
  • Efficient in loading and transforming data
  • Prevention of application crashes during huge volume of data load
  • Improvement of button and default home page of UI
  • Font size too small for few tabs
Return to navigation