What is our primary use case?
Providing the right solutions and consulting in revenue management requires rapid and comprehensive analysis in all areas. Such analysis makes it easier to look for patterns, where and when the cause of a problem is, especially when the solution has hundreds or more servers of different types and characteristics.
I use KNIME as a tool (ETL) in processing various logs and data (structured and unstructured format) then analyze and store the information in a database. This makes it easier to do the analysis and saves me time.
How has it helped my organization?
It very much helps me to do my job while supporting my organization's delivery of service to our client.
What is most valuable?
Most important, it is open-source. Next is the ETL which helps me to collect, reformat, and load the data from multiple sources into one destination, a storage database.
What needs improvement?
I would like it to have data visualitation capabilities. Today I'm still creating my own data visualtions tools to present my reports.
In my environment, I need to access a lot of servers with different characteristics and access methods. Some of my servers have to be accessed using proxy which is not supported by KNIME, so I still need to create the middleware to supply the source of my KNIME configurations.
For how long have I used the solution?
One to three years.
What do I think about the stability of the solution?
I feel the query performance is slower than my old code. In my configurations, I set concurrence for a heavy query database, from multiple database sources, then transformed it before loading it into a destination database. It cannot do concurrent writing into databases if I use one database connection (user).
I’m not sure it is a lack in KNIME or in the database driver itself. To prevent the degredation of performance and system stability, I need to change the configuration of databases readers for output, write parameter onto the disk, not into memory.
How are customer service and technical support?
I have never used tech support, but the community forums are quite good. Hopefully, there will be a knowledgebase, like VMware did.
Which solution did I use previously and why did I switch?
I created my own script. I switched to KNIME because it simplifies the flow of my script into one workspace, and doesn't necessitate a lot of jobs in my system.
Which other solutions did I evaluate?
No, KNIME is my first choice because it's open-source and has features to combine with other scripts.
What other advice do I have?
If you like data analysis, KNIME is the best option. It's free and easy to set up.