Try our new research platform with insights from 80,000+ expert users
reviewer2230581 - PeerSpot reviewer
SAP Fi Consultant at a manufacturing company with 1,001-5,000 employees
Real User
Top 20
Allows integration of data from multiple sources but complexities in integrating with certain systems
Pros and Cons
  • "I've tried to utilize KNIME to the fullest extent possible to replace Excel."
  • "I've had some problems integrating KNIME with other solutions."

What is our primary use case?

It's mostly data preprocessing, handling, and processing (ETL) processes, as well as expanding the transport load. 

Additionally, we also work on various machine learning tasks, such as regression models and other small topics related to machine learning.

What is most valuable?

I've tried to utilize KNIME to the fullest extent possible to replace Excel. Our company has been heavily reliant on Excel for generating reports and performing data transformations. With KNIME, I've been able to combine data from Excel, SQL Server, and various other resources efficiently.

What needs improvement?

There are a few aspects that I am not entirely satisfied with. For instance, when integrating KNIME with our SAP system ERP and HANA, it's not as straightforward as expected. We need to find alternative connectors like the Teradata connector, which adds complexity.

So far, I've had some problems integrating KNIME with other solutions. Thus, it could be an area of improvement. 

For how long have I used the solution?

We have been using KNIME for two years.

Buyer's Guide
KNIME
January 2025
Learn what your peers think about KNIME. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
832,565 professionals have used our research since 2012.

What do I think about the stability of the solution?

Overall, the product has been stable. It has efficiently handled the tasks we have encountered so far.

What do I think about the scalability of the solution?

There are two end-users using KNIME in our organization. Because we are still beginners, we are only using it to learn how it works and get a better understanding of the system. We are not yet certain if we will use it extensively for all topics.

How was the initial setup?

The initial setup was easy. 

What about the implementation team?

I deployed the solution myself. 

What's my experience with pricing, setup cost, and licensing?

We use the free version only. 

Which other solutions did I evaluate?

We are working with KNIME on some small projects, but we are also looking for an alternative solution to explore.

What other advice do I have?

Overall, I would rate KNIME a seven out of ten because we faced a problem with the integration with other products, like SAP.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user461148 - PeerSpot reviewer
Partner, Turkey and The Netherlands at a tech vendor with 201-500 employees
Real User
Our average record size was around 10 million records. If we have bigger data, we can opt for a Big Data extension for Hadoop, Spark, etc.

What is our primary use case?

In demand forecasting projects to extract, to clean and to transform data from various resources. Also some clustering and classification techniques are used for behavioural clustering and classification according to attributes.

How has it helped my organization?

My organization's field of activity is to develop business applications for niche areas. Almost three years ago, we decided to extend our solutions with advanced analytics. KNIME let us start easy and fast into the Advanced Analytics area. We are able to try project ideas with KNIME by doing proof of concept easy and prototyping fast.

What is most valuable?

  • Easy ETL operations
  • Rich algorithm set
  • Integrated with other languages like R, Python, and Java.
  • Works together with other technologies like DeepLearning4j, H2O.ai, D3.js, and Weka.
  • Ease of use and being a performant solution.
  • Continues development and wide community support

What needs improvement?

I mentioned about the distributed architecture in my previous answer, but they did with version 3.5. This time maybe I could add the integration with graph databases like Neo4j.

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

In the previous versions, I had some issues when reading large Excel files due to memory usage. But with the previous version (3.3), they renewed all Excel nodes and now I have no problem. 

What do I think about the scalability of the solution?

With the data sizes that I dealt with, I did not. Our average record size was around 10 million records. If we have bigger data, we can opt for a Big Data extension for Hadoop, Spark, etc.

How are customer service and technical support?

I used it very little. All of them replied to me in one day. (It was not professional support, just over a forum). Also, I can find enough information in the documentation and forum.

Which solution did I use previously and why did I switch?

Before KNIME, I used SQL language and Excel for data analysis but machine learning algorithms. In parallel to KNIME, I worked on a few projects with R and Python separately. So I cannot say that I switched from different solutions.

But just for ETL with Excel, KNIME brings me better visualization, rich function set, preserving operations to repeat again and better performance on the same hardware.

How was the initial setup?

I am using Mac and it is so easy. Download a .dmg, extract it as an app, and copy it to the applications folder. On windows it is also simple installation.

For extensions like R or Python, you need experience with general OS and installation processes.

What about the implementation team?

We did in-house.

What was our ROI?

