KNIME vs Oracle Advanced Analytics comparison

Cancel
You must select at least 2 products to compare!
Knime Logo
3,086 views|2,118 comparisons
93% willing to recommend
Oracle Logo
618 views|407 comparisons
50% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between KNIME and Oracle Advanced Analytics based on real PeerSpot user reviews.

Find out what your peers are saying about Knime, Weka, IBM and others in Data Mining.
To learn more, read our detailed Data Mining Report (Updated: March 2024).
767,995 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The solution allows for sharing model designs and model operations with other data analysts.""The most valuable is the ability to seamlessly connect operators without the need for extensive programming.""I know I don't use it to its full capacity, but I love the Rule Engine feature. It has allowed me to create lookup tables on the fly and break down text fields into quantifiable data.""What I like the most is that it works almost out of the box with Random Forest and other Forest nodes.""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.""KNIME is fast and the visualization provides a lot of clarity. It clarifies your thinking because you can see what's going on with your data.""We are able to automate several functions which were done manually. I can integrate several data sets quickly and easily, to support analytics.""We leverage KNIME flexibility in order to query data from our database and manipulate them for any ad-hoc business case, before presenting results to stakeholders."

More KNIME Pros →

"When needed, we will work closely with Oracle support and implement their workaround in our application.""The dashboard interface is intuitive and the user is able to interact with it to receive good results from the analytic.""Ability to pull together multiple sources of information."

More Oracle Advanced Analytics Pros →

Cons
"From the point of view of the interface, they can do a little bit better.""It's difficult to provide input on the improvement area because it's more of self-learning. However, there are times when I am not able to do certain things. I don't know if it's because the solution doesn't allow me or if it's because of the lack of knowledge.""The pricing needs improvement.""Both RapidMiner and KNIME should be made easier to use in the field of deep learning.""I've had some problems integrating KNIME with other solutions.""I would like it to have data visualitation capabilities. Today I'm still creating my own data visualtions tools to present my reports.""Data visualization needs improvement.""It's very general in terms of architecture, and as a result, it doesn't support efficient running. That is, the speed needs to be improved."

More KNIME Cons →

"Could use some refinement getting things that are not standard cloud applications, but more customized.""There are some transactions we have not been able to find through the dashboard.""The performance, scalability and queries should be addressed, as well as the data distribution of certain data techniques."

More Oracle Advanced Analytics Cons →

