Wir helfen Unternehmen in Deutschland
seit 15 Jahren bei der Softwareauswahl

Ü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 integration with AWS services is flawless and has real time impact in batch jobs pulling data from on-premises to cloud platform.

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 110 Nutzerbewertungen auf Capterra.

Hast du Matillion bereits verwendet?

Teile deine Erfahrungen mit anderen Softwareinteressenten.

Nutzerbewertungen filtern (110)

James
James
Senior Analyst in USA
Verifizierter Nutzer auf LinkedIn
Verbraucherdienste, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

The best ELT tool on the market

5,0 vor 2 Jahren

Kommentare: Matillion is the single most important piece of software I use on a day-to-day basis. Its' ability to blend a ton of out-of-the-box functionality with the ability to script custom components in Python to author our own integrations is invaluable. It has enabled us to build transformed data within our warehouse, use pre-authored integrations to pull data from vendors, write our own integrations to pull from vendors, and is the single tool we use along with Redshift to provide visibility to all of the data within our business. I am a huge fan of Matillion and have used it in 2 different orgs. It is one of the only software tools I will champion across any org I move to.

Vorteile:

-Extremely easy deployment with cloud formation template. -Excellent pre-authored integrations that are easily extensible/customizable. -Easy to use UI to build complex transformations. -Extremely flexible logic with static and grid variables to intelligently execute jobs and branch as needed.

Nachteile:

-No automated scheduling based on dependent table updates. (This is possible to set up, but not out of the box.) -Support SLAs have gotten worse over time.

Graham
Solution Architect in UK
Marketing & Werbung, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Easy to use solution, allowing rapid delivery of ELT processes

5,0 vor 5 Jahren

Kommentare: We came to Matillion while looking for a tool that would allow us to orchestrate our load processes for Amazon Redshift. We'd used other ETL tools previously, were blown away by how easy it was to pick up and understand Matillion. We liked the simplicity, and the fact that we could always dig into the SQL that was generated. New features are added frequently, and we usually find one or two improvements that directly impact us with each release. Their support team are also very responsive, and Matillion are always keen to help you get the most out of their software, so there's a lot of support if you want it. 2+ years later, and we're using Matillion to run all our ELT jobs across various data warehouse projects, and very happy with it.

Vorteile:

- Very intuitive design environment - super quick to learn. - Components map closely to SQL capabilities in Redshift. - Easy to view the SQL generated. - Sample, row count, and data lineage make it easy to unit test as you build. - Powerful management options via REST API (orchestration, Github integration, etc.). - Native AWS integration. - Aggressive release cycle, constantly adding new features. - Easy to document in-workflow. - Lots of third party integrations.

Nachteile:

