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

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

Dan
IT Manager in UK
Erneuerbare Energien & Umwelt, 51–200 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

As an ETL it is robust

4,0 vor 3 Wochen Neu

Kommentare: It's not a bad product, but our team decided to portion the ETL function to an Azure-based service as they couldn't tie Matillion to our business continuity plan due to a lack of skills with this product.

Vorteile:

There is a vast number of options and data connectors on offer.

Nachteile:

When communicating with the support and billing teams, they are never around to answer. Phone support is useless as no one answers, and it takes a few days to get an answer via email. Took for ever to switch billing from credit card to invoicing.

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

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 letztes Jahr

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

Erick
Business System Analyst in USA
Automotive, 51–200 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

In Betracht gezogene Alternativen:

Matillion Review

4,0 vor 5 Jahren

Kommentare: Matillion is a great out of the box product with minimal requirements. You spin the machine up, allow your database's firewall to communicate with Matillion. Start creating jobs, schedule them, and sit back. It helps you focus on visualizing your data.

Vorteile:

It is a pay for what you use type of software. Most other ETL platforms are a flat monthly fee, sometimes at crazy prices. The pay for what you use model makes it easy to justify cost to leadership. You can schedule jobs to make sure you maximize your time.

Nachteile:

The user experience feels a little dated. Some things could be better displayed/ explained.

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.

Joe
Data Engineer in UK
Verlagswesen, 501–1.000 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

Matillion for Data Engineers

4,0 vor 5 Jahren

Kommentare: An easy to use tool that has allowed me to build a fully automated data warehouse to report to the business, it was easy to learn and implement, and as difficult as SQL to master. I think the real complexity comes from optimising complex workflows, the more T you need in the ETL/ELT process, the more Matillion falls down. This being said it is a very good tool for 90% of your work.

Vorteile:

It is easy to use and quick to get started, there are many inbuilt APIs and transformations that integrate it across a broad suite of systems, and enable you to transform data for the business without having to spend too much time thinking about scripts or bespoke batch files.

Nachteile:

The filter transformer is pretty minimal considering the power of the SQL it is utilising, it cannot use compound logic or reference other columns/objects in the query. There is also optimisation issues in very complex workspaces. Both of these have easy to use workarounds but it is unfortunate it is not supported more at surface level.

Susan
Senior BI Engineer in UK
Baumaterial, 5.001–10.000 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Matillion when used with Google BigQuery

4,0 vor 5 Jahren

Kommentare: We are now using Matillion as our TL tool to load into our Google Data Lake which will be the source of all our BI reporting data (replacing SQL servers).
Matillion is easy to install (Google Marketplace, one click build), easy to use initially, sometimes lacks a few specialist bits (usually around new things in the Google estate), but theses can be overcome by using scripts or sql statements and I am sure some will become components in their own right.
Matillion support is very good - I usually get a response within the hour

Vorteile:

From an engineers point of view one of the selling points for Matillion (apart from the absolute simplicity of use - at least to start with) is that it produces its own documentation !!

Nachteile:

Sometimes the error messages can be confusing , but this is often down to the messages coming from BigQuery. Its also not always obvious that it is producing SQL statement 'under the hood' and that can mean breaking sql statement size limits without realising it

Luke
Data Engineer in USA
Informationsdienst, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Great data tool!

4,0 vor 3 Jahren

Kommentare: Great. Good customer service, quality product.

Vorteile:

Makes for very fast development with lots of built in connectors. Visual layout of complex data pipelines is a big plus.

Nachteile:

Out of memory errors. We use this for a lot of production applications. After 1 year of trying to fix OOM errors and doubling our instance size, we still get them monthly. I love matillion but I wish it were more reliable. The billing structure contributes to the problem as well. We can't run matillion on a big instance without significantly increasing our licensing fees. I wish they were independant.

Venkata Aditya
Data Scientist in USA
Computer-Software, 11–50 Mitarbeiter
Verwendete die Software für: 1-5 Monate
Herkunft der Bewertung

Good ease of use, should improve customer service

5,0 vor 5 Jahren

Kommentare: With the tools given most of the business problems can be solved(not in an efficient way though if you consider SnowFlake), but there's a lot of room for improvement on the customer service side. Also, having the same functionalities for both RedShift and SnowFlake would make it a lot better, for now there are more functionalities and components for RedShift.

Vorteile:

The tool was very easy to use and was intuitive most of the time. The functions and components for RedShift were amazing even though I didn't use them

Nachteile:

1. Initially the customer service was good, calls were being scheduled either on the same day or on the next day. But once you start using it, support calls would take weeks. Sometimes support will say they'll get back to you but they don't. 2. In one particular instance, a support executive said they would get back to me because they couldn't find an immediate solution, but even after 3 weeks there was absolutely no response on their side. I got a reply after I followed up again though. 3. There are good amount of components for RedShift which are not available for SnowFlake, I hope they would incorporate them as soon as possible.

Paul
IT Systems Administrator in UK
Sport, 5.001–10.000 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Have been using Matillion for past 9 months

4,0 vor 5 Jahren

