Matillion For All
May 22, 2019
Matillion For All
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Matillion
Matillion is being used in our company as an ELT tool. We load data into it from various sources, such as Salesforce, NetSuite, etc. We are exploring more such options, from there we can pull the data into matillion. Once in matillion, we transform this data using various components provided by the matillion tool to modify the data as we need. Then, once all the modification are in place we load the data into Snowflake which is our data warehouse
- Data extraction is really quick and hassle-free.
- Transformation is very easy to perform as it provides an elaborate list of components that can be used to create and optimize your query.
- Scheduling is very manageable and easy to monitor and review.
- UI is very user-friendly, every component and sub-component can be understood by the help option provided as a hyperlink.
- There can definitely be some improvements w.r.t the NetSuite orchestration component. We have had lots of trouble connecting it to Matillion during POC.
- Although the UI is quite user-friendly there is room for much improvement.
- There should be requirement specific customized training before a company starts working with Matillion. We got general training which definitely benefited us, I just think a more project-specific training would have been more useful
- So far it is hard to tell whether Matillion has had a negative impact on our business objectives since we have been using Matillion for less than a year
Well, we worked on Matillion for roughly three months before actually acquiring the product. It was essential to first get training because you tend to miss out certain basic functionalities without a matillion expert guiding you. Also, once we had a little hands-on with the product it wasn't very difficult to get the whole transformation process started.
Teradata is basically an SQL tool from where we manage the database. Matillion is a whole other ELT tool on which we can work on independent from the warehouse. It is also much cheaper and installation charges are much less. Informatica is very similar to Matillion in terms of usage, but I feel Matillion is more user-friendly in comparison.