Pricing and Cost Advice
  • "It is free of cost. It is GNU licensed."
  • "KNIME desktop is free, which is great for analytics teams. Server is well priced, depending on how much support is required."
  • "KNIME is free as a stand-alone desktop-based platform but if you want to get a KNIME server then you can find the cost on their website."
  • "The price of KNIME is quite reasonable and the designer tool can be used free of charge."
  • "It's an open-source solution."
  • "The price for Knime is okay."
  • "At this time, I am using the free version of Knime."
  • "This is an open-source solution that is free to use."
  • More KNIME Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Mining solutions are best for your needs.
    767,995 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Since KNIME is a no-code platform, it is easy to work with.
    Top Answer:We're using the free academic license just locally. I went for KNIME because they have a free academic license. And to be honest, I never bothered to check the prices.
    Top Answer:KNIME is not good at visualization. I would like to see NLQ (Natural language query) and automated visualizations added to KNIME.
    Ask a question

    Earn 20 points

    Ranking
    1st
    out of 18 in Data Mining
    Views
    3,086
    Comparisons
    2,118
    Reviews
    23
    Average Words per Review
    478
    Rating
    7.9
    7th
    out of 18 in Data Mining
    Views
    618
    Comparisons
    407
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    Comparisons
    Also Known As
    KNIME Analytics Platform
    OAA
    Learn More
    Overview

    KNIME is an open-source analytics software used for creating data science that is built on a GUI based workflow, eliminating the need to know code. The solution has an inherent modular workflow approach that documents and stores the analysis process in the same order it was conceived and implemented, while ensuring that intermediate results are always available. 

    KNIME supports Windows, Linux, and Mac operating systems and is suitable for enterprises of all different sizes. With KNIME, you can perform functions ranging from basic I/O to data manipulations, transformations and data mining. It consolidates all the functions of the entire process into a single workflow. The solution covers all main data wrangling and machine learning techniques, and is based on visual programming.

    KNIME Features

    KNIME has many valuable key features. Some of the most useful ones include:

    • Scalability through data handling (intelligent automatic caching of data in the background while maximizing throughput performance)
    • High extensibility via a well-defined API for plugin extensions
    • Intuitive user interface
    • Import/export of workflows
    • Parallel execution on multi-core systems
    • Command line version for "headless" batch executions
    • Activity dashboard
    • Reporting & statistics
    • Third-party integrations
    • Workflow management
    • Local automation
    • Metanode linking
    • Tool blending
    • Big Data extensions

    KNIME Benefits

    There are many benefits to implementing KNIME. Some of the biggest advantages the solution offers include:

    • Integrated Deployment: KNIME’s integrated deployment moves both the selected model, and the entire data model preparation process into production simply and automatically, allowing for continuous optimization in production and also saving time because it eliminates error.
    • Elastic and Hybrid Execution: KNIME’s elastic and hybrid executions helps you reduce costs while covering periods of high demand, dynamically.
    • Metadata Mapping: KNIME enables complete metadata mapping of all aspects of your workflow. In addition, KNIME offers blueprint workflows for documenting the nodes, data sources, and libraries used, as well as runtime information.
    • Guided Analytics: KNIME’s guided analytics applications can be customized based on reusable components.
    • Powerful analytics, local automation, and workflow difference: KNIME uses advanced predictive and machine learning algorithms to provide you with the analytics you need. In combination with powerful analytics, KNIME’s automation capabilities and workflow difference prepare your organization with the tools you need to make better business decisions.
    • Supports enterprise-wide data science practices: The deployment and management functionalities of KNIME make it easy to productionize data science applications and services, and deliver usable, reliable, and reproducible insights for the business.
    • Helps you leverage insights gained from your data: Using KNIME ensures the data science process immediately reflects changing requirements or new insights.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the KNIME solution.

    An Emeritus Professor at a university says, “It can read many different file formats. It can very easily tidy up your data, deleting blank rows, and deleting rows where certain columns are missing. It allows you to make lots of changes internally, which you do using JavaScript to put in the conditional. It also has very good fundamental machine learning. It has decision trees, linear regression, and neural nets. It has a lot of text mining facilities as well. It's fairly fully-featured.”

    Benedikt S., CEO at SMH - Schwaiger Management Holding GmbH, explains, “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.”

    Piotr Ś., Test Engineer at ProData Consult, says, “What I like the most is that it works almost out of the box with Random Forest and other Forest nodes.”

    Oracle Advanced Analytics 12c delivers parallelized in-database implementations of data mining algorithms and integration with open source R. Data analysts use Oracle Data Miner GUI and R to build and evaluate predictive models and leverage R packages and graphs. Application developers deploy Oracle Advanced Analytics models using SQL data mining functions and R. With the Oracle Advanced Analytics option, Oracle extends the Oracle Database to an sclable analytical platform that mines more data and data types, eliminates data movement, and preserves security to anticipate customer behavior, detect patterns, and deliver actionable insights. Oracle Big Data SQL adds new big data sources and Oracle R Advanced Analytics for Hadoop provides algorithms that run on Hadoop. 

    Sample Customers
    Infocom Corporation, Dymatrix Consulting Group, Soluzione Informatiche, MMI Agency, Estanislao Training and Solutions, Vialis AG
    Orbitz, Marriott, SGS Life Science, Masdar, AlliantEnergy Corporation, British Standards Institute, Skybox Security, Triple PointTechnology, and Coca Cola.
    Top Industries
    REVIEWERS
    University25%
    Comms Service Provider17%
    Retailer14%
    Government8%
    VISITORS READING REVIEWS
    Manufacturing Company12%
    Financial Services Firm10%
    Computer Software Company9%
    Educational Organization8%
    VISITORS READING REVIEWS
    Government15%
    Manufacturing Company13%
    University13%
    Computer Software Company13%
    Company Size
    REVIEWERS
    Small Business28%
    Midsize Enterprise26%
    Large Enterprise46%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise14%
    Large Enterprise67%
    REVIEWERS
    Small Business67%
    Midsize Enterprise22%
    Large Enterprise11%
    VISITORS READING REVIEWS
    Small Business21%
    Midsize Enterprise12%
    Large Enterprise67%
    Buyer's Guide
    Data Mining
    March 2024
    Find out what your peers are saying about Knime, Weka, IBM and others in Data Mining. Updated: March 2024.
    767,995 professionals have used our research since 2012.

    KNIME is ranked 1st in Data Mining with 50 reviews while Oracle Advanced Analytics is ranked 7th in Data Mining. KNIME is rated 8.2, while Oracle Advanced Analytics is rated 8.0. The top reviewer of KNIME writes "A low-code platform that reduces data mining time by linking script". On the other hand, the top reviewer of Oracle Advanced Analytics writes "Helpful technical support, but performance and queries should be addressed". KNIME is most compared with RapidMiner, Microsoft Power BI, Alteryx, Weka and Dataiku Data Science Studio, whereas Oracle Advanced Analytics is most compared with IBM SPSS Statistics and Weka.

    See our list of best Data Mining vendors.

    We monitor all Data Mining 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.