Wij helpen bedrijven al 18 jaar
betere software te kiezen

Wat is Matillion?

Matillion biedt het enige product voor gegevenstransformatie dat speciaal is ontworpen voor cloudgebaseerde datawarehouses. Deze oplossing regelt:
1) Het extraheren en laden van bedrijfsgegevens in een CDW, waarbij de schaal en prestaties worden geboden die nodig zijn voor gegevensgestuurde analyses.
2) De mogelijkheid om gevarieerde gegevensbronnen van een bedrijf samen te voegen via krachtige transformatiemogelijkheden, waarmee het proces om gegevens volledig gereed te maken voor analyse wordt voltooid.

Wie gebruikt Matillion?

Ondernemingen en middelgrote bedrijven in verschillende sectoren, zoals financiën, gezondheidszorg, detailhandel en meer.

Matillion Software - 1
Matillion Software - 2
Matillion Software - 3
Matillion Software - 4
Matillion Software - 5

Twijfels over Matillion? Vergelijk met een populair alternatief

Matillion

Matillion

4,3 (111)
US$ 2,00
Gratis versie
Gratis proefversie
42
31
4,4 (111)
4,1 (111)
4,5 (111)
VS.
Beginprijs
Prijsopties
Functies
Integraties
Gebruiksgemak
Prijs-kwaliteitverhouding
Klantenservice
US$ 13.748,00
eenmalig
Gratis versie
Gratis proefversie
29
2
4,3 (1.968)
4,3 (1.968)
4,3 (1.968)
Groene beoordelingsbalken geven het winnende product aan, op basis van de gemiddelde beoordeling en het aantal reviews.

Andere goede alternatieven voor Matillion

Microsoft SQL Server
Functies met hoogste score
Back-up en herstel
Beheer van gegevensopslag
Prestatieanalyse
Domo
Functies met hoogste score
Dataconnectors
Gegevensvisualisatie
Meerdere gegevensbronnen
Treasure Data Suite
Functies met hoogste score
Gegevensintegratie
Klantensegmenten
Klantprofielen
PowerCenter
Functies met hoogste score
Meerdere gegevensbronnen
Metadatabeheer
Real-Time Monitoring
Alteryx Designer
Functies met hoogste score
Gegevens importeren en exporteren
Gegevens opschonen
Rapportage en analyse
Pentaho
Functies met hoogste score
Ad-hocrapportage
Gegevens importeren en exporteren
Visuele analyse
Segment
Functies met hoogste score
Engagement tracking
Gegevens vastleggen en overdragen
Klantensegmenten
Integrate.io
Functies met hoogste score
Gegevensbeheer
Integratiebeheer
Meerdere gegevensbronnen
Adverity
Functies met hoogste score
Extraheren van webgegevens
Gegevens importeren en exporteren
Gegevens opschonen

Reviews over Matillion

Gemiddelde score

In totaal
4,3
Gebruiksgemak
4,4
Klantenservice
4,5
Functies
4,1
Prijs-kwaliteitverhouding
4,1

Reviews op basis van bedrijfsgrootte (werknemers)

  • <50
  • 51-200
  • 201-1.000
  • >1.001

Reviews zoeken op score

5
41%
4
50%
3
8%
2
2%
Marcus Vinícius
Marcus Vinícius
Back End Developer in Brazilië
Geverifieerde LinkedIn-gebruiker
Financiële dienstverlening, 201-500 werknemers
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

Matillion Usability

3,0 6 jaar geleden

Opmerkingen: 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.

Pluspunten:

The ease to use, Matillion has a great set of tools that make complex and difficult process more simple and fast to develop.

Minpunten:

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.

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Mediaproductie, 1.001-5.000 werknemers
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

Matillion Review

4,0 6 jaar geleden

Opmerkingen: 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.

Pluspunten:

+ Fast & easy to use + Completely embedded into AWS environement + Comes light, it's not overloaded with stuff no one uses + Some really innovative features

Minpunten:

- 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

Ravi
Ravi
CTO in VS
Geverifieerde LinkedIn-gebruiker
Informatietechnologie en -diensten, 51-200 werknemers
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

Very productive toolset

5,0 3 jaar geleden

Opmerkingen: We are using it to do the extract load and transfer for our data warehouse

Pluspunten:

- Quick to start - Consumption based model - Works well with Snowflake

Minpunten:

- Harder to find resources with skills - Cost relatively higher

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Gezondheid, wellness en fitness, 10.000+ werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Best and very much compatible ETL for Redshift

5,0 6 jaar geleden

Pluspunten:

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

Minpunten:

the latest button change for "switch version"

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Online media, 201-500 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

First class ETL for everyone

4,0 6 jaar geleden

Opmerkingen: 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.

Pluspunten:

Easy to use for non-tech (engineers) users.

Minpunten:

Lacks testing stage before production and more flexibility to sample data.

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
E-learning, 501-1.000 werknemers
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

Matillion Review

4,0 6 jaar geleden

Pluspunten:

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.

Minpunten:

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.

Geverifieerde reviewer
Geverifieerde LinkedIn-gebruiker
Computersoftware, 201-500 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Is Great

4,0 6 jaar geleden

Opmerkingen: Overall extract and load data strategies is very powerfull

Pluspunten:

Is easy and is real pay as you use, that is very important for latinoamerica business

Minpunten:

That you can't write in other destinations

Raul
Raul
CTO in Mexico
Geverifieerde LinkedIn-gebruiker
Informatietechnologie en -diensten, 201-500 werknemers
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

Great tool and experience

4,0 6 jaar geleden

Opmerkingen: Great tool

Pluspunten:

Easy to use, graphical way to do data flows on Google Cloud

Minpunten:

The most missing functionality, is to be able to setup data destinations additionally to BigQuery

Jose Mari
Jose Mari
Data Architect in Filipijnen
Geverifieerde LinkedIn-gebruiker
Olie en energie, 201-500 werknemers
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

Good

5,0 6 jaar geleden

Opmerkingen: Overall Matillion is good and I'm sure it could be better.

Pluspunten:

I like the stability of the product. We haven't updated our version since we started.

Minpunten:

Can't use simple SQL Functions like CURRENT_DATE in FIlter Component. And no Automatic Update.

Ajay
Ajay
Senior Software Engineer in India
Geverifieerde LinkedIn-gebruiker
Verzekeringen, 1.001-5.000 werknemers
Heeft de software gebruikt voor: 1-5 maanden
Bron van de reviewer

Most effective Cloud Based Data Integration And Transformation Platform

5,0 3 jaar geleden

Opmerkingen: Amazing ETL options.

Pluspunten:

The platform is very user-friendly since it is based on drag and drop functions it makes the whole process easy and can be done by anyone. It is the best option since it is based on pay as you go so we can pay as much as we use. This has saved me a lot of money.

Minpunten:

There are no negatives I have noted till now all the services are top-notch and up to the industry mark. This has helped a lot of engineers and businesses transform and automate their data.

Sandeep
Project Leader in India
Informatietechnologie en -diensten, 501-1.000 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Need on the fly connectivity to different instance of Redshift

4,0 6 jaar geleden

Pluspunten:

I like the bunch of API integrated in Matillion it helps me to directly grab the data from different sources without manually extra and import in my database.

Minpunten:

I am using Matillion for Redshift from last more than 2 years. When i setup a project in Matillion with connection to a Redshift cluster, sometimes there is a need to extract the data from other instance of Redshift while running job in Matillion. In that case there is straight forward way of getting the data from other instance of Redshift like you have comments to extract the data from databases like SQL Server, Oracle etc. instead of first i need to run another job by connection second Redshift cluster and extract the records after that run different job to load the extracted records from S3 to main Redshift cluster.

Luke
Data Engineer in VS
Informatiediensten, 51-200 werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Great data tool!

4,0 3 jaar geleden

Opmerkingen: Great. Good customer service, quality product.

Pluspunten:

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

Minpunten:

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.

Susan
Senior BI Engineer in VK
Bouwmaterialen, 5.001-10.000 werknemers
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

Matillion when used with Google BigQuery

4,0 6 jaar geleden

Opmerkingen: 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

Pluspunten:

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

Minpunten:

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

Mark
Principal Consultant in VK
Informatietechnologie en -diensten, Zelfstandig ondernemer
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

A Great Cloud-based Tool

5,0 6 jaar geleden

Opmerkingen: I like it overall. It is easy to quickly learn and get up to speed. It is made to work in the environment I'm working in (AWS) and has a nice, clean browser-based interface to build and schedule jobs in EC2. Email-based support is responsive. However, I sometimes feel it is too expensive compared to alternatives for the value it adds and the ELT model, while beneficial in many ways, hamstrings the component feature-set.

Pluspunten:

Well integrated with AWS. Great browser-based interface. Develop in the same place where the code will run, as opposed to other solutions I use that develop in Windows and run in Linux. Easy to schedule.

Minpunten:

I have mixed feelings on the overall value. The hourly rate really adds up over time. This is probably my biggest misgiving. Otherwise, I sometimes get frustrated with the ELT model because it means if the feature you need isn't supported within Redshift, it's up to you to create Python scripts or Bash scripts to enable it.