The biggest ROI comes from productivity when creating new things and also supporting old jobs.

And there is no hidden cost. Licensing is simple and open than other platforms.

What's my experience with pricing, setup cost, and licensing?

KNIME is open sourced platform and has a free desktop version with unlimited data size and functionality.

Also, the server version is good for teams and enterprise productivity. Especially the new "Model Factory", which lets data science teams easily build and manage models. When compared with similar products, it is less expensive but as powerful as (or maybe more powerful than) others.

Which other solutions did I evaluate?

The Open Source licensing and community support is one of our important criteria. The second one is the interoperability with other technologies and openness to different data sources. There are two options: RapidMiner and KNIME. We chose KNIME.

What other advice do I have?

Data Science requires freedom for creativity. Sometimes you need to crawl data from the web or social media. Sometimes you need to blend different sources like NoSQL MongoDB and Excel files, etc. It is not only algorithms and data extraction, visualization and preparation steps are important as at least algorithms.

Don't go with software that has complex and hidden licensing costs, which will kill your flexibilty and creativity. Also, interoperability brings the advantage of limitlessness.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partnership with KNIME
PeerSpot user
Buyer's Guide
KNIME
January 2025
Learn what your peers think about KNIME. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
832,565 professionals have used our research since 2012.
Júlio César Gomes Fonseca - PeerSpot reviewer
Data Scientist at Orys
Real User
Top 5
User-friendly tool with efficient integration features
Pros and Cons
  • "It is possible to configure the system to effectively manage memory and space requirements."
  • "Sometimes, we needed more space to handle larger operations, especially since our machines had limited space and memory due to Kubernetes clusters."

What is our primary use case?

We used the product to prepare data for our team. I would prepare SQLs and check them in Oracle Developer, then create workflows in KNIME to manage and process the data, creating specific tables for modeling.

What is most valuable?

The product is a great alternative because it is not an open-source tool and offers simplicity, making it easier for our large team to use.

What needs improvement?

Sometimes, we needed more space to handle larger operations, especially since our machines had limited space and memory due to Kubernetes clusters. Breaking up SQLs was necessary to handle the data flow better.

For how long have I used the solution?

I extensively used KNIME for about one year and at least two months.

What do I think about the stability of the solution?

The product is quite stable.

What do I think about the scalability of the solution?

The platform is scalable. It is possible to configure the system to effectively manage memory and space requirements. 

I rate the scalability a seven out of ten. 

How are customer service and support?

The community support is good, and plenty of shared knowledge is available.

Which solution did I use previously and why did I switch?

We had licensing issues with other tools, but KNIME worked well as an alternative.

What other advice do I have?

We integrated KNIME with Oracle, Apache, and other tools. It allowed us to pull data from various sources, such as Oracle, CSV, and Excel, into one consolidated table, which was very efficient.

Overall, I rate it an eight. It is a good tool, especially for our current requirements. However, there were limitations, such as space issues and occasional process slowdowns due to memory constraints. Despite these challenges, it is a solid product.

I recommend it to other professionals, particularly those who work with diverse datasets and require a flexible tool to manage data flows. It is user-friendly, especially for individuals with a background in Java or Python, as it allows for custom operations and automation, which I found very helpful in my experience.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
reviewer1257420 - PeerSpot reviewer
Crystallization Lab Analyst at a pharma/biotech company with 10,001+ employees
Real User
Simple setup, highly scalable, and overall functions well
Pros and Cons
  • "Overall KNIME serves its purpose and does a good job."
  • "KNIME can improve by adding more automation tools in the query, similar to UiPath or Blue Prism. It would make the data collection and cleanup duties more versatile."

What is our primary use case?

KNIME is used for collecting data for data science.

How has it helped my organization?

KNIME has improved our organization because we are able to collect data in a way that we can interpret and it provides visuals.

What is most valuable?

Overall KNIME serves its purpose and does a good job.

What needs improvement?

KNIME can improve by adding more automation tools in the query, similar to UiPath or Blue Prism. It would make the data collection and cleanup duties more versatile.

For how long have I used the solution?

I have been using KNIME for approximately four years.

What do I think about the stability of the solution?

KNIME is stable.

What do I think about the scalability of the solution?

KNIME is always highly scalable, as new features come out and things that we learn from the new features can help us interpret data better.

We have approximately 12 people using the solution. There are three groups of users, the data entry team, data collection experts, and data interpreters. They use the solution for two months for each project we work on. We are planning on hiring more data scientists.

How are customer service and support?

