Matillion Data Productivity Cloud Reviews

I am not specifically into ETL or data pipelines only since I am basically a data architect who is more into designing cloud-based data solutions. My focus is more on understanding the user's use cases and then designing a solution.

When it comes to Snowflake and Matillion ETL, both offer a lot of compatibility and ease of use. The improvement area could be possible if the tool provides better integration capabilities with other ecosystems, including governance tools or data cataloging tools, as it is currently an area where the solution is lacking.

I have been using Matillion ETL for fifteen years.

Matillion ETL runs the codes in Snowflake, which itself is a highly scalable product, and ultimately provides greater scalability due to the combination of both the products.

I did not contact the solution's technical support team because, most of the time, our company could resolve the issues related to the product with the information available online.

I am not able to recall the products that I have used in the past and be able to make a comparison between those tools against Matillion ETL. I have used Fivetran and DBT tools at some point in time, but I am not able to record when I use them. I know that despite using some other products in the past, my company ended up choosing and recommending Matillion ETL since its features did fit into the requirements of my organization.

The product's initial setup phase was easy. Matillion ETL is readily available from Snowflake's marketplace.

Matillion ETL and DBT help our company by making it easy for us to build data pipelines, particularly when Snowflake was used as a data platform.

Matillion ETL helps my company automate the data pipeline and allows us to optimize data workflows.

In the context of the cloud-based data platforms, the good aspect of Matillion ETL stems from the fact that it actually runs code in the platform, which is basically like a push-down approach wherein, though our company builds the pipeline using the tool, the actual execution of those pipelines happens within Snowflake.

The product supports our company's growing data needs.

The product is integrated with Snowflake. Through a straightforward process, Matillion ETL can be degraded with Snowflake.

The integration capabilities of the tool improved our company's overall data analytics pipeline.

I am satisfied with the product interface.

The product has had an impact on my company's team productivity. It is an easy-to-use tool with a simple UI and serves as a no-code ETL solution.

I recommend the tool to those who specifically use Snowflake in their companies.

I rate the tool an eight out of ten.

My primary use case involves handling standard ETL tasks. I work on processing both our company's data and third-party data sources. While I focus on these standard ETL tasks, my colleagues excel in more advanced pipeline work.

The most valuable feature of Matillion ETL is its user-friendly graphical interface.

As someone new to the data industry and with limited experience in ETL tools, I'm not familiar with other options. My background was as a university professor until about a year ago, so I'm still getting acquainted with this field. I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly.

I have been using Matillion ETL for one year.

I would rate the stability a nine out of ten. It is quite stable.

The scalability of the solution is excellent. I would give it a nine out of ten. 
Matillion is our main ETL tool, and it is the one our consultants recommend. Currently, about 30 people at our company use it exclusively for all our ETL tasks.

My advice to new users would be to start by going through the tutorials and working with example data. These tutorials are quite helpful in getting you familiar with the tool. Additionally, try working with data that you understand well, such as data from your previous work or a familiar dataset. This way, you can focus on learning how to use the tool without having to figure out complex data problems simultaneously. Overall, I would rate Matillion ETL a nine out of ten. It works very well.

We use the solution for the ETL pipelines.

I believe the biggest advantage of using Matillion ETL is its speed of development. We don't have to deal with all the details; we can operate on the component level and do a lot with minimal effort. This is the biggest advantage; for example, we can look for particular components, configure them with some metadata, and simply run it. This simplicity and speed of development make it easy to do things quickly. Additionally, the graphical interface makes it easier to visualize something and find the details we are looking for, rather than going through a number of SQL codes and trying to find the issue. Therefore, the speed of development is the biggest advantage of Matillion.

The positive aspect of this solution is that it provides a graphical interface for jobs. Another advantage of Matillion is its extensibility; if something is missing, it can be easily adjusted or custom components can be written. What I really appreciate about Matillion is that it allows us to schedule jobs, so we can track and monitor their execution on a daily basis. I also like how the solution is organized in Matillion; everything is clear and visible, and we can easily access any details we are interested in. Additionally, there is a useful feature for reporting errors, so we don't have to worry about error handling within the jobs themselves. This feature is very convenient as it saves a lot of time and effort.

Matillion ETL has great Git integration that is perfect and convenient to use.

Unlike Snowflake which automatically takes care of upgrading to the latest version and includes additional features, with Matillion ETL we need to do this ourselves. Matillion upgrades the tool quite often, but we need to manually apply it in our environment. This manual process can be done in a few minutes, but it has room for improvement.

