Matillion

Matillion

Top Rated
TRUE
About TrustRadius Scoring
Score 8.1 out of 100
Top Rated
TRUE
Matillion

Overview

Recent Reviews

Matillion Review

9 out of 10
July 09, 2021
I have been using Matillion since March and it has been a nice experience. It's helping a lot during our ETL process from RDS to Redshift, …
Continue reading

Easy to implement and scale

8 out of 10
June 29, 2021
We are implementing ETL workflows for other organizations that we consult for. It is currently being used for smaller sized clients across …
Continue reading

Good at what it does.

9 out of 10
November 27, 2020
Being used by the financial services department for ETL processes. It does the job of cleaning and transforming our data for internal and …
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 12 features

Connect to traditional data sources (91)

9.0
90%

Testing and debugging (82)

8.9
89%

Simple transformations (92)

8.7
87%

Complex transformations (91)

7.4
74%

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Matillion, and make your voice heard!

Pricing

View all pricing
N/A
Unavailable

What is Matillion?

Matillion is data transformation for cloud data warehouses. According to the vendor, only Matillion is purpose-built for Amazon…

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?

7 people want pricing too

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 Boomi?

Boomi is a cloud-based, on-premise, or hybrid integration platform. It offers a low-code/no-code interface with the capacity for API and EDI connections for integrating with external organizations and systems, as well as compliance with data protection regulations.

Features Scorecard

Data Source Connection

8.6
86%

Data Transformations

8.1
81%

Data Modeling

8.8
88%

Data Governance

8.1
81%

Product Details

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 Integrations

Matillion Competitors

Matillion Technical Details

Deployment TypesSaaS
Operating SystemsUnspecified
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

Frequently Asked Questions

Reviewers rate Connect to traditional data sources and Data model creation and Metadata management highest, with a score of 9.

The most common users of Matillion are from Mid-sized Companies (51-1,000 employees) and the Information Technology & Services industry.

Comparisons

View all alternatives

Reviews

(1-25 of 93)
Companies can't remove reviews or game the system. Here's why
June 09, 2022

Matillion review

Sonali Aggarwal | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Easy integration with AWS Redshift and Snowflake.
  • Pay for what you use.
  • Ease of service.
  • Constant Java heap space errors because of hard limits on EC2 instance hosting.
  • It is expensive considering the infrastructure cost is added to Redshift costs.
  • Matillion does not scale well. It has a hard limit on the hardware / EC2 instances it can use.
Jay Archer | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
  • Push down query performance with Snowflake.
  • The ability to hit any API using Python.
  • A robust offering of pre-built connectors to databases, APIs, and other SaaS vendors.
  • No user community site for experienced developers to share their patterns and help grow the dev community
  • Documentation can get stale or be changed without notice.
  • Several aspects of the product are not user-friendly, and if implemented by an experienced product/UX person it would make the product easily 2x to 3x better.
  • No ability to vote on what features are in the pipeline.
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Run stored procedures on AWS Postgres RDS instances
  • Sync data from diverse data sources including production databases and APIs to Redshift data warehouse
  • Version updates often are not backward compatible. As a result updating to a new version requires a huge LOE.
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • Extremely user-friendly workflow orchestration between multiple languages such as SQL, Python, bash, and various API connectors
  • Salesforce connectors to pull and push data between systems save us a ton of time
  • Matillion Exchange workflows allow for easy sharing of templated best practice transformation jobs with ease
  • Very responsive support
  • GIT Functionality needs works, has unnecessary steps and needs "GIT DIFF"
  • A cloud hosted version would help resolve a lot of issues
  • Serverless solutions for scaling up storage and compute for certain jobs in Matillion if we wanted to run data science workflows
July 09, 2021

Matillion Review

Score 9 out of 10
Vetted Review
Verified User
Review Source
  • It's easy to understand
  • Support team
  • Good performance
  • The step of transformation is not 100% clear.
  • The price could be better.
  • Their forum is not that good.
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Easy to use
  • Flexible in the use of parameters.
  • Well integrated with insertable Json code.
  • Tables comparison automation works well.
  • Pay for use
  • It was difficult to understand how to use parameters.
  • Job validation takes long when you run a job.
  • Logging for debug is not always so clear.
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Matillion's UI makes it easier to understand the flow of data in your data pipeline.
  • Custom Python scripts make it easier to manage and manipulate variables and also to create custom functions (e.g. we use one to post messages to Slack when jobs have failed/succeeded).
  • Handling failures in processes is straightforward.
  • Passing variables between jobs (orchestration or transformation) feels a bit clunky. It can also be frustrating that you can't pass a variable back up to the calling orchestration job, you can only pass it down to child jobs.
  • It would be great to have some kind of debug mode, through which you're able to 'step through' the various tasks in an orchestration/transformation job.
  • Matillion's generic API functionality is difficult to understand. Things like handling pagination and rate limiting are complex. Although I understand improvements have been made in recent versions.
