Matillion
Description de Matillion
Matillion fournit le seul produit de transformation de données conçu spécialement pour les data warehouse dans le cloud (CDW). Cette solution gère :
1) L'extraction et la charge des données métiers dans un CDW, offrant l'évolutivité et les performances nécessaires à l'analytique axée sur les données.
2) La possibilité de joindre des sources de données métiers variées grâce à de puissantes capacités de transformation, complétant ainsi le processus afin de préparer les données à l'analytique.
Qui utilise Matillion ?
Les grandes entreprises et les entreprises de marché intermédiaire dans divers secteurs, comme les finances, les soins de santé, la vente au détail, etc.
Matillion ne vous convainc pas tout à fait ?
Comparer avec une alternative populaire
Matillion
Alternatives à Matillion
Avis sur Matillion
Ayushi
ETL Made easy with Matilllion !!
Commentaires : Data Cleansing: Matillion ETL can be used to clean up dirty or erroneous data. This cleans and prepares the data for analysis or reporting.- Data Transformation: Matillion ETL can be used to transform data from one format into another. This is useful for consolidating data from multiple sources, or preparing it for analytical purposes.- Data Migration: Matillion ETL can be used to migrate data from one system to another. This is often necessary when companies are restructuring their IT infrastructure, or upgrading to a new software platform.
Avantages :
- Ease of Use: Matillion ETL is very easy to use, even for those who are not experts in data analysis or software development. It provides a user-friendly interface that makes it easy to connect to and transform your data.- Speed and Performance: Matillion ETL is one of the fastest and most efficient ETL tools available. It can handle large volumes of data quickly and easily, without bogging down your computer’s resources.- Flexibility: One of the best things about Matillion ETL is its flexibility. It can be tailored to meet your specific needs, whether you are working with structured or unstructured data. It also allows you to customize your own workflows for maximum efficiency.- Speed: Unlike some traditional ETL tools, Matillion is very fast and can handle large amounts of data without any problems. This makes it perfect for businesses that need to move large amounts of data quickly and efficiently.- Scalability: Another advantage of using Matilion is that it is highly scalable. This means that you can increase or decrease its capacity as needed, making it perfect for businesses that are constantly evolving and growing.
Inconvénients :
- High Cost: One of the main drawbacks of Matillion is that it is a relatively expensive tool. This can be a major issue for smaller businesses or organizations that don’t have a lot of money to spend on software.- Complexity: Another disadvantage of Matillion is its complexity. It can be difficult for people who are not familiar with it to learn how to use it effectively. This can lead to wasted time and frustration when trying to perform certain tasks.- Limited Functionality: Another downside of Matillion is that it does not offer as much functionality as some other ETL tools available on the market. This can make it difficult to complete complex data transformations or analyses. Compared to other tools like SAS or SQL, Matillion has limited functionality.
Graham
Alternatives envisagées :
Easy to use solution, allowing rapid delivery of ELT processes
Commentaires : 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.
Avantages :
- 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.
Inconvénients :
- 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
Responsive to User Needs
Commentaires : Gets better and better with each release. Keep up the good work!
Avantages :
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.
Inconvénients :
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.
Utilisateur vérifié
Matillion - ELT process made easy , perfect integration tool for snowflake users !
Commentaires : The overall experience with Matillion is good , if they compared the product with other products feature may be they could become even more better .
Avantages :
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.
Inconvénients :
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.
Michael
Great for pipelining data to warehouse/lake, not getting it back
Commentaires : 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.
Avantages :
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.
Inconvénients :
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.
