Matillion

Matillion Reviews

Customer Verified
Top Rated
TRUE

Do you work for this company? Learn how we help vendors

Ratings and Reviews
(1-25 of 85)

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
Review Source
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.
Austin Lee | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
The platform flexibility in data integration and transformation has enabled me to give it this rating. The performance from my view have been awesome and there is no complain from any department since we deployed it. The work across our organization and management of data increased our trust on Matillion. The platform operation across our organization has been very recommendable in data integration and offering solutions to any uprising challenge.
Score 9 out of 10
Vetted Review
Verified User
Review Source
I appreciate that you can execute every needed step without the necessity of creating a full orchestrator. Therefore, when developing many jobs, you can test and monitor each of them in an easy way. Sharde jobs are really useful when you want to simpify the development and standardize some common steps.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We don't have a particularly large volume of data (less than 200GB), but as we've added more and more data, we are able to fully reprocess our data in about 2.5 hours (vs. over 6 hours it used to take to incrementally process our data in our old ETL system). We're not even using the Enterprise version of the product; if we did, we would get even greater scale.
Britton Gray | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
That's the beauty of a cloud-based solution, right? We can scale up if needed, although the cost jumps pretty significantly. And we can always add more developer nodes as needed given source control integration.
Score 10 out of 10
Vetted Review
Verified User
Review Source
Generally, Matillion allows you to scale the size of the servers to fit your needs. It could be easier to increase the size, but it also could be that I've been spoiled by Snowflake in this regard. Having said that, we've already had to increase the size of our server, and did it without too much trouble.
Adel Helal | TrustRadius Reviewer
Score 3 out of 10
Vetted Review
Verified User
Review Source
That is the one sticking point we have with Matillion. We have hit its hard limits and constantly face Java Heap space errors. Our recommendation from the support team was to spin up another new Matillion server which is a separate cost entirely, making it equivalent to buying two separate products off the shelf, rather than incorporating it into the one solution. One Matillion server is expensive enough, two is not feasible.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Matillion, because it relies on the computing power of cloud data warehouses, scales effortlessly to process massive data volumes. Scaling user count is the only limiting factor to growth, however, Matillion provides a number of licensing options to suit the needs of a single department to an large scale data engineering practice.
Antonello Supino | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
With Matillion, we push most of the computational load down to redshift so it's not an issue to scale up. Perhaps the instance sizes available may not fit if the load becomes too high, however, we did not face any of this issue. We are using multiple projects with multiple users and all is going well.
Score 9 out of 10
Vetted Review
Verified User
Review Source
The architecture of our enterprise data warehouse drives the scalability of the application. It is paramount to invest time and resources into building a proper data warehouse. By having a well-designed data warehouse, our ability to add new input data sources to our system allowed us to take advantage of Matillion's flexibility.

Matillion Scorecard Summary

Feature Scorecard Summary

Data Source Connection (2)
80%
8.0
Connect to traditional data sources (88)
84%
8.4
Connecto to Big Data and NoSQL (55)
76%
7.6
Data Transformations (2)
82%
8.2
Simple transformations (89)
88%
8.8
Complex transformations (88)
77%
7.7
Data Modeling (6)
72%
7.2
Data model creation (34)
76%
7.6
Metadata management (41)
66%
6.6
Business rules and workflow (77)
75%
7.5
Collaboration (78)
71%
7.1
Testing and debugging (79)
62%
6.2
feature 1 (4)
82%
8.2
Data Governance (2)
65%
6.5
Integration with data quality tools (23)
66%
6.6
Integration with MDM tools (21)
63%
6.3

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 ETL for Amazon Redshift Enables MakerBot to Become Customer Centric

Matillion Integrations

Matillion Competitors

Matillion Pricing

Matillion Technical Details

Deployment TypesSaaS
Operating SystemsUnspecified
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

Frequently Asked Questions

What is Matillion's best feature?

Reviewers rate Simple transformations highest, with a score of 8.8.

Who uses Matillion?

The most common users of Matillion are from Mid-size Companies and the Information Technology & Services industry.