I use Matillion ETL for wrangling or transforming data from sources like S3 and Databricks.
External reviews
85 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Matillion is easy to use and a helpful ETL scheduler
What do you like best about the product?
The canned 3rd party integrations are handy.
The scheduler is very handy.
The webhook to send Slack messages for failures is awesome.
The scheduler is very handy.
The webhook to send Slack messages for failures is awesome.
What do you dislike about the product?
The Github integrations is not very feasible or easy.
We've moved to Github directly, and then use a Python component to read in and execute our ETL scripts stored on Github.
There is a weird redirect every time I sign in that makes me have to load the page twice.
We've moved to Github directly, and then use a Python component to read in and execute our ETL scripts stored on Github.
There is a weird redirect every time I sign in that makes me have to load the page twice.
What problems is the product solving and how is that benefiting you?
Running ETL jobs fairly reliably. It transforms and loads data into Redshift which is how we run our business.
We also have predictive models now running each day through Matillion.
We also have predictive models now running each day through Matillion.
Lead data analyst
What do you like best about the product?
It's point in click interface and host of component s that can connect to third-party services makes it very easy for more junior analysts to get involved in ETL workloads.
What do you dislike about the product?
Because of the point and click interface, it lacks flexibility that other more code heavy solutions offer.
What problems is the product solving and how is that benefiting you?
It has really helped bring together disparate data sets and transformed all under one roof that can feed our business intelligent solutions.
Great for most ETL use cases. A few limiting factors to consider
What do you like best about the product?
The speed of development, user-friendly UI, and the extensive options available for importing data.
What do you dislike about the product?
A few more options for exporting data. A more user-friendly way to pull raw data from APIs directly.
What problems is the product solving and how is that benefiting you?
Most of our ETL processes are simplified by Matillion. It does make the process of improving and changing ETL much faster.
Used for wrangling or transforming data from sources like S3 and Databricks
What is our primary use case?
What is most valuable?
The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation.
What needs improvement?
Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more. There is some room for improvement in job clusters for Databricks.
For how long have I used the solution?
We have been using Matillion ETL for three years.
What do I think about the stability of the solution?
Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more.
I rate Matillion ETL an eight out of ten for stability.
What do I think about the scalability of the solution?
Around 100 users are using the solution in our organization. There is a possibility of creating multiple nodes for the solution. However, you need to manage the separate nodes and upgrade the Linux, which is difficult.
I rate the solution an eight out of ten for scalability.
How are customer service and support?
The solution's technical support is great. They respond within a few hours and close the case as soon as possible.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
I previously used Informatica PowerCenter and Informatica Cloud. We switched to Matillion ETL because it was cheaper.
What's my experience with pricing, setup cost, and licensing?
Matillion ETL has a pay-as-you-go pricing model of a few dollars per hour of runtime.
What other advice do I have?
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.
Helps in the implementation of Snowflake but lineage is weak
What is our primary use case?
The tool's primary use case is implementing Snowflake, including building a data warehouse atop our source systems and facilitating data exchange with customers and suppliers utilizing Snowflake.
What is most valuable?
The tool's middle-dimensional structure significantly simplifies obtaining the right data at the appropriate level. This feature makes deploying our applications easier since we utilize a single source without publishing data from various sources. Consequently, presenting data becomes more straightforward, and customer interactions involve no copying or pasting, streamlining the exchange process.
With Matillion ETL, we read data from different warehouse source systems. We create a unified version of the data in the data warehouse using the ETL functionality. Mapping tables address the challenges of different source systems, ensuring the data is at the correct level of detail. It is very strong and comes with much functionality, including monitoring.
What needs improvement?
The tool's lineage is very weak.
For how long have I used the solution?
I have been using the product for three and a half years.
What do I think about the stability of the solution?
The tool is stable.
How are customer service and support?
I haven't contacted the technical team yet.
What about the implementation team?
Matillion ETL's deployment can be done in-house.
What's my experience with pricing, setup cost, and licensing?
Matillion ETL is expensive.
What other advice do I have?
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.
Efficient data integration and transformation with seamless cloud-native integration
What is our primary use case?
We use it primarily for transferring data into our cloud data warehouse and conducting research. We rely on Matillion ETL for our data integration and transformation needs, finding its user-friendly interface and robust capabilities highly effective. Essentially, we've built a cloud-based data platform using Matillion ETL to seamlessly extract data from various sources, perform necessary transformations, and store it in our cloud environment.
In our finance-focused projects, we predominantly utilize Matillion for data warehousing tasks, particularly in the realms of finance and micro-lending. While our projects may not involve big data volumes, they often entail handling intricate datasets that require sophisticated processing.
How has it helped my organization?
The cloud-native design of Matillion has significantly impacted our video data workflows, providing a unified view across multiple data sources and serving as a centralized and secure platform. It offers a seamless experience, consolidating various functionalities into one interface, which simplifies our tasks considerably. Moving forward, we're eager to explore their SaaS offering, particularly for Redshift, once it becomes generally available. This scalable solution eliminates concerns about version upgrades, maintenance, and patching, offering a hassle-free experience.
Its versatility is impressive, as it allows us to seamlessly transition between different cloud platforms without being locked into a specific provider.
What is most valuable?
It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth. Its simplicity is such that one only needs a basic understanding of ETL processes to become proficient. With a plethora of connectors available, it seamlessly integrates with various data sources. Moreover, its native integration with AWS enhances its efficiency, utilizing lightweight instances and pushing processing tasks to registered instances, resulting in swift performance.
What needs improvement?
There's room for improvement in how it handles data streaming capabilities. Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level. This constraint means we can run about sixteen jobs concurrently at the moment. However, once we transition to the SaaS offering, scalability will no longer be an issue. With the SaaS solution, we'll have the flexibility to run as many jobs as needed, making it a natural next step in our progression.
For how long have I used the solution?
I have been working with it for six years.
What do I think about the stability of the solution?
It exhibits a high level of stability and robustness. I would rate it nine out of ten.
What do I think about the scalability of the solution?
In our small business unit, we currently have around four users, with two of them utilizing Matillion within our organization. Considering our growing needs, we're contemplating transitioning to an enterprise SaaS solution where we would share the same instance. Currently, each user is billed individually, but consolidating to a shared instance seems more efficient. Scalability is excellent when using the SaaS solution, easily reaching a rating of ten out of ten. Each data pipeline request is encapsulated within a Docker container and spun off, allowing for instant scalability. Overall, I would rate it a nine out of ten in terms of performance and scalability.
How are customer service and support?
The technical support is excellent, and consistently helpful whenever we need assistance. We frequently engage with them, and the documentation is top-notch. Additionally, there's ample support available on YouTube covering various features. We heavily rely on their documentation site for guidance and reference. I would rate it eight out of ten.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
Previously, we relied on an on-premise solution, which often posed performance and capacity challenges due to server limitations. However, this approach involved upfront purchases and heavy licensing fees, which was a different model altogether. What I appreciate about Matillion is that it's available on the AWS Marketplace, allowing for easy installation and billing directly through our Amazon bill. This integration streamlines the process, as there's no need to manage separate vendor payments for ETL services.
What about the implementation team?
It seamlessly integrates with CodeConnect, which is the AWS Git repository, but it also supports integration with any Git repository, whether it's GitHub, GitLab, or another platform. Regardless of your choice of change control tool, Matillion can accommodate it. It simplifies the process by converting JSON payloads into a usable format, allowing for easy promotion from one environment to another. There's no maintenance required from our end; it's all handled automatically by the vendor. We receive weekly patches and periodic version updates, ensuring the solution stays up-to-date without any intervention from our side.
What's my experience with pricing, setup cost, and licensing?
We pay $5.40 per EC2 running hour, and we can reduce costs by stopping and starting the EC2 instances strategically. For instance, in our production environment, we run it for sixteen hours a day, while in our data environment, it's around ten to eleven hours a day, Monday to Friday. This approach allows us to save significantly on costs since we're billed per EC2 running hour. The absence of licensing commitments makes it easy to experiment with the tool, and if we decide it's not suitable, we can simply stop the ETL instance and cease incurring charges.
What other advice do I have?
Overall, I would rate it nine out of ten.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
Stable with excellent scalability
What is our primary use case?
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.
What is most valuable?
The most valuable feature of Matillion ETL is its user-friendly graphical interface.
What needs improvement?
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.
For how long have I used the solution?
I have been using Matillion ETL for one year.
What do I think about the stability of the solution?
I would rate the stability a nine out of ten. It is quite stable.
What do I think about the scalability of the solution?
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.
What other advice do I have?
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.
Which deployment model are you using for this solution?
Private Cloud
Great for low code ELT solution
What do you like best about the product?
The users only need to know SQL to start working on Matillion, all the other technical things that demand other skill, Matillion got your back easily
What do you dislike about the product?
The poor documentation or examples about Query profiles. I think more examples to understan RSD file will be great to use it
What problems is the product solving and how is that benefiting you?
Integrate all customer datasource in a Data lake house with no code solution
A Very Capable Data Productivity Solution For Businesses
What do you like best about the product?
I like that with Matillion, we can load data directly to the database
It makes faster to get insights and operational analytics
Allows advanced use of data in machine learning
It simply makes data integration easy
It makes faster to get insights and operational analytics
Allows advanced use of data in machine learning
It simply makes data integration easy
What do you dislike about the product?
Well, not ideal for newbies. It requires lot's of training to use and understand
What problems is the product solving and how is that benefiting you?
It has been a great ETl Solution and comes with amazing data integration capabilities
An Amazing Cloud Data Integration Solution For Business - Effective and Manageable
What do you like best about the product?
Being a cloud based solution, Matillion is highly scalable
I like the top notch data security features
It comes with features that makes data integration easy
Moving and transforming data pipelines is straightforward
It's easy to use for both coders and none coders
I like the top notch data security features
It comes with features that makes data integration easy
Moving and transforming data pipelines is straightforward
It's easy to use for both coders and none coders
What do you dislike about the product?
While it's easy to use, it requires some for of training before new users can understand and she it effectively
What problems is the product solving and how is that benefiting you?
We use it for cloud data integration and it has so far worked seamlessly. I have zero complaints about the product
showing 21 - 30