- User concurrency/licencing model (simple, but can't be customised to fit your need). - Exception handling could be improved. - A single Task View would be helpful for multi-environment/project support.

Roger
Software Engineer II in USA
Marketing & Werbung, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Responsive to User Needs

3,0 vor 5 Jahren

Kommentare: Gets better and better with each release. Keep up the good work!

Vorteile:

I've been using Matillion for about 2 and a half years. I've seen the software improve so much in that time. If I ever found a feature to be lacking, it would be included within the next couple release cycles. The software really seems to adapt as user needs have been evolving. Some of my favorite recent features are the ability to configure some components with just text (really saves me time) and the many Grid orchestration components which allow me to greatly reduce the complexity of the orchestration jobs.

Nachteile:

UX is sometimes lacking or inconsistent. For example, let's say my goal is to replace an existing job with a new job of the same name. I delete the old job, and import the new one with the same name. All Orchestration components that used that job will understand to use the new job, but for some reason the scheduler doesn't. Also, jobs will have validation errors simply because the components haven't been validated (grey borders). It can be confusing because you may be searching for an error in your work when all you actually have to do is revalidate the job.

Michael
Director, Business Intelligence and Web Services in USA
Hochschulbildung, 501–1.000 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Great for pipelining data to warehouse/lake, not getting it back

4,0 vor 5 Jahren

Kommentare: It was easy to get set up, and it worked great for pushing data into Snowflake as a data warehouse. However, we quickly realized that we would need yet another tool to get the data back out to the source systems to synchronize/integrate it. We could sort of do it with Matillion, but it required a lot of custom programming and was not very intuitive. We ended up using a different iPaaS tool that could handle traffic/integration in both directions.

Vorteile:

It is extremely fast and easy to pull data from various sources and pipe it into Snowflake. The graphic interface lets this happen without programming.

Nachteile:

There is almost no ability to get data back from your warehouse into the other systems to synchronize the data. It's great to have it all in the warehouse, but it seems pretty critical to have that data flowing back to other systems that are part of your environment. The pricing model is frustrating. You are billed for when the machine instance is ON, not when it is actively doing something. So, if you have a couple hours of job that run in a day, you have to shut down the machine to save money the rest of the day. With it shut down, development can't happen. So, we had to turn it on and off all the time. It would be much better if they billed as it is used, not as it is on.

Daniel
EVP Operations IT in USA
Informationstechnologie & -dienste, 201–500 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

In Betracht gezogene Alternativen:

A good tool for large-scale ETL into Cloud Data Warehouses

4,0 vor 2 Jahren

Kommentare: We're able to rapidly load large amounts of data into Snowflake and schedule any SQL tasks to run against snowflake.

Vorteile:

Web-based, Runs in AWS so it can sit close to your data if you're using a cloud warehouse. You only have to pay per minute that you have the instance on which is a BIG plus.

Nachteile:

Not nearly as many features and user-friendly data transformation tools as a competing software such as Alteryx has. As such, this tool is not as convenient or flexible for detailed data transformations. We mostly use it for bulk loading which it is very fast and good at.

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

Verifizierter Rezensent
Verifizierter Nutzer auf LinkedIn
Telekommunikation, 5.001–10.000 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Matillion - ELT process made easy , perfect integration tool for snowflake users !

4,0 vor 12 Monaten

Kommentare: The overall experience with Matillion is good , if they compared the product with other products feature may be they could become even more better .

Vorteile:

Matillion is a cloud based ELT tool and it is very easy to use . The data transfer rates are incredibly good since the product locates in cloud infrastructure and the infrastructure can be scaled up when required.

Nachteile:

The connectors to other data sources are limited when compare to what other rival product are offering . The job monitoring functionality is limited , the scheduling and job log features could have been improved. The GitHub integration could have been straight forward.

John
Sr. Data Analyst in USA
Gesundheit, Wellness & Fitness, 11–50 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Just started using Matillion this week

5,0 vor 2 Jahren

Kommentare: Overall experience with Matillion has been great. The first call with [SENSITIVE CONTENT] set the tone of who and what Matillion can offer our company. [SENSITIVE CONTENT] was kind, not pushy, relatable, and truly tried to understand our use case.
[SENSITIVE CONTENT] really sold us on proceeding with a demo after sharing some of the functionality of the MDL tool available for free in AWS marketplace. While we very much could simply use the free tool, [SENSITIVE CONTENT] helped us understand why we should consider the full product.
Finally, [SENSITIVE CONTENT] was a great account rep to work with. Before our first call he had looked up our company and understood our business (which is not easy to do). We are in a sensitive are of health care and [SENSITIVE CONTENT] opened up and shared a personal story relating to the line of work we are in. Other companies/products we looked into and has calls with did not take the time to understand our business or empathize with our customers.
The personal touch from the above folks was a nice addition to the great product Matillion offers.

Vorteile:

Matillion is incredibly easy to deploy in AWS. In addition, the security and compliance aspects are all handled on the customer side due to the deployment method. The UI is easy to use and the price point was the most competitive.

Nachteile:

We haven't used it enough to encounter negative aspects yet but having to pay for the full amount of time the VM is up is going to be cost prohibitive for our small team.

Alexander
Data Engineer in USA
Computer-Hardware, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Efficiency!

5,0 vor 5 Jahren

Kommentare: Satisfied!

Vorteile:

The collection of components; especially the integration components that hook into a very popular CRM and another quite popular ERP.

Nachteile:

The python component. Depending on the box where your instance is hosted, this component will drag along like a broken train or move at the speed of shooting star.

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 vor 6 Monaten

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.

Francis
Head of BI in Deutschland
Automotive, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Matillion is an Easy To Leverage (ETL) solution!

4,0 vor 5 Jahren

Vorteile:

- Easy to orchestrate an ETL pipeline - Integration with Redshift and other AWS services provides convenience - Support team is easy to reach and have relatively quick response times - They also support the other 2 popular cloud data warehouses, Snowflake and BigQuery - Some components are available out to the box for easy integration - Task history is useful for debugging and monitoring current state of ETL pipelines - A GUI is provided for implementing complicated workflows, that can be easily followed

Nachteile:

- Since it's mainly GUI based, it becomes difficult for data engineers to compare changes between old and new versions of an ETL. - There are hard limitations for the number of concurrent users. This is part of the pricing model which is the reason. - Integration with GIT is not yet available but we heard that it would be coming in the near future.

Vipul
Data Engineer in USA
Marketing & Werbung, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Vipul Chona - Matillion Review

4,0 vor 2 Jahren

Vorteile:

ease of use! someone with little code knowledge can come in and understand what's going on, it's very easy to follow along and see the transformation step by step

Nachteile:

API connectors could be better. Could be more available, and a little more ease of use (especially with the endpoint mapping)

Oliver
Data Analyst in Deutschland
Freizeit, Reisen & Tourismus, 10.000+ Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Fast track to results

4,0 vor 5 Jahren

Kommentare: Very helpful support which takes care of all our problems, especially with "stupid" beginner questions.

Vorteile:

Very easy to use and very easy to get results. Fast implementation cycles compared to other tools. Best is to loop over variables which enables simple but powerful solutions.

Nachteile:

Sometimes more flexibilty on specific tasks, e.g. Excel import or csv.

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 2 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