I primarily use KNIME for ETL, extracting data from different sources. I extract data from endpoints of Drupal created for me by developers, then transfer this data into Oracle. After extracting, I create a model in Oracle with ETL, which is used by Power BI. Following this, I create a star schema of the data.
KNIME Business Hub - Basic Edition
KNIME | 1.13.2Linux/Unix, Ubuntu 22.04 LTS - 64-bit Amazon Machine Image (AMI)
Reviews from AWS customer
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
External reviews are not included in the AWS star rating for the product.
Enables fast project development with efficient workflow modifications and promising features while offering modularity and reusability
What is our primary use case?
What is most valuable?
KNIME is simple and allows for fast project development due to its reusability. I appreciate the ability to make improvements or modifications in existing workflows. Although I have not yet used the forecasting and customer profiling features, I find them promising.
Another effective feature is the ability to use GET request objects to retrieve data from websites or APIs. This makes iterative steps easy to manage. It is more elastic and modern compared to SAP Data Services, allowing node creation and regrouping components or steps for reuse in different projects.
What needs improvement?
I have seen the potential to interact with Python, which is currently a bit limited. I am interested in the newer version, 5.4, when it becomes available. The machine learning and profileration aspects are fascinating and align with my academic background in statistics.
For how long have I used the solution?
I have been working with KNIME for almost five years now.
What do I think about the stability of the solution?
Occasionally, when using the GET object, there might be issues due to the velocity of the lines or the IT system of the commission. Overall, stability is not a significant concern.
What do I think about the scalability of the solution?
I have not encountered any scalability limitations with KNIME at the moment.
How are customer service and support?
I contacted their technical support around five times. While they cannot always provide immediate answers, they are generally efficient and simplify tasks, especially in the initial phase of learning KNIME.
How would you rate customer service and support?
Neutral
Which solution did I use previously and why did I switch?
I also worked with Power BI and BusinessObjects and have experience with typical data services access.
How was the initial setup?
The initial setup was straightforward, taking between half an hour and an hour depending on the data entity.
Which other solutions did I evaluate?
I use SAP Data Services as well, but I find KNIME more elastic and modern.
What other advice do I have?
I am impressed by the modularity and reusability in KNIME, especially the ability to make small adjustments to object configurations. I am interested in its interaction with Python and machine learning aspects. Also, I recommend KNIME to others as I face difficulty finding reasons not to. My overall rating for KNIME is between nine and ten.
Which deployment model are you using for this solution?
Intuitive design and helps with academic work while graphic features need clarity
What is our primary use case?
I use KNIME for my academic works.
What is most valuable?
KNIME is more intuitive and easier to use, which is the principal advantage.
What needs improvement?
For graphics, the interface is a little confusing. So, this is a point that could be improved.
For how long have I used the solution?
I have been using KNIME for six months.
What other advice do I have?
I'd rate the solution seven out of ten.
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Provides data analytics with easy setup and vast documentation
What is our primary use case?
We use the solution for data analytics and logic design.
How has it helped my organization?
The product is working fine with Oracle.
What needs improvement?
It is is written in Java. If they can output the Javascript, it will be much better. Also, it could be integrated with Visual Studio.
For how long have I used the solution?
I have been using KNIME for three years.
What do I think about the scalability of the solution?
20 users are using this solution. Scalability is quite easy, but handling many notes can become messy.
How are customer service and support?
Most of the things is available in the community.
How was the initial setup?
It's quite easy to setup.
I have a CSV reader. When I reset that CS reader, and It gave some error.
What other advice do I have?
I have a CSV reader, and I encounter an error whenever I try to save. However, if I reset the CSV reader, I am able to save successfully. It’s a rare issue, but there's something wrong with the CSV reader. The error message doesn't provide a solution, only indicating a problem with the CSV reader.
I want to save the project but always face saving issues. If I reset the node, the saving works fine. The error message isn’t clear about what is wrong or how to fix it. I discovered on my own that resetting the CSV reader from green to yellow allows me to save the project. This issue is quite rare.
Last Friday, there was a widespread CrowdStrike issue, and I had to restart my computer. After restarting, I lost my entire project.
I recommend the solution.
Overall, I rate the solution a nine out of ten.
User-friendly tool with efficient integration features
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.
Good for data analysis to model prediction and application but data load limitations
What is our primary use case?
Rather than specific use cases, I've used it in different sectors. Mostly education. For example, we've used it to predict the kinds of courses or degrees students should pursue based on their skill set and learning capability.
What is most valuable?
KNIME is very easy to handle and use. Anyone can use it, and it's easy to learn. You don't need a specific class. They're very good at model prediction. It has got everything.
From data analysis to model prediction and application, it's very good. I only use the free community edition, not the enterprise one. I feel KNIME is really good. I haven't tried any other tool or platform yet, but KNIME is pretty good.
The workflow is great. You drag and drop, and then you have the data explorer and charts that give results.
The execution is also good – it's easy to identify where your model has gone wrong. It shows you the exact point of error within the workflow, so you don't have to execute the entire workflow to find it. For example, if your workflow has ten steps and the error is in the sixth step, it will show you the error at that step. You don't have to worry about the first five steps.
The Data Explorer is very good, and the charts are great too. The accuracy charts for different models, like decision tree, K3, Naive Bayes, are all very good. KNIME is great at reporting, whether it's structured or unstructured data. These are all very good features.
What needs improvement?
One disadvantage is the data load. KNIME has limitations. It doesn't handle large datasets or a high number of records well. I haven't tried more than 10,000 to 20,000 records because the model prediction doesn't come out well with more data. The Enterprise Edition might work better, but I've only used the Community Edition.
That's the only disadvantage I've encountered so far.
For how long have I used the solution?
I used it for four to five months, from the beginning of last year until January.
What do I think about the stability of the solution?
It is stable. I would rate the stability a nine out of ten.
What do I think about the scalability of the solution?
Scalability is also very good. Both the older and newer versions have improved. I would rate the scalability an eight out of ten.
How are customer service and support?
I haven't needed it yet. I've been able to do everything myself.
How was the initial setup?
I would rate my experience with the initial setup an eight out of ten, with ten being easy.
What's my experience with pricing, setup cost, and licensing?
I use the open-source version. I haven't explored the paid options yet.
What other advice do I have?
Overall, I would rate it a five out of ten.
Improves performance analytics and offers a node-based data integration and processing system
What is our primary use case?
It is suitable for various industries, including government, enterprise business, product manufacturing, and banking and finance. KNIME provides effective solutions for data-related tasks.
How has it helped my organization?
It takes and improves performance analytics.
What is most valuable?
It offers a node-based data integration and processing system connected through a user-friendly drag-and-drop interface. This makes it an excellent choice for data analytics and engineering tasks. We focus on integrating important features with a strong emphasis on security.
What needs improvement?
The current UI is primarily in English. Analyzing data in local languages might present challenges or issues.
For how long have I used the solution?
I have been using KNIME as a partner for three years.
What do I think about the stability of the solution?
I rate the solution’s stability an eight out of ten.
What do I think about the scalability of the solution?
It lacks third-party connections that influence scalability. 3 people are using this solution. It is suitable for small to medium.
I rate the solution’s scalability a six out of ten.
How are customer service and support?
KNIME offers online training, which is quite effective. The training includes various modules, and completing them can lead to certification.
How would you rate customer service and support?
Positive
How was the initial setup?
The server versions have no designated hardware requirements for initial installation and configuration. This can lead to difficulties, such as errors related to hardware and sizing. Providing the right hardware and understanding the setup requirements is crucial for proper configuration.
I rate the initial setup an eight out of ten, where one is difficult and ten is easy.
What's my experience with pricing, setup cost, and licensing?
I rate the product’s pricing a seven out of ten, where one is cheap and ten is expensive.
What other advice do I have?
KNIME offers a free starter tool with a desktop version that allows you to manage the entire data lifecycle and build data pipelines. This is suitable for small data science or engineering teams. However, if you need to deploy KNIME at an enterprise level or require advanced features, you must purchase a license. The pricing is reasonable compared to alternative tools, but it might be beneficial if there were more affordable options for small businesses or SMEs.
Overall, I rate the solution an eight out of ten.
Which deployment model are you using for this solution?
User-friendly, easy to use, and provides good documentation
What is our primary use case?
KNIME is an analytics platform. We use the tool for prototyping solutions by using flat files without database connections. We use it for the decision tree models.
What is most valuable?
The product is user-friendly. It is easy to use. My experience is very good. We could see the benefits of the solution immediately after deployment. It is a complete solution. The documentation is very good.
What needs improvement?
The support could be improved. We do not have much documentation in Portuguese.
For how long have I used the solution?
I have been using the solution for two years.
What do I think about the stability of the solution?
The product’s stability is very good.
What do I think about the scalability of the solution?
The scalability is good, but we do not have the production environment to put the models on the cloud.
How was the initial setup?
The deployment is easy. The deployment takes 15 days.
What about the implementation team?
We did the deployment in-house. We needed six people for the deployment. We do not have to maintain the tool.
What's my experience with pricing, setup cost, and licensing?
KNIME Business Hub is expensive for small companies. The desktop version of the tool is affordable. The analytics platform is free.
What other advice do I have?
We usually use machine learning tools to push the models into production. The desktop version does not have the feature to scan models. We must buy KNIME Business Hub if we need those features. It is more expensive than machine learning tools.
KNIME’s desktop version is more suitable for prototyping than machine learning tools. New users must go through the documentation to understand the components. It's a user-friendly tool. If we have machine learning skills, we can use the tool easily. Overall, I rate the solution a nine out of ten.
Which deployment model are you using for this solution?
Free to use and offers data preprocessing and ETL track-building capabilities
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?
Has a drag-and-drop interface and AI capabilities
What is our primary use case?
I use KNIME for a wide variety of purposes. Most recently, I employed it in a survey and experiment to explore different teaching methods, specifically using software to help nurses learn drug dose calculations. This became particularly important during the pandemic when there was an urgent need to reskill healthcare professionals rapidly.
During the early days of the pandemic, no one knew how to treat COVID-19, and it was a dire situation with high mortality rates. The healthcare system had to adapt quickly, with retired nurses and doctors being called back into service and nursing students stepping up to meet the demand. A program I had previously worked on, which taught drug dose calculations, became crucial again. Nurses had to familiarize themselves with a whole new set of drugs.
I analyzed the data from this program using KNIME. I handled various statistical analyses, including mean, standard deviations, regression, correlation, and Wilcoxon signed-rank tests.
What is most valuable?
It's difficult to pinpoint one single feature because KNIME has so many. For starters, it's very easy to learn. You can get started with just a one-hour video. The drag-and-drop interface makes it user-friendly. For example, if you want to read an Excel file, drag the "read Excel file" node from the repository, configure it by specifying the file location, and run it. This gives you a table with all your data.
Next, you can clean the data by handling missing values, selecting specific columns you want to analyze, and then proceeding with your analysis, such as regression or correlation. KNIME has over 4,500 nodes available for download.
In addition, KNIME offers various extensions. For instance, the text processing extension allows you to process text data efficiently. It's more powerful than other tools like NVivo and Palantir.
KNIME also has AI capabilities. If you're unsure about the next step, the AI assistant can suggest the most frequently used nodes based on your previous work.
Another valuable feature is the integration with Python. If you need to perform a task that requires Python, you can simply add a Python node, write the necessary code,
What needs improvement?
The hardest part is keeping a tidy workspace because of the many nodes involved. When teaching, it would be helpful if there was more emphasis on how to group nodes effectively. For example, turning frequently used nodes into a single component can simplify things.
For how long have I used the solution?
I have been using the product for three to four years.
How are customer service and support?
When I had to do things new to me and didn't know how to proceed, I used the KNIME hub and community forum. Both times, I received answers within twelve hours that solved my problems. From that experience, I'd say their support is superb, even on the free version, and I imagine it's even better on the paid version.
What's my experience with pricing, setup cost, and licensing?
I use the solution's free version.
What other advice do I have?
The tool has a community, and people are very helpful. I've been impressed by that. I'm trying to think of ways I want to improve. I did start it up on a Windows PC. It seemed a bit easier for some reason, but I'm now on a Mac. I have trouble with the magic mouse, but that's an issue with any software not specific to KNIME. It worked well when I received data from other people. I haven't tested it on a ten-billion-item database, but it works well for hundreds of thousands to a million items. I haven't tried the big databases because that's for the commercial version.
The solution has a lot of video material for teaching and upskilling people. If I've got a colleague that I just introduced to it, I send them links to two videos, and they learn from that. That's two hours of work for them in two sessions, and they've got a programming language under their belt.
For instance, I've never used it to build a neural net, though it has many different neural nets. I have used it for decision trees, regression models, and so on, and KNIME has been very easy to use for those. It takes much of the work away from you. For example, if I build a decision tree, I usually want to take several samples from your training data and then choose the best outcome.
With the tool, you just put the Decision Tree Learner node in there, set what percentage you want for training and testing, say 60% for learning and 40% for testing, and how many times you want to do it, like seven times. It runs seven samples, does the training and testing, and reports back to produce a model. Then, you can use a Scorer node to score your results. I produced the first-ever machine learning exercise in nursing in 2008, which wasn't using KNIME, but I think KNIME was available then. That project was associated with a reduction in the dropout rate from the university from 19% to five percent over three years. And you can do all that for free with KNIME, even with a dataset of about 1,200 students, on your PC with no trouble.
I read a report from Uppsala in Sweden where, during the pandemic, they had to repurpose many drugs developed for other diseases to find out which ones would be useful for COVID. They went through thousands and millions of drugs, and it seemed to reduce the time to develop or choose drugs by a major factor.
The solution accessed about eight or ten different chemical databases, biobanks, and similar resources and could integrate with all of them. One of the good things about KNIME is its ability to read different data sources. For instance, it has platform connectors, allowing you to link to various external systems. It's just a matter of plugging in a node and linking it up without usually needing to write new code. For example, in my use case, reading from an Excel file used to require configuring a node manually, but now you choose the file you want to analyze, put it on your workspace, and it recognizes the file structure automatically, whether it's an Excel file, CSV, or tab-delimited file, and provides the correct node. It's quite intelligent.
If you’re considering using the solution for the first time, I recommend starting with a one-hour introductory video to get a basic understanding. If you need more information, check out KNIME TV. They have a channel with hundreds of short videos, usually five to 30 minutes long. These videos show you how to drag and drop nodes, configure them, and run them to see the results. It’s a very visual way of learning.
I rate the overall product a nine out of ten.
Simplifies data modeling but needs to add longer training videos
What is our primary use case?
I use KNIME to simplify the modeling process.
What is most valuable?
The tool's analytic capabilities are good.
What needs improvement?
I wish there were more video training resources for KNIME. The current videos are very short, and most learning is text-based. Longer training sessions would be helpful, especially for complex flowchart use cases. Webinars focusing on starting projects and analyzing data would also be beneficial.
What do I think about the scalability of the solution?
The solution is scalable.
How are customer service and support?
I haven't contacted the tool's support yet.
How was the initial setup?
The tool's deployment is easy.
What's my experience with pricing, setup cost, and licensing?
I use the tool's free version.
What other advice do I have?
It takes some time to get familiar with it. I'm not sure how long it will take in the meantime. If one person learns it but the whole institution doesn't use it, that's a problem. Some people in our department use QuickSight, I use Tableau. We speak different languages, and it's hard for us to work together. Some use KNIME. We use it and then stop. We switched to Tableau, but it's expensive, so they're trying QuickSight. I don't know which platform we'll end up using.
We're still exploring KNIME for data manipulation, though Tableau or Power BI might be more convenient. I've used Alteryx before, and KNIME seems similar. I mainly use KNIME for machine learning, not as much for data manipulation.
I rate the overall product a seven out of ten.