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.

Erfahre mehr über Matillion

Vorteile:

Matillion is a cloud based ELT tool and it is very easy to use.

Nachteile:

The scheduling of tasks is a little tricky, as we have to separately have to schedule the virtual machine to fire up and down.

Bewertungen zu Matillion

Durchschnittliche Bewertung

Benutzerfreundlichkeit
4,4
Kundenservice
4,5
Funktionen
4,1
Preis-Leistungs-Verhältnis
4,1

Weiterempfehlungsquote

8,2/10

Matillion hat eine Gesamtbewertung von 4,3 von 5 Sternen basierend auf 111 Nutzerbewertungen auf Capterra.

Hast du Matillion bereits verwendet?

Teile deine Erfahrungen mit anderen Softwareinteressenten.

Nutzerbewertungen filtern (111)

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Gesundheit, Wellness & Fitness, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Best and very much compatible ETL for Redshift

5,0 vor 5 Jahren

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"

Bruce
VP, Data Engineering in USA
Computer-Software, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Matillion - orchestrating complex ELT for analytics

5,0 vor 5 Jahren

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.

Marcus Vinícius
Marcus Vinícius
Back End Developer in Brasilien
Verifizierter Nutzer auf LinkedIn
Finanzdienstleistungen, 201–500 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Matillion Usability

3,0 vor 5 Jahren

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.

Ujwal
Data Programmer in USA
Marketing & Werbung, 501–1.000 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

A powerful tool to automate complex data processes

5,0 letztes Jahr

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.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Computer-Software, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Agile Data Engineering

5,0 vor 5 Jahren

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.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Medienproduktion, 1.001–5.000 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Matillion Review

4,0 vor 5 Jahren

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

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Onlinemedien, 201–500 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

First class ETL for everyone

4,0 vor 5 Jahren

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.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Computer-Software, 201–500 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Is Great

4,0 vor 5 Jahren

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

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
E-Learning, 501–1.000 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Matillion Review

4,0 vor 5 Jahren

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.

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Computer-Software, 1.001–5.000 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

A good solution for a one man data shop

4,0 vor 5 Jahren

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

Melisa
Head of Business Intelligence and Data Science in Deutschland
Computer-Software, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

If you can write SQL, you don't need Matillion

3,0 vor 12 Monaten

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.

Ravi
Sr. Cloud Data Engineer in USA
Pharmazeutika, 10.000+ Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Review of Matillion as ETL cloud Engineer

4,0 vor 5 Jahren

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.

Brayden
Associate Software Developer in USA
Transport/Güterfrachtverkehr/Schienenverkehr, 10.000+ Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Matillion ETL For Medium to Large Company

5,0 vor 5 Jahren

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.

Dana
Director of Technology Operations in USA
Bekleidung & Mode, 51–200 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Matillion is working great!

5,0 vor 5 Jahren

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!

Ryan Allen
Data Engineer in Philippinen
Versicherung, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Matillion for BigQuery - United HealthGroup Data Engineer Review

4,0 vor 5 Jahren

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.

Chaitanya
BI Engineer in UK
Baumaterial, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Simple and easy ELT

5,0 vor 5 Jahren

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.

John
ICT Consultant in UK
Informationstechnologie & -dienste, 201–500 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

Powerful, useful, not the easiest thing I've ever learned

4,0 vor 5 Jahren

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).

Tobias
Senior Enterprise Architect in Deutschland
Marketing & Werbung, 1.001–5.000 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

very good ETL Tool with some growing pains

4,0 vor 5 Jahren

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)

Ellis
Marketing Intelligence Analyst in Deutschland
E-Learning, 51–200 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Very useful product

4,0 vor 5 Jahren

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

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Internet, 51–200 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Great ETL Tool for Business Users

5,0 vor 5 Jahren

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.

Jagdish
Senior software engineer in Finnland
Computer-Software, 5.001–10.000 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

User friendly and Advance connectors

4,0 vor 5 Jahren

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.

Vishant
Sr Developer in USA
Marketing & Werbung, 1.001–5.000 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Easy to use features

4,0 vor 5 Jahren

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.

Karan
Data Scientist in USA
Krankenhausversorgung & Gesundheitswesen, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Matillion Review - Excellent overall

5,0 vor 5 Jahren

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

Shivkumar
Solution Architect in Indien
Informationstechnologie & -dienste, 201–500 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

For AWS one of the best tool to go for

3,0 vor 5 Jahren

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

Ravi
Ravi
CTO in USA
Verifizierter Nutzer auf LinkedIn
Informationstechnologie & -dienste, 51–200 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Very productive toolset

5,0 vor 3 Jahren

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