Matillion ETL Other Advice
Overall, I would rate it nine out of ten.
View full review »MG
Michael Grayson
Director of IT Operations at a financial services firm with 10,001+ employees
Before switching to cloud databases, you need to understand the cost of Snowflake and AWS. You need to understand the costs of porting the data over and replicating it. If you are going for Snowflake, I would 100% advise you to go for it. It helps you get where you need to be. I would rate the product ten out of ten.
View full review »The main thing to consider before using Matillion is the specific reason you want to use a tool like it. If you need a combination of data ingestion and transformation, then Matillion can be a great option.
Additionally, if you expect to load large volumes of data that will be used across multiple avenues, Matillion is a good choice. On the other hand, if you only need data ingestion and with more manageable volumes or ingesting streams, it might be better to look at a tool like Fivetran. However, they charge you based on the volume of rows or records you ingest. So, if you ingest large volumes, your costs can rapidly increase and overtake your maintenance costs.
Overall, I would rate Matillion ETL an eight out of ten.
View full review »Buyer's Guide
Matillion ETL
April 2024
Learn what your peers think about Matillion ETL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,578 professionals have used our research since 2012.
I am using the latest version of the solution. The solution's connectors saved us the most time during data transformations.
Overall, I rate the solution a nine out of ten.
If the product enhances the CDC functionality, I would rate it a ten out of ten. I would recommend people to use the solution. Overall, I rate the solution a nine out of ten.
View full review »- Experiment and test it ASAP
- Watch all the videos from Matillion
- Join their webinar series
- Talk with existing users
Remember, what Matillion does is simply orchestrate the required jobs. It stands back and lets Redshift do what it is good at.
View full review »The decision to use Matillion ETL depends on the specific requirements. If the requirements can be met without Matillion ETL in a short amount of time, then using it would be unnecessary. However, if dealing with large data sets and frequent data migrations to and from the cloud, then Matillion ETL would be a suitable choice.
I have a lot of experience in this field of data and I was able to achieve results with Matillion ETL that I was not able to with the traditional approach. The solution is helpful for large amounts of data.
I rate Matillion ETL an eight out of ten.
View full review »AS
AmitShah6
Principal Consultant at Eviden France
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.
Overall, I would rate the solution a nine out of ten.
View full review »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.
View full review »PH
Paul Hoc
Senior Data Engineer Consultant at a tech company with 201-500 employees
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.
HS
Harpreet Singh
Director of Data Architecture at a healthcare company with 201-500 employees
Give it a shot. See how easy it is to get started with the product, because the scripting which is required is minimal. Anybody who is familiar with the SQL Server platform and with SQL scripting can easily pick it up and run with it,
Overall, it is a really good product.
View full review »NV
Neel Vora
Application Developer at John Deere & Company
Anybody can help to configure and train on it, learning how to use it. This will help speed up the process.
We use the AWS version only.
View full review »The mindset of the traditional ETL tools is to off-load transformation to another server/DB. This totally misses the point of MPP and especially of Redshift. Load the data into Redshift early and then transform it inside Redshift ("ELT" not "ETL"). Matillion orchestrates the loading and transformation "pipelines", then gets out of the way whilst Redshift does what it is good at (i.e. the "grunt work").
View full review »AH
Anton Haupt
Data Architect at Old Mutual Life Assurance Company (South Africa) Limited
I would rate Matillion ETL a nine out of ten it is a very good product.
View full review »SK
reviewer2132352
Data Engineer
For those who want a cloud-based analytics platform, I would recommend this solution.
I rate Matillion ETL an eight out of ten.
View full review »We're using the latest enterprise version of the solution with the public cloud deployment model.
They're constantly improving themselves. I'm quite pleased with the pace of the number of changes that are coming out all the time.
It's a great product and I think it's very competitive. I would recommend the solution.
I would rate the solution nine out of ten.
View full review »PT
business811623
Data analyst at a tech services company with 51-200 employees
The tool seems to reduce complexity rather than boost performance. The overall process remains somewhat intricate. I don't think we've observed any performance improvements using my team. I rate the overall product a seven out of ten.
Just go ahead and take advantage of the initial free period for evaluation. The on-demand price is also very competitive.
View full review »ID
SeniorIn7f6d
Senior Infrastructure Engineer at a tech vendor with 501-1,000 employees
It does the things that it does fairly well, but it would be nice to have some more features, like custom jobs.
Try different tools as much as you can. Make sure the different data that you are trying to sync fits in with the integration the tool provides (or at least most of them). Otherwise, you are going to be paying a lot for not using most of its features.
MH
reviewer1037319
Data & Analytics Practitioner (BIDW, Big Data) at a computer software company with 10,001+ employees
I would recommend Matillion ETL for any cloud-based operations.
I rate Matillion ETL an eight out of ten.
View full review »AG
reviewer1292532
Managing Director at a tech services company with 51-200 employees
I would recommend this solution. We plan to keep providing it.
I would rate Matillion ETL an eight out of ten.
View full review »MA
Engineer2076
Lead Software Engineer at a tech vendor with 10,001+ employees
Ask about pricing details.
View full review »It is perfect for when you need your data to never leave your environment using a robust tool. It also ensures the best security practices are deployed within your AWS account.
I have also integrated this solution with Microsoft Azure, but the best performance is with AWS.
View full review »Buyer's Guide
Matillion ETL
April 2024
Learn what your peers think about Matillion ETL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,578 professionals have used our research since 2012.