KNIME Analytics Platform vs. Talend Open Studio

KNIME Analytics Platform has vastly improved our effectiveness when working with large data sets. The self documenting GUI allows analysts to focus on what they are trying to accomplish, not complex code syntax. If we were to use traditional tools, like SQL, work would take much longer and it would be more difficult to collaborate both internally and with clients. Since KNIME Analytics Platform is database oriented, some spreadsheet functions are not supported, which is as it should be. For small data sets we often use Excel vlookup and pivot tables in place of KNIME Analytics Platform. If VBA code is requried, we go to KNIME Analytics Platform as we find VBA to be unstable in Excel.

It is certainly suitable for agile and innovative projects. For developments that require particular steps and with a simple debug. On the other hand, it is not very suitable for producing flows that move large amounts of data and that require a lot of resources and great stability.

Incentivized

• Visual programming as oppose to scripting encourages data analysts to reap deeper insights from their data
• Large community contribution in extending the KNIME Analytics Platform into other areas of analytics, e.g. Text Analytics, Predictive Analytics, ML, etc.
• Open source with periodic updates ensures it is equipped to deal with the most sophisticated data analytics use case

• It does provide a lot of predefined functionality out of the box along with providing the facility to use complex java code for developers.
• Mainly like it for small data utilities. It does provide a lot of control for developers.
• Pricing is, of course, a major plus :)

Incentivized

• Automation - e.g. RapidMiner Studio provides a Turbo Prep function, where one can get to working on models more quickly (RapidMiner is not open source though)
• KNIME does not replace a regular reporting tool - it is not meant to. However, if I have already spent some time developing a data acquisition and analytical model, it would be nice to be able to deploy, for example, a monitoring or reporting module that would process data autonomously and react accordingly.

Incentivized

• The community is not that up to date and forum is not that great in response. Probably we should make people aware of the tool more on how to use and its implementations.
• Talend crashes when transforming a lot of data (millions of rows).
• Proper training documentation is a must for talend which is currently lagging. This will help users to learn more about Talend and use it effectively.

Incentivized

We are happy with Knime product and their support. Knime AP is versatile product and even can execute Python scripts if needed. It also supports R execution as well; however, it is not being used at our end

There is no licence requirement for Talend Open Studio. So, this is not relevant question. However, if you are asking whether we will use Talend in future. Yes. We will continue to use it. It's very powerful free tool which caters to all our extra, transform, load capabilities. We just love Talend for it's great functionality and ease of use.

Incentivized

The training KNIME Analytics Platform provide helps you get to grips with a product that is already very intuitive. There is a KNIME Analytics Platform way of thinking about addressing problems, but once you understand a couple of patterns which you see again and again in your workflow it all makes sense.

Incentivized

Talend Open Studio is based on Eclipse and is full of redundant procedures to do one thing, like when installing libraries. Sometimes I cannot manually download the libraries that it can't find.

Many times, Talend freezes. When you give a cancel command, it takes several minutes to stop. It also takes a great toll on our PC with 16 GB of ram and I7 CPU, even in idle status. If you are downloading Maven Jar/Libraries, you cannot do anything and have to wait until the task is finished.

KNIME's HQ is in Europe, which makes it hard for US companies to get customer service in time and on time. Their customer service also takes on average 1 to 2 weeks to follow up with your request. KNIME's documentation is also helpful but it does not provide you all the answers you need some of the time.

Incentivized

There is only one support staff on a forum created by Talend, which hides behind a nickname and does not show his name. They only ask base questions like: -Talend version - Are you in a proxy? -Do you have all the libraries installed? -It is a Jar missing? (how could I know?) -Follow this link on our site or "please ask your administrators" They then wash their hands of my issues.

KNIME Analytics Platform is easy to install on any Windows, Mac or Linux machine. The KNIME Server product that is currently being replaced by the KNIME Business Hub comes as multiple layers of software and it took us some time to set up the system right for stability. This was made harder by KNIME staff's deeper expertise in setting up the Server in Linux rather than Windows environment. The KNIME Business Hub promises to have a simpler architecture, although currently there is no visibility of a Windows version of the product.

Incentivized

There are two aspects which put KNIME Analytics Platform ahead of other products. Firstly the fact that KNIME Analytics Platform comes at no cost and no restrictions on its use is an instant winner for any organisation wanting to democratise their data. It means that a client is free to install it on as many machines as they wish without worrying about costs, the number of seats required or payment models or procurement negotiation. It also means that we are not building costs into our clients business. Secondly, KNIME Analytics Platform has a very comprehensive set of tools for importing/exporting data, data manipulation and data science. Some products offer analytics packages on top of their base offering at additional cost and they are still not as comprehensive as what you get with KNIME Analytics Platform for free. For some types of analysis you may require to download additional packages with KNIME Analytics Platform, but its invariably at no cost, those packages are kept out of the main download to keep the size down. Due to the easy integration with R and Python, I view KNIME Analytics Platform as also having the capabilities of those languages too. This has helped me in the past with seamlessly importing a rare filetype and using very specific models not directly available in KNIME Analytics Platform.

Incentivized

Informatica has a limited number of components that you can use. This places a heavy limitation on the capabilities of Informatica. On the other hand, Talend allows you to create your own custom components using Java. For businesses that need to perform a wide variety of data operations, it can be quite useful to have the option of creating your own custom components to satisfy business needs.

Incentivized

• It is suited for data mining or machine learning work but If we're looking for advanced stat methods such as mixed effects linear/logistics models, that needs to be run through an R node.
• Thinking of our peers with an advanced visualization techniques requirement, it is a lagging product.

Incentivized

• Being Open Source, your costs on the IDE side are zero.
• There are a lot of programmers with knowledge in Eclipse, they will be comfy using TOS. The development process will be faster.
• Once you develop your Service Bus using TOS, you can connect easily with other Talend products, like DTS, Big Data analysis tools, etc.

Incentivized