I rate the support from KNIME a three out of five.

Which solution did I use previously and why did I switch?

I have not used other solutions other than KNIME.

How was the initial setup?

The initial setup of KNIME was not challenging, but it took some practice.

The full deployment took us approximately one year. It took us a little while to adjust to the solution because many of the users did not have an analytics background, we had to teach them.

I rate the ease of setup for KNIME a four out of five.

Which other solutions did I evaluate?

We did evaluate other solutions. We decided to use KNIME because it is open source and was easier to start with.

What other advice do I have?

My advice to others is to start out slow and gradually increase operations. 

I rate KNIME an eight out of ten.

There are other applications that I've used that make collecting the data and interpreting it a lot easier. If they could improve this my rating would increase.

Which deployment model are you using for this solution?

Private Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
CEO at SMH - Schwaiger Management Holding GmbH
Real User
Stable and easy to set up with very good ETL features
Pros and Cons
  • "All of the features related to the ETL are fantastic. That includes the connectors to other programs, databases, and the meta node function."
  • "The predefined workflows could use a bit of improvement."

What is our primary use case?

We primarily use the solution as an ETL - to Extract, Transform, Load topics.

What is most valuable?

All of the features related to the ETL are fantastic. That includes the connectors to other programs, databases, and the meta node function.

Technical support has been extremely responsive so far.

The solution has a very strong and supportive community that shares information and helps each other troubleshoot.

The solution is very stable.

The initial setup is pretty simple and straightforward.

What needs improvement?

The user interface could be a little bit more comfortable. The usability, in general, could be much better.

The predefined workflows could use a bit of improvement.

For how long have I used the solution?

I've been using the solution for five years.

What do I think about the stability of the solution?

The solution is pretty stable. I don't recall facing any bugs or glitches. The solution doesn't crash or freeze. It's fairly reliable overall.

What do I think about the scalability of the solution?

We have about 10 users in the company that are on the solution regularly. They are all either engineers or business consultants.

How are customer service and technical support?

The technical support on offer is very good. We rarely have issues, however, if we do, the support that is provided is very fast and the team is very knowledgeable. There's also a very strong and active KNIME community that includes KNIME developers.

At the end of the day, when we run into issues, it's dealt with immediately and we're very satisfied with the level of service provided.

How was the initial setup?

The initial setup isn't complex. I'd describe it as straightforward. What makes it very easy is that there's so much material available online. Users have access to many forms of documentation, including webinars and training documents. When it comes to finer details, of course, it gets more complex, however, that's pretty normal in every product. 

What other advice do I have?

We are KNIME partners and also provide KNIME training to clients as well.

We're a startup, and we're in the startup phase, however, we are working to build more business relationships with KNIME.

In my previous company, we were also partnered with KNIME. Currently, I'm working as a consultant and we have a customer who is using SAP Analytics, however, I am interested in learning more about the differences between KNIME and SAP Analytics. That's something I'm looking at right now.

We would definitely recommend this solution to other organizations.

I'd rate the solution eight out of ten. I don't know if there's a tool better than this particular product, however, there's always room for improvement on any technology.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
reviewer2404269 - PeerSpot reviewer
Data Scientist at a tech services company with 1,001-5,000 employees
Real User
Top 20
Free to use and offers data preprocessing and ETL track-building capabilities
Pros and Cons
  • "The solution is very easy to use"
  • "The graphic features of KNIME need improvement"

What is our primary use case?

At our company, we provide consultation services to federal institutions, and in some cases, we recommend KNIME to clients and have also implemented the solution for a few projects. 

What needs improvement?

The graphic features of KNIME need improvement, especially when working on dashboards. 

For how long have I used the solution?

I have been using KNIME for three years. 

What do I think about the stability of the solution?

The stability of KNIME depends on the resources on the computer in which it's installed. KNIME requires a high capacity of RAM and memory; if the hardware needs are fulfilled, then the product shows satisfying stability. 

When I used to work on KNIME every day, I faced some issues, but they were quickly resolved with the help I received from the active KNIME community. 

What do I think about the scalability of the solution?

Our organization has about ten KNIME users, and the solution is used around once a month. 

How are customer service and support?

I would rate tech support a nine out of ten. 

How would you rate customer service and support?

Positive

Which solution did I use previously and why did I switch?

I have experience in Qlik Sense, Tableau, and native Python programming. I personally switched to KNIME because my present employer had KNIME already implemented in the company. 

How was the initial setup?

