Likelihood to Recommend
Matillion is great any time ETL or ELT is needed. I've now used Matillion in 2 different companies and would have no problem recommending others to use it as well. The ease of setting up schedules to just take care of data imports and manipulation is incredible. IT has also been an incredible tool at bringing disparate databases together on a schedule so that I never have to think about it.
Read full review
TIBCO Data Virtualization has developed a platform to track, manage, and provide concise reports throughout the various stages of the sales process. It is a powerful tool that has helped maximise efficiency through its visualisation formats. After working with this tool and seeing the benefits, I couldn't imagine my life without it. I will continue to use TIBCO Data Virtualization for the foreseeable future.
Read full review Pros Excellent tool to do ELT data pipeline using Snowflake Easy graphical orchestration to enable complex dependencies Easy manage users and group permissions Easy to schedule jobs using time dependency and job dependency Provides many API's to fetch data from multiple vendors Read full review Connecting to different data silos and presenting the data as a singled unified layer of data. Exposing data to Technical and non technical users through Web UI or reporting tools Secured exposure of data as web services. Row level and column level data security Multi tenancy data security. Real time data by connecting to the operational databases Historical data generation Read full review Cons I think a non-CLI approach to installing and uninstalling python libraries would be nice. I mean, it isn't difficult to install a python library via Linux or CLI, but I imagine most companies don't feel comfortable allowing Matillion users to go on a virtual server and installing it themselves. Requirement.txt file for installing libraries would be simple, and maybe that could also be used to uninstall libraries as well......or maybe the library gets automatically downloaded if it is imported into a python script but the library doesn't exist. Python Component is lacking very much in terms of UI. It would be unrealistic for me to suggest Matillion build its own EDI, but it would be nice if a python component could connect to a local IDE. Right now, if you want to write any decent length python code, you are going to be stuck copying and pasting your code from your local IDE. It is also very difficult to debug in Matillion because you can't set breakpoints. Local IDE integration can resolve that. I would like to have more templates to copy from for certain simplistic scenarios. For instance, a template for a job that fails which sends an AWS SNS with the Job name, component it failed on, and the error message. It wasn't as simple as I thought it would be to figure out and having to use a shared job for such circumstances can be painful because you have to export a bunch of variables. There should be a drop down list for Global Matillion variables as it is difficult to remember at times. Read full review Performance of TDV Studio (its own IDE) is poor. Performance of TDV repository database is rather poor for larger numbers of objects .(Note: We have approx. 9tsd objects introspected in TDV and approx. 20tsd objects generated in upper DV layers.) Propagation of privileges to parent/child dependencies does not work when applying recursively on a folder. (It's a huge setback when working with large number of objects organized semantically into subfolders.) Lack of command line client interface for scripting at the time of version 8.4 (I had to write my own CLI.) TDV Studio does an absolutely horrible job with its own code editors when indentation is in place. Also, the editor is brutally slow and feature-poor. Tracking privileges on the level of table/view columns causes occasional problems when regranting. TDV's stored programs ("SQL scripts" in their own terminology) compiler leaves out many syntactic and semantic checks, making them hugely prone to run-time errors. TDV Server's REST API is a very poor (in terms of features) and flawed cousin to its SOAP API (at the time of version 8.4). 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
It is useful for us to see the data and do analysis. Also we use it to generate reports and see trends or gather insights
Read full review Usability
Easy to follow steps in building a data pipeline. We have brought in people with minimal SQL experience and they have been able to quickly and successfully being able to pick up the skill set and contributing in reducing the time to market with various data assets. Matillion does provide a long array of components to select from to perform data transformation. But like any other tool, there are more than one way of doing the same thing. Some are more performant than the others, but easy to follow and easy to tweak to improve.
Read full review
It has a drag-and-drop feature and a good list of data adapters which makes it easy to thread across elements of various data sources.
Read full review Reliability and Availability
We have never encountered issues where it was unavailable when we needed it.
Read full review Performance
TDV does integrate with a host of third-party apps such as BO/ Spotfire for reporting, Informatica for ETL, etc. However, if it can come up with its own suite of these products and combine features of TDV into a single robust Data Integration/ Analysis/ Reporting software, then it is more likely that people will want to explore the product more.
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
On a few occasions I have asked TIBCO technical support for help because I have adapted perfectly to their tools, but in those few that I have communicated with their technical team I have received personalized, attentive, responsible attention and I am always assisted by an expert staff the topic. A TIBCO technical support technician spent more than an hour helping me to solve a problem in the initial stage of implementation in my department and this is something that I always appreciate.
Read full review Online Training
The training was helpful. I was able to understand how to use TIBCO for the data load process that we implemented and how to perform various troubleshooting steps based on the training I received. The technician was thorough and took the time to answer any questions. Once we were shown how to use TIBCO in the test environment, we were able to configure the production environment ourselves.
Read full review Implementation Rating
We were able to control on access and built various enviroment for implementation
Read full review
Other vendors have clearer, more visual implementation documentation. We also did not have our data architect and and server administrator available full-time for implementation. In the future, we will secure the necessary internal resources.
Read full review Alternatives Considered
Overall, Matillion is an excellent choice for businesses that need a powerful and easy-to-use data integration and transformation platform that can handle large volumes of data. While it may be a bit pricey for some organizations, the platform's reliability, scalability, and customer support make it a worthwhile investment for many businesses.
Read full review
We did not need to evaluate another technology in the same category for data virtualization, since we are 100% sure of the capabilities and benefits that we would have with TIBCO Data Virtualization, both for market positioning as well as success stories from other companies. great renown worldwide. From the first day of use, it meets our needs to provide the expected solutions.
Read full review Scalability
Matillion has a nice scalability capacity, and once it has been stored in our AWS cloud it makes it much easier to scale it on demand. The reason I'm not rating it as 10 is that there is no way to migrate or move it to another cloud in an easy way.
Read full review
It seems to be flexible and scalable based on our needs.
Read full review Return on Investment Saving us time reduces our need for headcount Allows us to collaborate on data-eng pipelines in a transparent way with non-technical stakeholders, ensuring accuracy and continuity Allows us a single platform to log and manage all of our pipelines to pin-point where something failed and why Always has a solution to very common data engineering tasks, i.e., real-time data, connectors, pre-built workflows, etc. Read full review We took spreadsheets that took hours a month to update and made them update automatically using TDV, saving hours a month of analyst time The incremental cost of TDV relative to straight spotfire licensing made it a no-brainer due to the ease of data management We continue to automate legacy business processes in TDV, saving time all over the organization. Read full review ScreenShots TIBCO Data Virtualization Screenshots