Despina
BI Analyst in VK
Bouw, 10.000+ werknemers
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

MELT

4,0 6 jaar geleden

Pluspunten:

Easy to learn and use. The knowledge from other products is transferable. The documentation is amazing (one probably cannot understand how good without the experience). Support is always available and of good quality.

Minpunten:

There is no restart-from-point-of-failure option for failed loads. Everything has to start from scratch or remaining jobs need to be run manually.

Venkata Aditya
Data Scientist in VS
Computersoftware, 11-50 werknemers
Heeft de software gebruikt voor: 1-5 maanden
Bron van de reviewer

Good ease of use, should improve customer service

5,0 6 jaar geleden

Opmerkingen: 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.

Pluspunten:

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

Minpunten:

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.

Amit
Data Engineer in VS
Computersoftware, 51-200 werknemers
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

Does the job very well

4,0 6 jaar geleden

Opmerkingen: I have been using Matillion since September 2018 and at the beginning i didn't like it very much as i dont had hands on experience using Matillion. But later my work has increased a lot using Matillion. So far i have had integrated bunch of sources using Matillion to data warehouse. I am liking it at this moment and no complains.

Pluspunten:

Matillion ETL is web based ETL tool and very easy to use from anywhere. It has most of the connectors for all data sources which makes my job to complete end to end development.

Minpunten:

One thing I did not like about Matillion is, there is no need of Transformation job. Everything should be done at one place(Should be in Orchestration job). Also, the list of components are different in Orchestration and transformation jobs.

Ravi
Sr. Cloud Data Engineer in VS
Farmaceutica, 10.000+ werknemers
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

Review of Matillion as ETL cloud Engineer

4,0 6 jaar geleden

Opmerkingen: It was great working as well learning experience , hope Matillion will come up as industry leader.

Pluspunten:

Matillion integration with AWS services is flawless and has real time impact in batch jobs pulling data from on-premises to cloud platform.

Minpunten:

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.

Chaitanya
BI Engineer in VK
Bouwmaterialen, 10.000+ werknemers
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

Simple and easy ELT

5,0 6 jaar geleden

Opmerkingen: Very nice. Easy and simple tool. Yet a lot possible with python scripting feature.

Pluspunten:

Integration with GCP API calls and cloud storage. Easy of access from anywhere. Self documentation. Customer service. Automatic updates.

Minpunten:

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.

PRANAVKUMAR
Project Lead in VS
Informatietechnologie en -diensten, 10.000+ werknemers
Heeft de software gebruikt voor: 2+ jaar
Bron van de reviewer

Good tool for workflow management

5,0 6 jaar geleden

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

Pluspunten:

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

Minpunten:

- It should also support Azure data warehouse.

Oliver
Data Analyst in Duitsland
Vrije tijd, reizen en toerisme, 10.000+ werknemers
Heeft de software gebruikt voor: 6-12 maanden
Bron van de reviewer

Fast track to results

4,0 6 jaar geleden

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

Pluspunten:

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.

Minpunten:

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

Martin
Business Analyst in VK
Mediaproductie, 11-50 werknemers
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

Intuitive & Flexible

4,0 6 jaar geleden

Pluspunten:

I love the GUI that Matillion employs - it makes creating and adjusting tasks very simple and transparent.

Minpunten:

The scheduling of tasks is a little tricky, as we have to separately have to schedule the virtual machine to fire up and down. Once this is done though, it works faultlessly.

Prashanta
Senior Business Intelligence Enginner in VS
Ziekenhuis- en gezondheidszorgbranche, 201-500 werknemers
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

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

3,0 6 jaar geleden

Pluspunten:

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

Minpunten:

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.

Jagdish
Senior software engineer in Finland
Computersoftware, 5.001-10.000 werknemers
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

User friendly and Advance connectors

4,0 6 jaar geleden

Opmerkingen: I was developed around 20 to 50 mapping using Matillion and I don't see any difficulties right know.

Pluspunten:

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.

Minpunten:

I don't see straight forward job Audit framework. Please try to build nice job monitoring and audit framework.

Lee
SQL BI Developer in VK
Informatietechnologie en -diensten, Zelfstandig ondernemer
Heeft de software gebruikt voor: 1+ jaar
Bron van de reviewer

Using Matillion with AWS Redshift

5,0 6 jaar geleden

Pluspunten:

Easy to understand and follow processes. Easy to pass variable values between jobs. Works well with Redshift and S3.

Minpunten:

Use of API's can be a little confusing to setup/configure.