[KNIME Analytics] is greatly suited for repetitive tasks one has to perform in excel as it automates these mundane tasks. [KNIME Analytics] is also well suited for creating a seamless connection with other BI tools to enable hands-free file sharing. [KNIME Analytics] has improvements to make on the overall User interface, its data visualization package and advanced level of AI-related tasks such as text mining,
The same way you design data integration job can be used to design services. It is easy to enhance by custom components and can adapt to all requirements. Talend Data Integration connects to [a] multitude of data sources and streaming service. Very easy interface to design complex applications without spending much time on coding. Easy to learn and master. Talend constantly strives to better itself by adding more features and functionalities.
We use Talend Data Integration day in and day out. It is the best and easiest tool to jump on to and use. We can build a basic integration super-fast. We could build basic integrations as fast as within the hour. It is also easy to build transformations and use Java to perform some operations.
Since it is relatively new, there has not developed a vast previously asked/frequently asked questions library that comes up when you google an issue you come across with. This will happen only in time, and as the community grows. Because of the same reason, the community is not big. Consequently, it is possible not to receive good, fast responses to asked questions in community hubs and forums.
Good support, specially when it relates to PROD environment. The support team has access to the product development team. Things are internally escalated to development team if there is a bug encountered. This helps the customer to get quick fix or patch designed for problem exceptions. I have also seen support showing their willingness to help develop custom connector for a newly available cloud based big data solution
Alteryx : allows for generally "data" knowledgeable workers to easily implement and develop a data model in an automated fashion. The collaboration tools built in also make is easy for members to share work, best practices, and custom modules
Alteryx is not cloud based solution where as KNIME Analytics has that
Alteryx was selected due to better user interface and better in data analytics
Talend is much versatile in assimilating various different business use cases. It covers more functionality and is packed with tons of features to explore. It has the ability to fine tune to each project, and not be a one-fits all solution. Problems with Excel, is that it is not suited for large projects, collaboration work. Alteryx is a very costly alternative.
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.
