Gegevenstransformatie voor cloudgebaseerde datawarehouses. Transformeer je gegevens in inzichten en beslissingen om je concurrentie te overtreffen.
Matillion integration with AWS services is flawless and has real time impact in batch jobs pulling data from on-premises to cloud platform.
The scheduling of tasks is a little tricky, as we have to separately have to schedule the virtual machine to fire up and down.
Reviews filteren (108)
ETL Made easy with Matilllion !!
Opmerkingen: 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.
- 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.
- 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.
Easy to use solution, allowing rapid delivery of ELT processes
Opmerkingen: 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.
- 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.
- 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.
Responsive to User Needs
Opmerkingen: Gets better and better with each release. Keep up the good work!
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.
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.
Great for pipelining data to warehouse/lake, not getting it back
Opmerkingen: 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.
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.
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.
A good tool for large-scale ETL into Cloud Data Warehouses
Opmerkingen: We're able to rapidly load large amounts of data into Snowflake and schedule any SQL tasks to run against snowflake.
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.
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.
Just started using Matillion this week
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.
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.
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.
Opmerkingen: 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.
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.
The user experience feels a little dated. Some things could be better displayed/ explained.
The collection of components; especially the integration components that hook into a very popular CRM and another quite popular ERP.
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.
The best ELT tool on the market
Opmerkingen: 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.
-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.
-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.
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.
The ease to use, Matillion has a great set of tools that make complex and difficult process more simple and fast to develop.
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.
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.
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.
Review of Matillion as ETL cloud Engineer
Opmerkingen: It was great working as well learning experience , hope Matillion will come up as industry leader.
Matillion integration with AWS services is flawless and has real time impact in batch jobs pulling data from on-premises to cloud platform.
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.
Matillion ETL For Medium to Large Company
Opmerkingen: 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.
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.
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.
Have been using Matillion for past 9 months
Opmerkingen: 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.
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.
Matillion crashes from time to time, meaning you need to log back on to the system, but its benefits definitely outweigh this small issue.
Great turnkey solution to ETL and data migrations
Matillion offers a powerful feature set within a robust UI. There are other options but none have the ease of onboarding that Matillion offers. The API adds a powerful layer to do advanced integrations.
Some threads have become unresponsive while running. This has been rare and was easy enough to resolve by resetting the service.
Good tool for workflow management
Opmerkingen: I am happy with this tool and it has good UI.
- 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.
- It should also support Azure data warehouse.
very good ETL Tool with some growing pains
Opmerkingen: it helped us a lot to build our Redshift Data Lake from the Scratch
very easy to use, fast and good Customer Support, many API Connectors out of the box, well integrated in AWS Infrastructure
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)
Great product for handling big data flow automation
This tool helps in automating etl process.
Integration with python is limited. Need this feature
Great ELT tool
Opmerkingen: We use Matillion ELT to manage Data Warehouse. Support team provides consistent work around for issues.
Connectivity to Saas sources. Reliability and Customer Support team
RSD creation for Saas sources that do not have built in connector.
Easy to use features
Inbuild features to integrate with AWS s3, send SNS messages.
Readability should be more, ease to retain changes or navigate to environment variables should improve.
Matillion Review - Excellent overall
Ease of Use and excellent support which makes this software likely to use in comparison to other ELT tools.
Does not compatibility with Genetics connector like VCF or BAM
Matillion product review
Target based ETL application. Cloud Native.
I would prefer it to support multiple target DBs like SQL Server, Oracle, MySQL, Redshift, Snowflake.
Perfect ELT Tools
Opmerkingen: ELT, daily basis extract of data and ad-hoc tasks
Workflow Layout and clarity of all components
Environment Management, licensing model
Yes but ..
Opmerkingen: Data transformation, data prep for python, data analysis
stable, close to SQL, integrated in AWS, fast
No data vizualisation (impossible to outpout the data directly in excel... ) Complicated to separate between orchestration in transformation
Opmerkingen: They have been a great company to work with. They are very transparent, quick to response, have awesome support and great training.
It's very easy to use, great training and support.
I don't have any cons. From start to end they have been great to work with.