Recently, I needed to develop a component that runs queries on Athena, one of the AWS services. Matillion ETL does not have this functionality out of the box, so having an additional component to handle this would be quite convenient. The tool is quite flexible, and there is no source that cannot be easily integrated. The developers are constantly adding new functionality from release to release, responding to market needs. The only thing I was missing at some point was a component for Athena queries.

I have been using the solution for five years.

The solution has been available for a few years now. Initially, there were some issues, but the support was excellent. If something wasn't working, we could quickly get help to resolve the issue. After a few years of using the solution, it has become very stable. We don't have any problems with Marillion ETL; I haven't experienced any surprises. Matillion ETL is very reliable; whatever we develop works.

The solution is scalable due to its cloud environment. This is the beauty of the cloud; if we require a machine with more power, CPU, and memory, we can do it on the fly. We can simply go to the configuration and change the underlying machine, which requires a quick reboot. The new instance is then set up. This is more of a cloud-related feature than a Matillion ETL feature, but it is very easy to scale. If more power is needed, it can be done quickly and easily. It is also important to note that Matillion is usually connected to a database engine, such as Snowflake, AWS Redshift, Azure Synapse, or Databricks. Most of the processing happens on the database side. However, if there is external work such as loading data from S3 or moving data, there is some load on Matillion ETL. But the majority of the work is done on the database side because it is an ELT-like tool. The data is loaded onto the database and then the transformation happens in most cases. It is up to us how we develop it, but usually, the majority of the power is consumed on the database side.

I have had the opportunity to collaborate with the technical support team a few times and have found them to be extremely helpful. They are very responsive, knowledgeable, and adept at understanding the intricacies of our issue. In my experience, the cooperation has been perfect.

Positive

At the time I joined the company I now work for, two years ago, Matillion ETL had already been introduced. We wanted to switch to something nicer and decided to move to the cloud with AWS Redshift. We also wanted to use a graphical interface for development, rather than lots of code snippets, as it would be faster and easier to maintain. With the graphical approach, it is much easier to spot and go to the root of any issues.

The deployment time depends on the configuration, but with the cloud, everything goes smoothly and we can complete it within two hours.

I believe the cost is customer dependent, so depending on the instance we have and what we can have on-premise, we can have an installation in the cloud, or we can use the hub option. This is what Matillion ETL provides directly. A rough estimation of the cost is around 20,000 dollars a month, however, this is dependent on the machine used and how Matillion ETL is used. If there is only an hour or two of processing per day, it is better to use the hub approach as we only pay for the hours used. If there is ongoing processing, then an installation in the cloud is usually the better option. Ultimately, the cost is dependent on the individual case.

I give the solution a nine out of ten. This is one of the best solutions. Matillion ETL is closely integrated with the cloud environment, which is quite common, and thanks to that, we can take advantage of services available in AWS, GCP, and Azure. I have used a few solutions so far and this is one of the best. Everything works as expected, the tool is very intuitive, the monitoring is very well-developed, and the Git integration is great. From a developer or architect's point of view, it is quite intuitive and nice to use. Matillion ETL is one of the best.

We currently have 15 developers using the solution in our organization.

Depending on the specific case and requirements; when deciding, I would take into consideration what other options are available. From an end-user perspective, I really like Matillion ETL; it is comfortable to work with and easy to set up and maintain. The solution is not perfect, but there are no other similar solutions. The support is also very good and the integration with Git is quite nice, so it is quite flexible. Even if something is not supported out of the box, we can customize components or include Python code. It also depends on the amount of data to be processed, what kind of data it is, and the underlying database engine. There are cases where Matillion ETL makes sense, but there may be cases where it is not recommended. The solution is quite flexible, with the Snowflake dedicated version or Databricks, so we can decide which underlying data warehouse to use. If the company is GCP-related, they may not want to use Redshift, but there is an option for Bitquery. If developers prefer to use Spark, the Databricks version of Matillion ETL would be a nice option. I have been using the solution for a while and I feel comfortable with it. Compared to other tools like DataStage and Informatica, I can say a lot of good things about Matillion ETL, so it is quite convenient for us.

The solution is used for data ingestion from multiple sources to Snowflake and extract and load.

The solution's most valuable feature is the CDC (Change Data Capture) component.

Depending on the use case, the solution's pricing could be improved. Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems.

I have been using Matillion ETL for more than one year.

Matillion ETL is a highly stable solution.

I rate the solution’s stability a nine out of ten.

Matillion ETL is a highly scalable solution because it is hosted on a cloud provider. So, that part is automatically taken care of. More than 100 users are using the solution in our organization.

I rate the solution’s scalability a nine out of ten.

The solution's technical support team is highly responsive.

Positive