June 29, 2021

Matillion Review

Sudarshan Kothari | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • 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.
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Components available to do work with any source
  • Ability to connect to sources without preconfigured component with extensability
  • Able to kick off jobs from SNS, SQS
  • There are so many options that the learning curve could be long for a newbie
  • Can only parallelize the load in 16 partitions so it can't make use of parallelism of Redshift
  • Menu items for admins may not always work and would have to resort to shell scripting (offered)
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • It integrates well with Amazon Web Services, like S3 and Redshift
  • It makes good use of Redshift to perform ETL quickly
  • The ability to parameterize ETL jobs with variables makes it possible to get a lot of reuse from ETL jobs
  • Integration with source control is a challenge; we had to roll our own solution to pull our Matillion jobs via its API into files we could add to source control
  • It can be a challenge to avoid conflicts when multiple people are developing jobs in the same project
  • It's only available on Redhat flavors of Linux (e.g. Amazon Linux, Redhat, CentOS)
November 27, 2020

Good at what it does.

Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Easy to use GUI.
  • Grid variables and other variables make it reusable.
  • Task history helps us identify issues.
  • Need source control for the ETL scripts.
  • Need to undo features for mistakes.
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Easy to build data integration job
  • compatible with AWS cloud platform
  • lots of components for different use cases
  • No powerful job monitor console
  • Flexibility for supporting scripting languages
  • Expensive license fees
Adel Helal | TrustRadius Reviewer
Score 3 out of 10
Vetted Review
Verified User
Review Source
  • The easy-to-use GUI makes it easier for our team to pass on the knowledge and upskill engineers on our ETL processes.
  • The feature set is rich with many options to allow us to try different ways to transform our data without having to code.
  • Many different integration points allow us to plug straight into services like SQS to help us communicate with our own internal services.
  • Matillion does not scale well. It has a hard limit on the hardware / EC2 instances it can use. Most of the time that does not provide enough parallel processing for the millions of records we want to transform.
  • It is expensive considering the infrastructure cost is added to Redshift costs, so the overall value for analytics is something we are constantly challenging.
  • Constant Java heap space errors, again this is because of hard limits on EC2 instance hosting.
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Ease of use.
  • Multiple source feeds.
  • Very good integration with Redshift.
  • Provides a lot of flexibility with Python scripting.
  • Target should always be Redshift or it gets complicated.
  • Python scripts not in Jython don't comply with commit/rollback blocks.
  • Excel input component is too slow and you are better off processing it in Python.
October 05, 2020

Simple and Powerful

Score 7 out of 10
Vetted Review
Verified User
Review Source
  • Super easy to use. Anyone can start using it with very little previous experience.
  • Lots of connections available to fetch data from most popular sources available.
  • Great UI.
  • Not very much scalable. Sometimes there are server shutdowns when it goes out of memory.
  • Speed of processing can be improved, but not bad.
  • SQL compilation errors are very vague and there is no way to understand what the actual error is. It steals extra time to debug.
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Clean interface.
  • Features.
  • Diversity of supported data warehouse platforms.
  • Ability to rapidly onboard new users.
  • Support can be slow to respond.
  • Minor UI irritations.
  • Upgrade process is onerous, often requiring manual intervention to successfully complete.
  • Git integration needs improvement.
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Extremely user friendly.
  • It has many different job components already built.
  • Data loads very fast.
  • Makes organizing data jobs very easy.
  • The Git workflow could be enhanced, the UI is confusing.
  • The text editor for writing SQL is too basic and could be enhanced. Because of this, I often write my code in a separate text editor and copy/paste.
Score 7 out of 10
Vetted Review
Verified User
Review Source
  • Fairly customizable: can piece together components like Legos.
  • Responsive support and good standard documentation.
  • Deployment, upgrades, and migration are very smooth.
  • Many connectors, APIs, python scripting.
  • Bugs in Zuora API; no SFDC push component.
  • Few “best practices” like Legos without instructions.
  • Next to no information in "google land" or stack exchange on gotchas or tips. Too much help in video form and not enough searchable text.
  • Pay AWS and Matillion by the hour.
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • The API component is very powerful. At our company we integrated Google Analytics and custom APIs.
  • Easy of use. Transition from an SQL developer to learning Matillion takes less than a day!
  • Last but not least is the amazing support team! We tried to integrate Elastic Search using API into our warehouse but had many issues. Finally realised that Matillion has an ES component. But the journey wasn't easy either. We had weeks long conversation with the support team in resolved one issue at a time and they in fact shared their sample server for us to test on! Hands down! They were very keen on resolving our issue rather than just giving out suggestions. And they sure did!
  • Large complex workflows can exhaust Matillion's memory. If they can work on this, it will save us memory and time to create multiple staging/temporary tables.
  • It would be great if the SNS component can also include the error message when a job fails. So, as a user I don't have to login to Matillion to check the exact reason for my job failure.