Matillion Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
144 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.8 out of 100

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

TrustRadius TRUE BadgeTrustRadius Top Rated for 2020

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-25 of 88)

Companies can't remove reviews or game the system. Here's why.
November 30, 2020
Matthew Burr | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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)
Read Matthew Burr's full review
November 24, 2020
Sudarshan Kothari | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read Sudarshan Kothari's full review
August 14, 2020
Britton Gray | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Variety of connectors
  • Graphical interface
  • Source control integration
  • Some connectors have significant limitations (web services, NetSuite)
  • Runs out of memory easily
  • Logging not easily exportable
Read Britton Gray's full review
August 13, 2020
Hyrum Ward | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • The workspace is drag and drop, which makes it intuitive and easy to use.
  • Server creation and management is robust. We haven't had to worry too much about it once we got it created.
  • The job scheduler is very simple and intuitive.
  • Matillion allows you to run Python, which grants almost unlimited flexibility, even without using any other components.
  • The Python script component needs a friendlier window in which to edit your scripts. The script is not searchable, and tabbing is frustrating.
  • The High Availability server configuration was not working for us. It was allowing duplicate jobs to run, and causing a lot of confusion in the scheduler. Love the idea, but the implementation fell short.
  • Better alerting around queued jobs would be nice. Sometimes jobs start queuing and nothing runs. Usually this is the result of a badly written job, but it would be nice to get alerts.
Read Hyrum Ward's full review
October 06, 2020
Adel Helal | TrustRadius Reviewer
Score 3 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read Adel Helal's full review
October 05, 2020
Dan Reiland | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read Dan Reiland's full review
October 01, 2020
James Hull | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • User friendly.
  • Build complex workflows visually.
  • Support is good.
  • Easier email integration to mail out results.
  • Version control of jobs.
  • Ability to use external APIs to push data not just pull.
Read James Hull's full review
October 01, 2020
Chandana M | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read Chandana M's full review
September 08, 2020
Viswanath Manne | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • UI is very simple to understand and documentation complements it very well.
  • Able to mail logs for processed and errors in daily tasks.
  • Having a detailed log of daily tasks maintained in the UI is a good addition.
  • Slightly over priced for a startup.
  • I feel support is a bit slow.
  • Not all the libraries are installed in Python, would be easier if we could install them from the user side.
Read Viswanath Manne's full review
September 06, 2020
Dan Dow | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Hides the SQL code
  • Creates an intuitive UI for data flows
  • Interfaces with many third-party platforms
  • Moving data through a flow can be very tedious.
  • Errors are often obtuse and hard to pinpoint.
  • They used to auto-complete typing table names, but they removed that, making point number one all that much worse.
Read Dan Dow's full review
September 03, 2020
Aleksa Topalović | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Tailor-made for Redshift, including most of the features like Spectrum.
  • Cloud-based solution with centralized project repository, easy team collaboration.
  • Built-in scheduling and monitoring, everything in one place.
  • Awesome support, the short time from raising a question to the solution providing.
  • Documentation is not always updated in time when new stuff is implemented.
  • Some connectors already implemented still have some bugs which make them useless for our use case.
  • Small fine tuning still missing, in terms of covering all use cases of some connectors.
Read Aleksa Topalović's full review
August 29, 2020
Antonello Supino | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Visual flow of ETL
  • Integrations with GIT
  • Multi-user editing
  • Shared components portability
  • Having other databases other than Redshift as targets (such as MySQL)
Read Antonello Supino's full review
August 26, 2020
Andy Lai | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Quick to set up
  • Tailor-made for data warehouses (Bigquery, Snowflake, Redshift)
  • Graphical UI to connect all the modules
  • Easy to learn
  • Customer response time needs improving
  • SAAS model instead of charging hourly
  • Lack of documentation
  • Versioning logs not updated
Read Andy Lai's full review
August 16, 2020
Daniel Zielinski | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Connection to numerous data sources
  • Validation of objects and components
  • Ease of use to schedule run-times
  • Variable driven code development
  • Documentation examples
  • Speed of processing
  • Requires upfront investment in design of system processing.
  • Assistance with upgrades
Read Daniel Zielinski's full review
August 14, 2020
Avishua Stein | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Move large amounts of data quickly from various sources into Storage/Data Warehouse. This is important for any ETL tool.
  • The built-in API connectors are very useful and are usually granular enough to save us loads of development time.
  • Matillion usually responds to support tickets in a day or two.
  • A couple of times, we've had components stop working. We were basically told to keep checking the release notes for fixes. It would be nice if they prioritized maintaining existing components over developing new ones.
  • It can be hard for multiple users to work on the same job.
  • Most of their documentation is good, but sometimes their support pages link to missing docs.
Read Avishua Stein's full review
October 01, 2020
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read this authenticated review
January 05, 2021
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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)
Read this authenticated review
October 05, 2020
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read this authenticated review
October 05, 2020
Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read this authenticated review
October 01, 2020
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read this authenticated review
October 01, 2020
Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
Read this authenticated review
September 08, 2020
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Breaks jobs down
  • Graphics Interface
  • Has lots of AWS documentation but not as much Azure.
Read this authenticated review

Feature Scorecard Summary

Connect to traditional data sources (86)
8.3
Connecto to Big Data and NoSQL (53)
7.5
Simple transformations (87)
8.7
Complex transformations (85)
7.6
Data model creation (34)
7.6
Metadata management (41)
6.6
Business rules and workflow (75)
7.4
Collaboration (75)
6.8
Testing and debugging (77)
6.2
feature 1 (4)
8.2
Integration with data quality tools (23)
6.6
Integration with MDM tools (21)
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.

Quickly 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 your ETL workflows with scheduling, notifications and alerting, and control flow.

Once your jobs are built, run them with confidence with component level validation and data sampling. For any custom or unique needs, Matillion also has Bash and Python Script components giving you the ultimate extensibility and flexibility.

Shared Job templates, Dynamic and Grid variables, and Version control help your development teams share resources across your Matillion instance.

Enterprise customers benefit from 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 that help you get the most out of the platform. See our Product Feature pages on matillion.com for more information.



Categories:  Data Integration

Matillion Features

Data Source Connection Features

Has featureConnect to traditional data sources
Has featureConnecto to Big Data and NoSQL

Data Transformations Features

Has featureSimple transformations
Has featureComplex transformations

Data Modeling Features

Has featureBusiness rules and workflow
Has featureCollaboration
Has featureTesting and debugging

Matillion Screenshots

Matillion Videos (6)

Matillion Integrations

Matillion Pricing

  • Has featureFree Trial Available?Yes
  • Does not have featureFree or Freemium Version Available?No
  • Has featurePremium Consulting/Integration Services Available?Yes
  • Entry-level set up fee?No

Billed directly via cloud marketplace on an hourly basis, with annual subscriptions available depending on the customer's cloud data warehouse provider.

Matillion Support Options

 Free VersionPaid Version
Email
Forum/Community
FAQ/Knowledgebase
Video Tutorials / Webinar

Matillion Technical Details

Operating Systems: Unspecified
Mobile Application:No
Supported Countries:Global
Supported Languages: English