Wir helfen Unternehmen seit 17 Jahren,
bessere Software zu finden
Über Matillion
Data transformation for cloud data warehouses. Transform your data into insights and decisions to outpace your competition.
Matillion is a cloud based ELT tool and it is very easy to use.
The scheduling of tasks is a little tricky, as we have to separately have to schedule the virtual machine to fire up and down.
Nutzerbewertungen filtern (111)
Nutzung
Sortieren nach
Nutzerbewertungen filtern (111)
Best and very much compatible ETL for Redshift
Vorteile:
1.)All the components and transfomrations availability 2.)Specially oriented for data ingestion process using all aws services like rds, s3, sns, redshift 3.)easy admin, ssl setup 4.)very easy diagromatical representation of jobs
Nachteile:
the latest button change for "switch version"
Matillion - orchestrating complex ELT for analytics
Kommentare: Our business requires us to ingest large amounts of data from customers on a frequent basis. Once typical ELT has been performed, we create customized data stores which are used in a variety of ways including modeling, machine learning and a SaaS front end. Matillion has been instrumental in our ability to move this processing from file systems to Big Query where our performance has moved from days to hours.
Vorteile:
- Provides great framework for visualizing complex queries with business users that are not SQL savvy - Logical flow of Transformation builder allowed quick transformation from file based to database based ELT - Just works! We have had very few issues with the tool over the 2 years I have been using it.
Nachteile:
- Would like a more robust scheduler - Would like built-in messaging (e.g. for job failures/success) to be able to email out. This is not provided in the version for Big Query that we are running on GCS. - Better source code control (at the transformation/orchestration level, rather than the whole project) - Always could use additional documentation in how to use some of the more complex parts of Matillion.
Matillion Usability
Kommentare: I really like Matillion ETL but I was a bit disappointed with some of its limitations and quirks, like when Twitter updated his API all my jobs stopped working and the only thing I could do was develop everything again without using the Matillion component. When I was trying to make upsert procedures on RDS Databases, I was thrilled that the Matillion component has that option, bit it simply didn't work. It seems like these functionalities haven't got the same attention of the others, I contacted the Matillion support which is simply great and these things are still going to be fixed. When I wanted specific libraries of Python, I couldn't get it working on my instance because pip was out of date and it couldn't be updated. I tried to update and I messed up with my instance. Overall, Matillion is great, when you're creating a flow of data migration and you need to parse the data before and do some automations, but there are some cases when you need something a little more specific, that's when it becomes a pain.
Vorteile:
The ease to use, Matillion has a great set of tools that make complex and difficult process more simple and fast to develop.
Nachteile:
There are many tools in Matillion that doesn't have enough attention and because of that these tools are fragile, while some of them do not work.
A powerful tool to automate complex data processes
Vorteile:
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.
Nachteile:
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.
Agile Data Engineering
Kommentare: We use Matillion to produce highly curated datasets for customers. Matillion has allowed us to move this workload entirely into the data warehouse where the final work product lives, and cut processing time from days to hours.
Vorteile:
Matillion allowed us to move a legacy ETL pipeline to BigQuery with speed, precision, and confidence. It is now used exclusively by our team for all of our ELT needs. The user interface is clean, intuitive, and allows members of the team to be immediately productive. Onboarding new users has never been easier.
Nachteile:
Feature parity between the different flavors (Redshift, Snowflake, BigQuery) is lacking, however, Matillion continues to make progress in narrowing the gap.
Matillion Review
Kommentare: We're using Matillion for all the ETL in our environement: 3000 employees, around 500 BI users, around 30 different systems that we connected to. We were able to switch some existing jobs from Talend and create a whole lot more in just 6 minutes.
Vorteile:
+ Fast & easy to use + Completely embedded into AWS environement + Comes light, it's not overloaded with stuff no one uses + Some really innovative features
Nachteile:
- Sometimes feels like not "fully under control", e.g. when a component runs into an OutOfMemory, the whole environement crashes. And there are different ways to trigger that... - Scheduling overview could be more sophisticated, it's kind of hard to have a proper overview there - Variable handling seems sometimes to be a bit difficult, e.g. when setting it in one process, it's not always set in sub-jobs - In some cases, one can see that Matillion is still "under development": Same features are available in some components, but are missing in others
First class ETL for everyone
Kommentare: We've been able to concentrate all data sources in one place and do a proper transformation and normalization of data to feed the Visualization layer.
Vorteile:
Easy to use for non-tech (engineers) users.
Nachteile:
Lacks testing stage before production and more flexibility to sample data.
Is Great
Kommentare: Overall extract and load data strategies is very powerfull
Vorteile:
Is easy and is real pay as you use, that is very important for latinoamerica business
Nachteile:
That you can't write in other destinations
Matillion Review
Vorteile:
Matillion is very easy to use. It's simplicity allows you to drag an drop components to easily create orchestrations. It also simple to create shared jobs and use the components.
Nachteile:
Although there is a decent set of components, they are not very versatile, hence I end up using a SQL script instead. For example, the S3 unload component does not allow one to specify some criteria and some fields are mandatory whereas I would not have to specify such specific criteria when doing this from an SQL script.
A good solution for a one man data shop
Kommentare: In the scope of a sole user, it's a very powerful tool. One can get a production ETL job up and running in hours starting from scratch. After a while, it's pretty hard to figure what is where and if more than one user contributes to the flows it can be painful to understand changes.
Vorteile:
Easy to learn Visual interface Pretty reliable
Nachteile:
Version control Search Explaining dependencies
If you can write SQL, you don't need Matillion
Vorteile:
Early on in the company, our non technical stakeholders could learn how to set up transformations on Matillion and build them up themselves. It is good to see the transformations visually.
Nachteile:
If you can write SQL and schedule them using DBT, you should do that. Trying to set up the same transformation that you write in SQL in 15 minutes will take you 60 mins with Matillion because you have to think differently when using a click-click software like this.
Review of Matillion as ETL cloud Engineer
Kommentare: It was great working as well learning experience , hope Matillion will come up as industry leader.
Vorteile:
Matillion integration with AWS services is flawless and has real time impact in batch jobs pulling data from on-premises to cloud platform.
Nachteile:
Restricting the number of user can access Matillion, Lot's of time huge data set get stuck and fail with many other issues lastly better full log specifically for Developer to debug the issues.
Matillion ETL For Medium to Large Company
Kommentare: Matillion has worked incredibly well answering our business needs. We have integrated it into our core business and use it daily with nearly no issues. We began with Matillion ETL for Redshift but soon switched to Matillion ETL for Snowflake and have had incredible success with it thus far. I recommend this ETL tool to any company of any size as it can be scaled to any business needs and you only pay for what you use.
Vorteile:
Matillion is easy to integrate into our snowflake system. We use it to build and create materialized tables and views, run scheduled builds, and have used it to create CDC processes. It is slick and intuitive and has a great user interface.
Nachteile:
The browser and platform crashes occasionally, about once a week. The account will log you out, but it works in real time so it usually does not delete any of your work.
Matillion is working great!
Kommentare: We are using Matillion to pull API JSON data from various systems and push that data into Snowflake. Matillion is working rock solid.
Vorteile:
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.
Nachteile:
Getting the API pulls working was a little clunky, but it came together relatively quickly utilizing Matillion's support. Their support team is fantastic!
Matillion for BigQuery - United HealthGroup Data Engineer Review
Kommentare: Very useful tool. If you're looking for a tool for your analytics data warehouse which is fast, convenient and easy to learn, then this is the tool for you
Vorteile:
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.
Nachteile:
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.
Simple and easy ELT
Kommentare: Very nice. Easy and simple tool. Yet a lot possible with python scripting feature.
Vorteile:
Integration with GCP API calls and cloud storage. Easy of access from anywhere. Self documentation. Customer service. Automatic updates.
Nachteile:
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.
Powerful, useful, not the easiest thing I've ever learned
Kommentare: We are trying to automate as many of our recurring tasks as possible -- things like grabbing data from an API endpoint, manipulating it for our purposes, and updating our own databases for clients. Matillion lets us do a lot of that on a regular schedule and once it's set up, our humans are free to focus on things humans are better at. I found it clunky to use at first, non-intuitive. I did not find the online documentation to be very helpful, I never did find a video tutorial that spoke to my needs, and some of the terminology ("orchestration" and "transformation") I still find a bit opaque, and the division of different types of functions into the blue and green widgets doesn't always make sense to me. But I've managed to put together a fairly complex set of components that does most of what I want it to do, no small thanks to the support team, who are fantastically responsive and offer really good, specific advice within unreasonably short time periods. Their personalized attention is very much what enabled me to get going. I went from essentially hating using Matillion to really enjoying it over the course of a month or two. I'm sure I've only scratched the surface of what it can do but it's very clever and clearly quite powerful.
Vorteile:
Its ability to automate repetitive tasks. Also, it has some quite useful built-in database functions that I wish MySQL had -- for example a search/replace function that can use regular expressions.
Nachteile:
It's not very intuitive and not very easy to learn (although the support team is amazingly responsive and helpful).
very good ETL Tool with some growing pains
Kommentare: it helped us a lot to build our Redshift Data Lake from the Scratch
Vorteile:
very easy to use, fast and good Customer Support, many API Connectors out of the box, well integrated in AWS Infrastructure
Nachteile:
some Problems regarding Out of Memory lags, sometimes it's better to write custom Code instead of using the Out of the Box API Connectors (faster and more stable)
Very useful product
Vorteile:
The features and ease of use are good. The transformations act as a documentation for the self because of the readability.
Nachteile:
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
In Betracht gezogene Alternativen:
Great ETL Tool for Business Users
Vorteile:
Logic drag & drop of ETL steps makes the design and documentation of each ETL processes much simpler.
Nachteile:
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.
User friendly and Advance connectors
Kommentare: I was developed around 20 to 50 mapping using Matillion and I don't see any difficulties right know.
Vorteile:
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.
Nachteile:
I don't see straight forward job Audit framework. Please try to build nice job monitoring and audit framework.
Easy to use features
Vorteile:
Inbuild features to integrate with AWS s3, send SNS messages.
Nachteile:
Readability should be more, ease to retain changes or navigate to environment variables should improve.
Matillion Review - Excellent overall
Vorteile:
Ease of Use and excellent support which makes this software likely to use in comparison to other ELT tools.
Nachteile:
Does not compatibility with Genetics connector like VCF or BAM
For AWS one of the best tool to go for
Kommentare: We are using Matillion to process real-time data
Vorteile:
Ease of deployment Migration Multiple users Pay as you go - cost saving
Nachteile:
Software updates cause sometimes an error
Very productive toolset
Kommentare: We are using it to do the extract load and transfer for our data warehouse
Vorteile:
- Quick to start - Consumption based model - Works well with Snowflake
Nachteile:
- Harder to find resources with skills - Cost relatively higher