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
  • Simple transformations (124)
    8.2
    82%
  • Connect to traditional data sources (122)
    7.7
    77%
  • Complex transformations (123)
    6.5
    65%
  • Testing and debugging (109)
    5.6
    56%

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.6
Avg 8.2

Data Transformations

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

7.4
Avg 8.4

Data Modeling

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

7.3
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.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 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

(204)

Attribute Ratings

Reviews

(1-1 of 1)
Companies can't remove reviews or game the system. Here's why
June 29, 2021

Matillion Review

Sudarshan Kothari | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • Supports a wide variety of digital platform connectors, which could be helpful for any industry working to automate any of their reporting needs.
  • Support for AWS technologies adds to greater advantage.
  • Takes up unique functionality provided by the database into account which is very helpful.
  • Also provides direct SQL query feed-in option for any migration of existing solution.
  • With the added functionality available in Matillion, the understanding to use complex features becomes challenging for a new development team.
  • Updates are regularly provided by Matillion support team but then they fail to specify the release document, new features or updates carried out in each update.
  • Validation failure in scheduled jobs is sometimes encountered without any reason or proper RCA.
  • Complex user management flow.
Matillion works best when automating the workflow from the various digital platforms. It provides the best use-case for automation of any dashboarding/reporting requirement where data is stored in one of the databases and updated regularly. Matillion might not be the best use-case for core ETL operation as it lacks stability for enterprise (but is improving to high standards with every update).
Data Source Connection (2)
95%
9.5
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
90%
9.0
Data Transformations (2)
95%
9.5
Simple transformations
100%
10.0
Complex transformations
90%
9.0
Data Modeling (3)
73.33333333333333%
7.3
Business rules and workflow
80%
8.0
Collaboration
80%
8.0
Testing and debugging
60%
6.0
Data Governance
N/A
N/A
  • Our organization focuses on Data-Driven Digital Marketing Strategies, so not investing time and resources on getting the data, we ensured the time utilized much more in analyzing the data and for this purpose, Matillion was our solution and was right on a positive track.
  • Matillion has been performing positive since it's consumption in our organization in terms of investment.
  • With increasing functionality and stability in Matillion system, we could look for greater return than just replacements.
Matillion providing underline features of the database and unique functionality in connectors, increase our day-to-day work solution using the tool. For example, Snowflake database supports for JSON file system and thus using Matillion with Snowflake offers to flatten as an additional component is exceptional. Another example: Data could relive under FTP, sFTP, Cloud system (S3), databases and matillion have support to all, thus increasing the usability.
Matillion being ELT cloud tool offers easy to implement which requires an AWS EC2 instance and licensing.
Training on Matillion and getting the development team on-board was quite a challenge. Would require immense experience to explore the core functionality of Matillion. Matillion was running with-in a week time after acquiring a license but for the development team to work efficiently it took a couple of weeks.
Scalability is only one of the things which we need to keep back of our mind. While using the product for more than 18 months, we have expanded our team from 2 users to 10 users and increased utilization, Matillion performance is not par with the expectation and maturity. We always encounter the Matillion broken or cool-down period too long.
Matillion offers the unique capability of digital platform connectors (API connectors) and special functionality for Snowflake (which is our primary database). Also various sources including AWS S3, sFTP and various databases connection. In Pricing, the matillion option has economical than Informatica with our usage and Talend doesn't resonate well with flexibility, which we were looking for.
Yes, there were absoultely increased in reporting speed that our team was able to delivery. Intially we had our own scripting tool to generate result which took 2 weeks (around 80 hours of development time + testing time) whereas using matillion we were able to complete the development in 32-40 hours including one round of testing. I could say we were able to bring down 50% of development time. Please note this is after the team had grasp of matillion enviroment. Initial time taken was different. Also the quality of reporting improved.
While moving away from legacy system towards matillion it offered some significant cost on matillion hosting and licensing part but we were able to save some on legacy system hosting but majority of saving where on people resource which was huge cost saver for our organization. along with that team was able to deliver at much higher pace which was very important in service based organization to retain the client.
Our organization work in digital marketing industry and matillion do provides lots of connector related to digital marketers. Matillion was able to solve 90% of our data sources connection problem but there were few of the rarer sources which matillion din't provide the connection to. Hopefully thats part of their roadmap for near future. With being able to connect to most of the data source through matillion we were able to better estimate the development time vs older time, which required to study the connector before commiting any deadlines. And once the connector is available with Maitllion, most of the scaling problem was taken care by matillion.
Our team member had already the knowledge of other ETL tool in market which made us easier to transform to Matillion as ETL tool. Initally when there were more rigrous update on tool, it took us few months to understand all the different features of the product and use them. We used to reach out to support team regularly for clarity purpose and they were very helfpul. So that helped us to make most the maitllion tool. Once the team adapted to various naunces of the tool, we had internally developed a process/framework which made our onboarding process smoother.
10
The team is divided into 3 parts namely:
1. Solution Architect: Solution Architect helps to come with solution design of entire data flow taking into Matillion features also.
2. Developer: Developers are the person who actually develops in Matillion.
3. QA Team: QA team verify the functionality is correct as per the problem statement.


8
Experience in ETL tools like Informatica or Talend and working with SQL queries.
  • Digital Platform Connectors
  • Automating & scheduling Jobs
  • Interacting with wide sources of systems
  • Automating the reporting
  • Monitoring & tracking the scheduled jobs with automated variables option
  • Making Grid variables as an alternative to For loop
  • End-to-End Tracking of all the Jobs
  • Additional Connectors and Custom connectors building option
  • User Management Policy
With the current experience of Matillion, we are likely to renew with the current feature option but will also look for improvement in various areas including scalability and dependability.
1. Connectors: It offers various connectors option but isn't full proof which we will be looking forward as we grow.
2. Scalability: As usage increase, we want Matillion system to be more stable.
Not Sure
Product Features was one of our primary factors to consider ETL tool.
We were looking for a product which can justify to our needs like JSON support, digital API connectors, various database connection, FTP and AWS support with the scheduling feature.
Price was also another factor while bringing in any tool onboarding into the organization.
Evaluation criteria based on cloud services supported and various out-of-box support availability.
  • Implemented in-house
Yes
We had adopted software life-cycle for implemenation- Development, QA and Production Deployment.
  • was not aware of different features availability such as shared jobs
  • The timezone difference and setting configured in databases are not automatically reflected
  • Parallel jobs running are limited 4
We were able to control on access and built various enviroment for implementation
Not Sure
There are a couple of times when Matillion support team provided its extraordinary brilliance.
I would like to point out an instance when we were trying to implement tracking & monitoring in place for scheduled jobs and Kalyan (from the Support team) helped us to implement tracking which is still very helpful for our team without manually going to individual job to check the success.
Team provided the idea of "Task History Export" and another instance of using automated variable "Matillion ID" for tracking needs.
The support team was always very helpful most of the time, only have faced few issues because of time-zone difference when solutions are required immediately and I couldn't reach to anyone. In most of the cases, the support is exceptional.
  • Intergration with Cloud Services like AWS, Azure
  • Integration with Databases
  • SQL script functionality
  • Differentiate Orchestration & Transformation layer
  • Create Custom report using API integration
  • Group policies configuration
Return to navigation