Kommentare: We have developed Data Warehouse for our business using Matillion. We employ 6k+ people, and Matillion was a perfect match for our needs. Storing data in Google Big query allows seamless access to it from other Cloud Products I.E. Google Data Studio. I love the product, and limitless possibilities it gives us. Pulling the data from anything you may think of, transforming it and then outputting into Big Query is very easy and straight forward.

Vorteile:

My background is development and I love the simplicity of the Matillion, you can very easy transform your thought process into blocks in Matillion, and debug any issues at a very granular level.

Nachteile:

Matillion crashes from time to time, meaning you need to log back on to the system, but its benefits definitely outweigh this small issue.

Brian
Enterprise Data Architect in USA
Sicherheit & Untersuchungen, 10.000+ Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

Making my life easier!

4,0 vor 5 Jahren

Kommentare: It's been great. The support team has been very responsive in resolving some Azure-related issues, tuning our instance, and helping to understand the nuances of how it works. It's been a significant reduction in development time since we migrated to Matillion.

Vorteile:

Simple, intuitive interface. I replaced a complicated series of scripts, "ETL" products, and Python code with a simple-to-understand Matillion instance.

Nachteile:

We use it on Snowflake for Azure, so there are several features that have not been migrated from the AWS version, yet. An option for a larger server by default in the Azure Marketplace.

PRANAVKUMAR
Project Lead in USA
Informationstechnologie & -dienste, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 2 Jahre
Herkunft der Bewertung

Good tool for workflow management

5,0 vor 5 Jahren

Kommentare: I am happy with this tool and it has good UI.

Vorteile:

- It has very good UI to design the workflow. - It is easy to design the workflow. - It has very good support with persistence storage. Like snowflake, redshift, etc.

Nachteile:

- It should also support Azure data warehouse.

Levan
Data Engineer in Estland
Finanzdienstleistungen, 51–200 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Great for starting

3,0 vor 5 Jahren

Vorteile:

* It's very easy to start building scalable production ready ETL pipeline. * GUI is very intuitive. * Has wide variety of integrations available. *

Nachteile:

* Error handling/debugging is on a poor level. * No good way to version queries/scripts or jobs. * Not really suitable if you need to build something very complex, as it's not very customizable.

Steven
Senior Business Intelligence Consultant in USA
Informationsdienst, 11–50 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

No Technical Customer Support.

2,0 vor 3 Jahren

Vorteile:

It's fast. Pipelines are easy to setup for very basic tasks.

Nachteile:

Your customer support people are useless. Every time I submitted a ticket, they simply pointed to an article on the Matillion website that is not helpful in solving the problem. There is no community to resolve common issues. Troubleshooting complex tasks is almost impossible for smaller organizations.

Prashanta
Senior Business Intelligence Enginner in USA
Krankenhausversorgung & Gesundheitswesen, 201–500 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Simple easy-to-use Interface but looks like a development in progress software

3,0 vor 5 Jahren

Vorteile:

Simple with not a lot of unnecessary components. Very easy to use with Amazon Redshift.

Nachteile:

Licensing mechanism not good. We had problem when trying to increase license to 6 person from 5. Integrating with Git or other source control tool not easy.

Spencer
Analytics Director in USA
Marketing & Werbung, 11–50 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Excellent Product

5,0 vor 5 Jahren

Kommentare: We are able to quickly execute on ongoing ETL projects and ad hoc needs.

Vorteile:

Ease of use and breadth of functionality.

Nachteile:

We had a billing issue at one point when trying to renew but that was mostly due to AWS Marketplace and not Matillion as a product.

Christopher
Head of Business Intelligence & Analytics in UK
Großhandel, 5.001–10.000 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Great ETL Tool

4,0 vor 5 Jahren

Kommentare: Class leading, can turn a new file around in hours and days.

Vorteile:

Pretty straightforward compared to other ETL tools, traditional engineers pick up in no time at all.

Nachteile:

The google version is not as rich as the AWS one

David
Senior Software Engineer in USA
Bildungsmanagement, 501–1.000 Mitarbeiter
Verwendete die Software für: 6-12 Monate
Herkunft der Bewertung

A Great ELT and warehousing toolset in a clean GUI

4,0 vor 5 Jahren

Kommentare: We're pulling multiple datasets together and integrating them in star schemas with Matillion, as well as doing sophisticated data analysis.

Vorteile:

The GUI and design makes it easy to not only functionalize your ELTs, but also show a graphical DAG to stakeholders.

Nachteile:

I wish it had an out-of-the-box API gateway to receive webhook requests from third-party data sources.

Hrishikesh
Data Engineer in Kanada
Finanzdienstleistungen, 10.000+ Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Flexible and Easy to use ETL tool

5,0 vor 5 Jahren

Vorteile:

I like the use of Variables and Grid Variables that allow me to reuse jobs for different ETL workflows.

Nachteile:

Lack of version control for the ETL code is a problem.

kal
Data Analyst in UK
E-Learning, 201–500 Mitarbeiter
Verwendete die Software für: Mehr als 1 Jahr
Herkunft der Bewertung

Matillion ETL

5,0 vor 5 Jahren

Vorteile:

Ease of use Configured for AWS Redshift compatible Quick support turnaround

Nachteile:

Not all connectors available - but new releases drop regularly