The initial setup of the solution is easy. Installing the KNIME Analytics free version on a desktop takes only a few minutes. The setup and installation process is quite easy to begin. 

What about the implementation team?

The implementation was carried out in-house. The solution is free to use; therefore, a partner or reseller is not needed. For the KNIME Business Hub, our organization is directly communicating with KNIME, and a reseller isn't required. 

What's my experience with pricing, setup cost, and licensing?

KNIME offers a free version to use. KNIME also has a server version with almost the same price as competitors. 

What other advice do I have?

In data analytics workflows at our company, we use KNIME for the preprocessing of data, and for a few projects, an ETL track was built using KNIME. We are planning to use KNIME Business Hub to create data apps where a dashboard of analysis can be prepared and presented to others. 

Our company mostly uses KNIME for small datasets, projects, and customers who don't have much expertise in data analysis. We introduce KNIME to our organization's customers to get started with data analysis. The solution is very easy to use. For advanced data analytics, I use a tool different from KNIME. 

The product has impressive data-blending capabilities. The solution is user-friendly and helps our company easily onboard new users. I would definitely recommend the product to others, majorly to individuals with beginner-level programming and data analytics skills. I would rate KNIME an eight out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Software developer at MTNIrancell
Real User
Top 5Leaderboard
Is user friendly and you can simply drag and drop elements to create your model
Pros and Cons
  • "It allows for a user-friendly approach where you can simply drag and drop elements to create your model, which is a convenient and effective idea."
  • "The pricing needs improvement."

What is our primary use case?

I encountered a problem that I managed to resolve effectively. I documented the issue in a paper and aimed to determine if the issue was due to normal network behavior or an anomaly. To investigate, I employed machine learning models and used the KNIME’s database. I gathered a significant amount of data and extensively applied machine learning models. Ultimately, I achieved improved data accuracy, especially in the context of network data.

What is most valuable?

I believe that some individuals may not be skilled programmers, and this is where the agenda comes in. It allows for a user-friendly approach where you can simply drag and drop elements to create your model, which is a convenient and effective idea.   

What needs improvement?

The pricing needs improvement. 

For how long have I used the solution?

I have been using KNIME for the past six months.

What do I think about the stability of the solution?

It is stable solution.

What do I think about the scalability of the solution?

It is scalable solution. 

How was the initial setup?

The initial setup is straightforward.

What's my experience with pricing, setup cost, and licensing?

It is expensive to procure the license.

What other advice do I have?

I would rate the overall solution an eight out of ten. I would suggest this application to individuals involved in auditing. It's user-friendly and makes it easy to initiate model creation.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
COULIBALY ZOUMANA - PeerSpot reviewer
Cybersecurity web editor at Cyberdefbox
Real User
Top 10
Highly stable but dynamic column name feature needs improvement
Pros and Cons
  • "I would rate the stability of KNIME a ten out of ten."
  • "The dynamic column name feature could be improved. When attempting to automate processes involving columns, such as with companies, it becomes difficult to achieve the same result when we make changes."

What is our primary use case?

I am an intern. I am pursuing my master’s degree. I use this solution to propose a solution for accreditation review. I needed a tool to automate this task for my sources. This solution has helped me to do that.

What needs improvement?

The dynamic column name feature could be improved. When attempting to automate processes involving columns, such as with companies, it becomes difficult to achieve the same result when we make changes. So maybe it would be helpful to have a way to find similar column names automatically and execute a single approval, for instance.

In future releases, I can suggest having an API along with tools or services. This would allow for customization since the API is already available in other versions.

So, I suggest having an API for customization.

For how long have I used the solution?

I have been using KNIME for six months.

What do I think about the stability of the solution?

I would rate the stability of KNIME a ten out of ten. 

What do I think about the scalability of the solution?

I would rate the scalability of KNIME a six out of ten. 

Which solution did I use previously and why did I switch?

I have used Alteryx. I prefer this solution over Alteryx because of the pricing point. KNIME is free and open source. 

How was the initial setup?

The initial setup is easy. I will rate my experience with the initial setup a nine out of ten, where one means it's difficult to set up, while ten means it's very easy.

What about the implementation team?

I deployed the solution myself. It took around one month to deploy it. 

What's my experience with pricing, setup cost, and licensing?

KNIME is free and open source. I would rate the pricing model one out of ten, where one is low price, and ten is high price. 

What other advice do I have?

It is a good tool and easy to learn. We do not need to know the codes before using the solution.

Overall, I would rate the solution a seven out of ten. 

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user