Likelihood to Recommend Adverity is particularly useful if there is a large range of data sets that you want to combine to get an 'overall' view. Previously we had used
Google Analytics , but found that this was too useful for our big client accounts that we were working on. So I think that if there is an individual who is responsible for analytics or data, and also a paid media team then this is a tool which is essential. For companies that have limited activity then I think this tool could potentially over-complicate for less reward.
Read full review When my team receives a request to import data in from a new place, it's great to have a tool where you can set up those imports in minutes, yet have the capabilities to create customized and complex orchestration as time allows. Because it's easy to send SFTP exports, my internal customers are sometimes surprised that it's not as easy to perform other exports such as e-mailed files or API integrations. If Matillion had output components as varied and excellent as the import components, it would be the perfect solution for so many things we do.
Read full review Pros User-friendly report setup and ingestion Easy integration with multiple data endpoints, making it easy for users to drive value Incredible customer support, allowing users (regardless of technical background) to act like power-users Alex Holt Director, Digital Advertising - FUEL IMV
Read full review Matillion has a rich transformation library. It provides multiple functionalities, such as join, group by, pivot, various sources, and sinks. It provides the security capability as well. All the credentials can be securely stored in Matillion. Reusable templates can be built which reduces the redundancy. Time to production is very minimal. Read full review Cons I think it would have been more user friendly if there was more labelling capabilities, so that when you are sharing the dashboard they would explain what the data is - rather than depending on someone knowing how to use the dashboards or being there to explain it. Our teams found that some of the scheduling functionality could be a little big buggy, so this was something that needed extra care and attention, so therefore may be an area that needs to be improved (unless it was just our account and usage). Read full review Static and monolithic, it will show its limits when running multiple concurrent jobs. Github and versioning implementation is messy and broken. Don't use it. There's not way to see/query the system resources, just wait for a server to crash due to out of memory. An admin panel would be appreciated + some env variables with updated info. API implementation is cumbersome and limited. There's no concept of hub and worker engine, everything happens of the same server (designing workflows and executing them). Having separate light ETL engines to run job could be better. (sort of docker/kubernetes/lambda functions). Handling of variables is limited especially for returned values from sub components. Some components could return more metadata at the end of their execution instead of the standard one. Billing is badly designed not taking into account that the server is hosted by the client. Expensive. We had several issue with migration where starting a new instance was required and then migrating the content. It was painful and time consuming also have to deal with support and engineering team on Matillion side. CDC doesn't work as expected or it is not a mature product yet. Read full review Likelihood to Renew With the current experience of Matillion, we are likely to renew with the current feature option but will also look for improvement in various areas including scalability and dependability. 1. Connectors: It offers various connectors option but isn't full proof which we will be looking forward as we grow. 2. Scalability: As usage increase, we want Matillion system to be more stable.
Read full review Usability We are able to bring on new resources and teach them how to use Matillion without having to invest a significant amount of time. We prefer looking for resources with any type of ETL skill-set and feel that they can learn Matillion without problem. In addition, the prebuilt objects cover more than 95% of our use cases and we do not have to build much from scratch.
Read full review Support Rating Overall, I've found Matillion to be responsive and considerate. I feel like they value us as a customer even when I know they have customers who spend more on the product than we do. That speaks to a motive higher than money. They want to make a good product and a good experience for their customers. If I have any complaint, it's that support sometimes feels community-oriented. It isn't always immediately clear to me that my support requests are going to a support engineer and not to the community at large. Usually, though, after a bit of conversation, it's clear that Matillion is watching and responding. And responses are generally quick in coming.
Read full review Implementation Rating We were able to control on access and built various enviroment for implementation
Read full review Alternatives Considered Frankly, the service, UI, and ease-of-use for Adverity made it a no brainer compared to competiton.
Alex Holt Director, Digital Advertising - FUEL IMV
Read full review Fivetran offers a managed service and pre-configured schemas/models for data loading, which means much less administrative work for initial setup and ongoing maintenance. But it comes at a much higher price tag. So, knowing where your sweet spot is in the build vs. buy spectrum is essential to deciding which tool fits better. For the transformation part,
dbt is purely (SQL-) code-based. So, it is mainly whether your developers prefer a GUI or code-based approach.
Read full review Scalability We're using Matillion on EC2 instances, and we have about 20 projects for our clients in the same instance. Sometimes, we're struggling to manage schedules for all projects because thread management is not visible, and we can't see the process at the instance level.
Read full review Return on Investment This tool has allowed us to be able to see areas for opportunities, when all of the data has been combined We were also able to better prioritise actions and where to focus our attention, when we had one view where all of the data was together. This allowed us to deliver better results for our clients, and also have a clearer roadmap of activity Read full review Matillion has been the backbone of my company's analytical functionalities for 10+ years, so it has a good ROI. The price is ok for what our company built with it, but it starts to be less competitive if the tool is not used at its fullest. Read full review ScreenShots