Matillion reviews

I use it on a daily basis when we process incoming client data of different types. It can be used to build extremely complex workflows to handle data. The automation done on the platform rarely broke and was really stable even during peak data transfer intervals.

The changes made to the workflows on the platform are saved automatically which can be tricky if you make a change by mistake. So whenever you click a wrong button or value, it will be saved unless you undo the changes made and when working with huge complex workflows it can be really time-consuming to find the source of the issue.

I've been using Matillion for about 2 and a half years. I've seen the software improve so much in that time. If I ever found a feature to be lacking, it would be included within the next couple release cycles. The software really seems to adapt as user needs have been evolving. Some of my favorite recent features are the ability to configure some components with just text (really saves me time) and the many Grid orchestration components which allow me to greatly reduce the complexity of the orchestration jobs.

UX is sometimes lacking or inconsistent. For example, let's say my goal is to replace an existing job with a new job of the same name. I delete the old job, and import the new one with the same name. All Orchestration components that used that job will understand to use the new job, but for some reason the scheduler doesn't.
Also, jobs will have validation errors simply because the components haven't been validated (grey borders). It can be confusing because you may be searching for an error in your work when all you actually have to do is revalidate the job.

1) Easy to use
2) Several ingestion integrations
3) Custom RDBMS ingestion support
4) Robust transformation and Orchestration components

No availability of change data capture feature for many databases

Matillion is the most reliable ETL/ELT tool currently. I've worked with a larger number of clients that have uses Matillion as well as other tools and Matillion is definitely the most reliable. The UI is easy to follow and understand and the learning curve is small.

The technology isn't as intuitive as others in the space. It does require some training or knowledge of workflow development though it's the most reliable.

Matillion was very easy to set up, it allow us to quickly build out our ETL/ELT pipeline on AWS. GUI was easy to navigate, most default functions works well, it has the ability to connect to all of our required cloud data sources, and any custom function can be scripted using Python.

Python scripting is very limited, it is used mostly to assigned variables or run simple boto3 script. We tried using the python module to run heavy CPU data cleansing process and the software timed out.

It's very easy to use, great training and support.

I don't have any cons. From start to end they have been great to work with.

Logic drag & drop of ETL steps makes the design and documentation of each ETL processes much simpler.

Getting it setup and connected to our data warehouse seemed to be unnecessarily complicated. Luckily tech support is great and helped my DevOps team throughout the process.

Fast data analytics i.e. transformation and orchestration jobs.

If you are not familiar with SQL, this is not intuitive.

It's fast. Pipelines are easy to setup for very basic tasks.

Your customer support people are useless. Every time I submitted a ticket, they simply pointed to an article on the Matillion website that is not helpful in solving the problem. There is no community to resolve common issues. Troubleshooting complex tasks is almost impossible for smaller organizations.

ease of use! someone with little code knowledge can come in and understand what's going on, it's very easy to follow along and see the transformation step by step

API connectors could be better. Could be more available, and a little more ease of use (especially with the endpoint mapping)

I don't have to babysit the software. Using automation and integration with AWS, I can get messages if there are issues with any orchestration jobs.

Getting the API pulls working was a little clunky, but it came together relatively quickly utilizing Matillion's support. Their support team is fantastic!

I appreciate the ease of use of the tool. It is very simple and intuitive to build data pipelines using Matillion.

It's necessary to perform out own server maintenance to support the tool, which isn't too difficult, but can be a pain at times. If this were a hosted solution that would be easier.

Matillion offers a powerful feature set within a robust UI. There are other options but none have the ease of onboarding that Matillion offers. The API adds a powerful layer to do advanced integrations.

Some threads have become unresponsive while running. This has been rare and was easy enough to resolve by resetting the service.

* If you've done any type of ETL work before, this will be a breeze. If you haven't it might take a few hours as opposed to minutes to get up and running
* The trial is full featured, get started today without waiting
* The software is on a EC2 instance in your own VPC in AWS. If you have company policies for how/where data can be processed -- you have complete control
* You can pay by the hour or the year, no hassle no fuss!

If you do encounter an issue the support organization is amazing. All questions were answered the same day, many within the hour.

More examples to work through on the transformation components would be helpful, but again... it's pretty easy

* It's very easy to start building scalable production ready ETL pipeline.
* GUI is very intuitive.
* Has wide variety of integrations available.
*

* Error handling/debugging is on a poor level.
* No good way to version queries/scripts or jobs.
* Not really suitable if you need to build something very complex, as it's not very customizable.

The features and ease of use are good. The transformations act as a documentation for the self because of the readability.

The customer service is very poor. When they eventually respond to messages it is with an unhelpful response. Generally they will blame us for issues on their end, or they misunderstand the problem completely. It's not what we need from a tool

The paid training we took was also pretty basic

Ease of use and breadth of functionality.

We had a billing issue at one point when trying to renew but that was mostly due to AWS Marketplace and not Matillion as a product.

Pretty straightforward compared to other ETL tools, traditional engineers pick up in no time at all.

The google version is not as rich as the AWS one

The GUI and design makes it easy to not only functionalize your ELTs, but also show a graphical DAG to stakeholders.

I wish it had an out-of-the-box API gateway to receive webhook requests from third-party data sources.