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

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
  • Simple transformations (116)
    9.3
    93%
  • Connect to traditional data sources (115)
    8.8
    88%
  • Complex transformations (115)
    7.5
    75%
  • Collaboration (103)
    7.4
    74%

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…

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?

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

8.6
Avg 8.2

Data Transformations

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

8.4
Avg 8.4

Data Modeling

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

8.2
Avg 8.2

Data Governance

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

8.2
Avg 8.2
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 Simple transformations highest, with a score of 9.3.

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

(199)

Attribute Ratings

Reviews

(1-25 of 117)
Companies can't remove reviews or game the system. Here's why
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Matillion provides a very intuitive way of handling all types of ETL processes. There are tons of built-in components for data sources, such as Google products, where Sheets is a great example that we use for manual data input. And with ease, you can set up API query/extract profiles to get data from all types of API.
February 07, 2024

Matillion Review

Score 8 out of 10
Vetted Review
Verified User
Incentivized
It is well suited for direct data transfer from source to destination. Emailing success/failures of jobs is a bit complicated. Also, upgrades are quite frequent which do take time and testing and setting up backup instances. We always have to remember to keep the backup instance off and remember to delete it after the upgraded version has been tested.
Matthew Belo | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
The current evolution of their CDC offering is where it should have been in the first place. That offering provides replication direction from the PG database to SF without any intermediate steps. The previous version had too many steps: ready from PG, write to S3, run ETL to push to SF, and there were opportunities for missed transactions. Where they need to grow for us is to allow end-to-end replication from PG-to-PG, SF-to-PG, and SF-to-SF. Those are handled by competitors, so it would help them close the gap.
Callum O'Connor | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Matillion lowers the bar for entry into the world of data transformation. it's low-code design, simple drag'n'drop visualisation and SQL code generator makes data transformation easy and educational for those starting off in the world of data. For refactoring, we’re able to take existing complex SQL models, re-create and visualise them in Matillion, change the design, then use the SQL output from Matillion to create new data models in our repos.
Matillion has completely changed the way we serve data to our internal customers at the company; we've exported capability and empowerment rather than allowing ourselves to get swamped with tickets and requests for every possible data question. It's a great tool for getting people to self-serve their own answers to questions about their data.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Strengths:Cloud Processing Efficiency:Matillion's strength in cloud processing aligns well with its design for integration with cloud data platforms. It's optimized for handling large-scale data transformations and processing in cloud environments.Time Savings for Data Engineers:The tool's efficiency and user-friendly features for data engineers contribute to time savings, allowing the team to focus on more strategic and complex tasks rather than spending excessive time on routine ETL processes.Challenges:Slower Excel File Processing:The noted challenge with slower Excel file processing highlights an important consideration. Tools optimized for cloud data processing might face limitations when dealing with certain local or non-cloud file formats.Complexity for Non-Tech Users:The perceived difficulty for non-tech users aligns with the typical trade-off in ETL tools. While Matillion provides a visual interface, the complexity of ETL processes may still present a learning curve for users without a technical background.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Matillion is a very easy to use tool, does not require much experience in the tool to start using it, so juniors and new joiners can start working with it easily.
Matillion has so much components that fits majority of our business needs.
A mising point in Matillion is the metadata to be available in Snowflake.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Matillion is great any time ETL or ELT is needed. I've now used Matillion in 2 different companies and would have no problem recommending others to use it as well. The ease of setting up schedules to just take care of data imports and manipulation is incredible. IT has also been an incredible tool at bringing disparate databases together on a schedule so that I never have to think about it.
September 07, 2023

A Necessary tool

Score 7 out of 10
Vetted Review
Verified User
Incentivized
Performance is nice, but if you need creating a complex pipeline, you required long hours for developing the job can be really expensive, every minute is billed in design phase.

On the other hand. Matillion help us for integrate data sources like netsuite, HubSpot and others.

Score 9 out of 10
Vetted Review
Verified User
Incentivized
It does a great job in data transformations with easy to understand and follow steps, if done correctly. It allows you to check data samples within each step and allows to analyze what query is going to be passed down to the engine to cater for performance improvements. Performance of going through millions of rows of data is quite amazing. So far we have had minimal down time and maintenance windows.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Matillion is best suited for loading data from various external sources, Matillion is capable of loading data from almost any of the external system. Matillion needs to add some features for and components to implement slowly changing dimensions. Also Matillion can be made more capable of scheduling jobs based on events in addition of time .
Timothy Doolan | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
It's a fantastic ETL platform. Easy to set up and use. I wouldn't use it for small workload or where adhoc ETL is required. But for day to day operations. It has many benefits for medium to large enterprise businesses.
March 28, 2023

Solid ETL tool

Score 7 out of 10
Vetted Review
Verified User
Incentivized
It isbsuited to low or no code environments where you are linking multiple data sources or systems together and want to leverage automation. Especially small teams where resouce is tight and a pool of developers arent available.
It is difficult to justify if you are not required to make changes and are using large scale systems like AWS and have developer resource available as its probably cheaper and easier to do the ETL in glue jobs and make the developers responsible.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Matillion is well suited for organizations who would like to start on small scale as Matillion has their offerings on AWS marketplace.
Matillion is quite good when it comes to cloud connectivity
One of the best tool while working with Snowflake
Vinod Kumar C | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
I prefer Matillion for:
  1. Salesforce integrations. Not just extracting the data from Salesforce, but it has capability to even push the data to Salesforce.
  2. API integrations: Nowadays, all the applications are exposing their data using APIs instead of direct connectivity for security and other reasons, and Matillion has the ability to extract from all kinds of API sources.
  3. The ability to run the same job in other environment by setting up different environments within the same project.
Scheduling is very basic and does not have advanced capabilities. So this needs to be improved.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Matillion is a great tool for mid sized data platforms. Most of the components are easy to understand and data movement is swift. Matillion's documentation is less than desirable and the customer support is at minimum painful.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Matillion is very strong when it comes to its SQL components and plays very nicely with loading files from S3 to Redshift. It is less desirable for those who want to use a lot of python though, at that point their experience would be limiting.

Trupal Patel | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Matillion is powerful and easy-to-use data integration and transformation platform which can handle large volumes of data like our company where we process billions of data every day. Also, it's customer support helped our team to achieve our goal on time.We use AWS in our company and Matillion provide integration with it
Sahil Bhange | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Matillion is well suited for:Data warehouse with moderate technical skill can do wonder with SQL based ELT data pipelinesIf Org has data lake in Snowflake or other Cloud database, Matillion can access all data and DWH/BI team can create their data marts with less frictionReduces dependency on highly technical folks for data processing.

Matillion is less suited for:
Complex machine learning and data science task.
September 21, 2022

Matillion, a nice ETL tool.

Score 10 out of 10
Vetted Review
Verified User
Incentivized
I always suggest Matillion for organizations that do not want to spend money and time developing their own ETL tool, Matillion is a mature one and meet all requirements about it. It is important to check if you have any edge case and have a look if it is covered by Matillion or not.
Return to navigation