Matillion Reviews

* 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

I like the bunch of API integrated in Matillion it helps me to directly grab the data from different sources without manually extra and import in my database.

I am using Matillion for Redshift from last more than 2 years. When i setup a project in Matillion with connection to a Redshift cluster, sometimes there is a need to extract the data from other instance of Redshift while running job in Matillion. In that case there is straight forward way of getting the data from other instance of Redshift like you have comments to extract the data from databases like SQL Server, Oracle etc. instead of first i need to run another job by connection second Redshift cluster and extract the records after that run different job to load the extracted records from S3 to main Redshift cluster.

It is very easy to implement features and changes to existing workload. It is very good for creating POCs

It is not scalable and has numerous limitations. Concurrency setting for Matillion limits the possibility of using it for multiple warehouses. It is highly insufficient when executing commands parallel and does not utilise the resources to it's full potential.
The environment limitation is also very problematic when trying to scale.

1) Most of the components are user friendly.
2) Development of ETL orchestrations and transformation consumes less time.
3) Advanced features are available in some of the components makes the complex scenarios achievable.

1) OAuth document does not provide the details of proper permissions and access levels on account_id or client_id which are required for a connector.
2) Differentiation of naming convention of metrics between the console and matillion data model , mapping document of these naming conventions is not available.
3) Connector for Outbrain is not available.
4) Indirect file loading concept is not available , for example if we have five files with same structure , reg ex can not be used to load all files in a single component(s3 load,s3 put or excel)
and need to use the file iterator.
5) Loss of properties when the component configuration is changed from Basic to Advanced features , ideally the component should include all the properties of basic and then additional setting should be provided.

It is easy to use and quick to get started, there are many inbuilt APIs and transformations that integrate it across a broad suite of systems, and enable you to transform data for the business without having to spend too much time thinking about scripts or bespoke batch files.

The filter transformer is pretty minimal considering the power of the SQL it is utilising, it cannot use compound logic or reference other columns/objects in the query.
There is also optimisation issues in very complex workspaces.
Both of these have easy to use workarounds but it is unfortunate it is not supported more at surface level.

- Easy to orchestrate an ETL pipeline
- Integration with Redshift and other AWS services provides convenience
- Support team is easy to reach and have relatively quick response times
- They also support the other 2 popular cloud data warehouses, Snowflake and BigQuery
- Some components are available out to the box for easy integration
- Task history is useful for debugging and monitoring current state of ETL pipelines
- A GUI is provided for implementing complicated workflows, that can be easily followed

- Since it's mainly GUI based, it becomes difficult for data engineers to compare changes between old and new versions of an ETL.
- There are hard limitations for the number of concurrent users. This is part of the pricing model which is the reason.
- Integration with GIT is not yet available but we heard that it would be coming in the near future.

Matillion is very intuitive.
The GUI is easy to use and fairly easy to learn.
The support team is great and they respond to your questions quickly.
I like how the Matillion team is frequently looking to add new functionality and features. The new keyword search functionality is very helpful.

Matillion works great extracting data from a variety of databases and is very efficient unloading onto S3 or Amazon Redshift. However, when we attempted to use it to unload large datasets to Microsoft SQL Server it was very slow and we experienced performance issues.

Well integrated with AWS. Great browser-based interface. Develop in the same place where the code will run, as opposed to other solutions I use that develop in Windows and run in Linux. Easy to schedule.

I have mixed feelings on the overall value. The hourly rate really adds up over time. This is probably my biggest misgiving. Otherwise, I sometimes get frustrated with the ELT model because it means if the feature you need isn't supported within Redshift, it's up to you to create Python scripts or Bash scripts to enable it.

Quick development capabilities to perform full load, incremental load with change data capture (CDC), process chains, job scheduling and monitoring, job success/failure notification, customer support to name a few

Wish to see Matillion having Github control

Easy to learn
Visual interface
Pretty reliable

Version control
Search
Explaining dependencies

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)

Very easy to use and very easy to get results. Fast implementation cycles compared to other tools. Best is to loop over variables which enables simple but powerful solutions.

Sometimes more flexibilty on specific tasks, e.g. Excel import or csv.

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!

Its very easy to learn. The UI is great and easy to navigate. It utilized the ELT approach which makes the data integration fast. Security and access control is well implemented and there are a lot of components to use.

Its a one way ETL, I'm using the BigQuery product and all the destination are in BigQuery, it would also be nice if we can load data to the sources.

Integration with GCP API calls and cloud storage.
Easy of access from anywhere.
Self documentation.
Customer service.
Automatic updates.

Failure capture process.
Any changes made not needing to be saved. Accidental changes are considered saved at click of the button.
No front end customisation available to distinguish between different environments. Having to use 3rd party add ons.

Connectivity
Really good customer service
Individual solutions if necessary
No downtimes
Hosted on Amazon

Pretty expensive
A bit hard to set up initially

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

User interface is very easy and any one can mange development things without too much of knowledge. Matillion have very content on official site and It help's a lot to make hands on on this tool.
In few click we can connect any database weather it is on premises or cloud. I have extracted data from different source system and loaded in to redshift in very easy and fast manner.

I don't see straight forward job Audit framework. Please try to build nice job monitoring and audit framework.

Inbuild features to integrate with AWS s3, send SNS messages.

Readability should be more, ease to retain changes or navigate to environment variables should improve.

Ease of Use and excellent support which makes this software likely to use in comparison to other ELT tools.

Does not compatibility with Genetics connector like VCF or BAM

Target based ETL application. Cloud Native.

I would prefer it to support multiple target DBs like SQL Server, Oracle, MySQL, Redshift, Snowflake.

Workflow Layout and clarity of all components

Environment Management, licensing model

stable, close to SQL, integrated in AWS, fast

No data vizualisation (impossible to outpout the data directly in excel... )
Complicated to separate between orchestration in transformation

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.

Matillion provides a graphical representation of any SQL query. It helps with explaining what is going on, even to people that have never used SQL before (such as my CEO). It saves me a whole lot of time from writing SQL queries by hand. What I have achieved with Matillion, I don't think I could have done manually.

Interactions with external custom APIs can be a bit of a pain, but we've always managed to get there one way or another.