Matillion ETL is a self-managed solution. Matillion deploys the tool. It's a SaaS offering that requires no extra deployment effort from our side. The solution can be deployed in a couple of minutes. Matillion's support team spun up the environment for us.

Since the solution is on the cloud and self-managed, your operational costs and admin efforts will decrease. The solution has saved around 15% to 20% of our operational costs.

The solution's pricing is not based on the licensing cost but on the running hours when the Matillion instance is up and running. Its pricing model is different from the traditional pricing models of Talend or Informatica. The solution was not expensive for my use case.

I rate the solution’s pricing an eight out of ten.

The solution's orchestration capabilities are pretty good. It does have an integration with DBT. I would recommend the solution to other users because it has a very clear roadmap with a good support system. The solution’s maintenance is done through an in-house team of three to four engineers.

Overall, I rate the solution an eight out of ten.

We are using Matillion ETL for extracting and integrating the data from different applications, such as SQL, and other data sources.

The most valuable feature of Matillion ETL is its ease of use. If you have had some experience with other solutions, such as Snowflake, the use of this solution will be simple.

The cost of the solution is high and could be reduced.

I have been using Matillion ETL for approximately six months.

Matillion ETL is a highly stable solution. We are using a stable version of the solution.

I rate the stability of Matillion ETL a nine out of ten.

The solution has limited scalability. However, for concurrent tasks, the solution has been scalable enough for our needs.

I rate the scalability of Matillion ETL an eight out of ten.

The support from the vendor could be better. The speed of the support could improve.

I rate the support of Matillion ETL a six out of ten.

Neutral

I have used Snowflake. However, I am beginning the using these types of tools.

The implementation of Matillion ETL is straightforward. The length of time it takes for the deployment of the solution typically can be completed in a few hours.

We did the deployment of the solution with some assistance.

The price of Matillion ETL is expensive.

For those who want a cloud-based analytics platform, I would recommend this solution.

I rate Matillion ETL an eight out of ten.

It is cloud native and designed to run on cloud warehouses. There is compatibility with many of the cloud data warehouses, as well as Snowflake, and any SQL data warehouse. It is not compatible with other ETL products.

The interface is very intuitive.

I am looking forward to seeing the expansion of the source range for their data loader product. However, I think they have done a very good job of incorporating a lot of different data sources.

I have been working with Matillion ETL for four years now.

Matillion ETL is one hundred percent stable.

I have found that Matillion ETL is infinitely scalable.

Technical support is excellent.

The initial setup was very easy.

I think it is cost conscious. It used to be very cheap and they have more recently bumped up the pricing, so it is competitive now. I would not call it cheap anymore, but it is certainly competitive.

I would rate Matillion ETL a nine out of ten it is a very good product.

I am using Matillion ETL for Snowflake. We are doing a migration project from SAP BODS  
to Matillion for Snowflake. We are migrating all the BODS data flows, workflows, to Matillion jobs.

The customer wanted to move ahead from the Oracle database and SAP BODS. They wanted to move into the cloud for their various data integration and as part of their digitalization. The customer wanted to move to a cloud-based solution. They preferred Matillion ETL for Snowflake.

The loading of data is the most valuable feature of Matillion ETL.

There are certain functions that are available in other ETL tools which are still not present in Matillion ETL. It would be good to have more features.

I have used Matillion ETL within the past 12 months.

The performance of Matillion ETL is good.

The solution is scalable.

Companies can receive a return on investment by using it.

I would recommend Matillion ETL for any cloud-based operations. 

I rate Matillion ETL an eight out of ten.

We are a consulting company. We provide services to our customers. You can use this solution for every use case for which you use an on-premise solution. You can use it for cloud data warehousing in the cloud. You can use it with other cloud databases such as Snowflake or Synapse. We are using its latest version.

The simplicity of this tool is nice. It has a good graphical user interface.

You can also do a lot of generic stuff in the tool. If there is good connectivity to a cloud database, such as Snowflake, and you can have a lot of Snowflake functionality in the tool.

It can have multi-environment support. We should be able to deploy it in different environments. 

Its integration with SAP connection is not so nice, which should be improved. It can also support an on-prem database.

We have been partnering with them for one year.

It is stable.

It is scalable like your cloud solution. We have five to ten customers of this solution.

Their technical support is very good. We are a partner, so we have a different channel. From our point of view, it is very good.

There is no installation. Everything is web-based or browser-based.

Its price depends on what you expect. You pay on a monthly basis, but there is a possibility to have special contracts depending on the installation.

I would recommend this solution. We plan to keep providing it.

I would rate Matillion ETL an eight out of ten.