

KNIME Business Hub and Dremio compete in the data analytics and management software category. KNIME appears to have the upper hand due to its flexibility and beginner-friendly no-code interface, making it suitable for a broader range of users.
Features: KNIME Business Hub offers tools for ETL processes, integration with multiple languages, and a comprehensive algorithm library, catering to both beginners and advanced users. Its no-code interface is a significant advantage. Dremio provides a unified platform for data lakes, excellent data lineage, and reflection features, enabling seamless connections with diverse data sources. Its strength lies in integrated data management capabilities.
Room for Improvement: KNIME could enhance data visualization, support for large datasets, and documentation. Users report performance issues with large data volumes and a steep learning curve. Dremio faces challenges with execution speed on large queries, limits in connectors, and complex integration with platforms like Databricks. Improvement in memory management and documentation is needed.
Ease of Deployment and Customer Service: KNIME Business Hub offers flexibility in deployment options, including on-premises and cloud scenarios. Dremio excels in deploying across public and hybrid clouds, favorable for modern data environments. Both have strong community support, but Dremio has better professional support and documentation. KNIME, being open-source, has less formal technical support but benefits from an active community.
Pricing and ROI: KNIME is cost-effective with a free open-source desktop version, appealing to small teams and academic users. The enterprise version offers scalability at a higher price. Dremio, although pricier, provides significant ROI through robust data management and processing capabilities, making it suitable for larger enterprises. Both offer substantial ROI, though KNIME's entry cost is lower, appealing to budget-conscious users.
Dremio surely saves time, reduces costs, and all those things because we don't have to worry so much about the infrastructure to make the different tools communicate.
Definitely in terms of time reduction and the speed with which data is obtained and delivered to the more business-oriented team that then has to make decisions, these two factors are important indicators.
I would rate customer support a ten out of ten.
We contact the technical support at least weekly; currently, it's more or less daily because we face performance issues, crashes of queries sometimes, and we also need support for configuration of the query engines and so on.
We have had to reach out for customer support many times, and they respond, so they are pretty supportive about some long-term issues.
While they cannot always provide immediate answers, they are generally efficient and simplify tasks, especially in the initial phase of learning KNIME.
My mark for technical support for KNIME Business Hub is about a 7, as most of the support is in the community, and it is quite good because it is open source.
I carefully examined KNIME Business Hub resources in terms of videos, tutorials, courses, and documentation, which are very comprehensive.
Dremio's scalability can handle growing data and user demands easily.
Internally, if it's on Docker or Kubernetes, scalability will be built into the system.
Dremio's scalability depends on your hardware and your deployment.
KNIME Business Hub scales quite well regarding data volume.
I rate Dremio a nine in terms of stability.
We refactored the query, and that worked, but it still doesn't make you confident to go to production with a product that might crash depending on the query you send it.
For now, KNIME Business Hub is excellent for me and for our team.
From 1 to 10, I would rate the stability of KNIME Business Hub quite good, around an 8 or 9.
KNIME Business Hub is stable with small connection issues with the company data system.
Starburst comes with around 50 connectors now.
Before we wrap up, I want to add that Dremio is lacking a semantic layer in a manner that the user can just choose dimensions, metrics, and filters to query the data.
It should be easier to get Arctic or an open-source version of Arctic onto the software version so that development teams can experiment with it.
I would like to see additional functions in KNIME Business Hub that can connect to generative AI, allowing users to describe the workflow for easier workflow generation and creation.
When I import this data set in the File Reader node, I have problems with this field because it is a date, but the problem is that it imports it as text.
Computer vision is the most important because now there is a new age of large language models and visual language models.
I chose eight out of ten because Dremio is expensive for the Enterprise version, particularly regarding licensing.
I had a good experience with pricing, as the pricing seems okay to me and the client.
Dremio does have a core of the engine that is open-source, but all the important features for the enterprise version are under license.
Having everything under one system and an easier-to-work-with interface, along with having API integrations, adds significant value to working with Dremio.
Dremio has positively impacted my organization as nowadays we are connected to multiple databases from multiple environments, multiple APIs, and applications, and Dremio organizes everything in an amazing way for me.
Multiple data sources can be queried in one query, and it is not just a query engine.
KNIME Business Hub has had a positive impact on my organization by leading to time savings, as many activities were automated and reduced to a morning check, whether daily or weekly, to verify that all flows had run.
KNIME is more intuitive and easier to use, which is the principal advantage.
KNIME is simple and allows for fast project development due to its reusability.
| Product | Mindshare (%) |
|---|---|
| KNIME Business Hub | 4.1% |
| Dremio | 2.0% |
| Other | 93.9% |

| Company Size | Count |
|---|---|
| Small Business | 3 |
| Midsize Enterprise | 6 |
| Large Enterprise | 5 |
| Company Size | Count |
|---|---|
| Small Business | 21 |
| Midsize Enterprise | 16 |
| Large Enterprise | 35 |
Dremio offers a comprehensive platform for data warehousing and data engineering, integrating seamlessly with data storage systems like Amazon S3 and Azure. Its main features include scalability, query federation, and data reflection.
Dremio's core strength lies in its ability to function as a robust data lake query engine and data warehousing solution. It facilitates the creation of complex queries with ease, thanks to its support for Apache Airflow and query federation across endpoints. Despite challenges with Delta connector support, complex query execution, and expensive licensing, users find it valuable for managing ad-hoc queries and financial data analytics. The platform aids in SQL table management and BI traffic visualization while reducing storage costs and resolving storage conflicts typical in traditional data warehouses.
What are Dremio's most valuable features?Dremio is primarily implemented in industries requiring extensive data engineering and analytics, including finance and technology. Companies use it for constructing data frameworks, efficiently processing financial analytics, and visualizing BI traffic. It acts as a viable alternative to AWS Glue and Apache Hive, integrating seamlessly with multiple databases, including Oracle and MySQL, offering robust solutions for data-driven strategies. Despite some challenges, its ability to reduce data storage costs and manage complex queries makes it a favorable choice among enterprise users.
KNIME Business Hub combines user-friendly and no-code capabilities, supporting workflow automation, data preparation, and ETL processes. It's an excellent choice for both technical and non-technical teams needing efficient data analysis and management.
KNIME Business Hub is designed for those who require seamless integration with R and Python. It supports data visualization, machine learning, and text analytics, enhancing collaboration and workflow sharing. The centralized management system improves productivity and governance. However, users desire better data visualization and integration with popular tools and cloud platforms. Access to comprehensive documentation and training, improved scalability, and better handling of large datasets are noted areas for development. Users frequently employ it for tasks like data extraction, transformation, and automation across SQL databases and Excel.
What are the key features?KNIME Business Hub sees widespread use in industries such as revenue management, engineering, education, and enterprise-level data analytics. Its visual interface allows teams to design complex workflows easily and deploy models without extensive coding, supporting diverse data processing and analytics tasks.
We monitor all Data Science Platforms reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.