KNIME vs Oracle Advanced Analytics comparison

Cancel
You must select at least 2 products to compare!
Knime Logo
2,818 views|1,975 comparisons
93% willing to recommend
Oracle Logo
593 views|392 comparisons
55% 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 in this report how the two Data Mining solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed KNIME vs. Oracle Advanced Analytics Report (Updated: May 2024).
772,679 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
"Overall KNIME serves its purpose and does a good job.""Stability is excellent. I would give it a nine out of ten.""The product is very easy to understand even for non-analytical stakeholders. Sometimes we provide them with KNIME workflows and teach them how to run it on their own machine.""Automation is most valuable. It allows me to automatically download information from different sources, and once I create a workflow, I can apply it anytime I want. So, there is efficiency at the same time.""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.""We have found KNIME valuable when it comes to its visualization.""What I like most about KNIME is that it's user-friendly. It's a low-code, no-code tool, so students don't need coding knowledge. You can make use of different kinds of nodes. KNIME even has a good description of each node.""I was able to apply basic algorithms through just dragging and dropping."

More KNIME Pros →

"The dashboard interface is intuitive and the user is able to interact with it to receive good results from the analytic.""Oracle Advanced Analytics effectively prevents threats and helps maintain a secure network environment.""When needed, we will work closely with Oracle support and implement their workaround in our application.""Ability to pull together multiple sources of information."

More Oracle Advanced Analytics Pros →

Cons
"The predefined workflows could use a bit of improvement.""They should look at other vendors like Alteryx that are more user friendly and modern.""KNIME's licensing and data management aren't as straightforward relative to Alteryx. Alteryx's tools are more sophisticated, so you need fewer to use it compared to KNIME. I think tab implementation could be easier, too.""The program is not fit for handling very large files or databases (greater than 1GB); it gets too slow and has a tendency to crash easily.""Though I can use KNIME in a 64-bit platform in the lab, it's missing some features. For example, from my laptop, I can use the image reader feature of KNIME. However, in the lab, the image reader node is missing.""I would like it to have data visualitation capabilities. Today I'm still creating my own data visualtions tools to present my reports.""Not just for KNIME, but generally for software and analyzing data, I would welcome facilities for analyzing different sorts of scale data like Likert scales, Thurstone scales, magnitude ratio scales, and Guttman scales, which I don't use myself.""One thing to consider is that the prebuilt nodes may not always be a perfect fit for your specific needs, although most of the time, they work quite well."

More KNIME Cons →

"Could use some refinement getting things that are not standard cloud applications, but more customized.""One area for product improvement is the user experience, particularly when navigating through screens.""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.
    772,679 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
    2,818
    Comparisons
    1,975
    Reviews
    20
    Average Words per Review
    506
    Rating
    7.9
    6th
    out of 18 in Data Mining
    Views
    593
    Comparisons
    392
    Reviews
    1
    Average Words per Review
    322
    Rating
    9.0
    Comparisons
    RapidMiner logo
    Compared 27% of the time.
    Microsoft Power BI logo
    Compared 20% of the time.
    Alteryx logo
    Compared 13% of the time.
    Dataiku logo
    Compared 8% of the time.
    Weka logo
    Compared 7% of the time.
    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 Firm11%
    Computer Software Company9%
    Educational Organization8%
    VISITORS READING REVIEWS
    Government15%
    Manufacturing Company13%
    University13%
    Computer Software Company12%
    Company Size
    REVIEWERS
    Small Business28%
    Midsize Enterprise26%
    Large Enterprise47%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise14%
    Large Enterprise67%
    REVIEWERS
    Small Business70%
    Midsize Enterprise20%
    Large Enterprise10%
    VISITORS READING REVIEWS
    Small Business21%
    Midsize Enterprise11%
    Large Enterprise68%
    Buyer's Guide
    KNIME vs. Oracle Advanced Analytics
    May 2024
    Find out what your peers are saying about KNIME vs. Oracle Advanced Analytics and other solutions. Updated: May 2024.
    772,679 professionals have used our research since 2012.

    KNIME is ranked 1st in Data Mining with 50 reviews while Oracle Advanced Analytics is ranked 6th in Data Mining with 9 reviews. KNIME is rated 8.2, while Oracle Advanced Analytics is rated 8.2. 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, Dataiku and Weka, whereas Oracle Advanced Analytics is most compared with IBM SPSS Statistics and Weka. See our KNIME vs. Oracle Advanced Analytics report.

    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.