KNIME Analytics Platform vs. SAP Crystal

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
KNIME Analytics Platform
Score 7.9 out of 10
N/A
KNIME enables users to analyze, upskill, and scale data science without any coding. The platform that lets users blend, transform, model and visualize data, deploy and monitor analytical models, and share insights organization-wide with data apps and services.
$0
per month
SAP Crystal
Score 7.4 out of 10
N/A
SAP Crystal is an analytics and reporting software solution for SMBs. SAP Crystal comprises Crystal Reports for pixel-perfect reporting, and SAP Crystal Server for automated distribution and self-service access to reports, dashboards and data exploration.
$295
per single user license
Pricing
KNIME Analytics PlatformSAP Crystal
Editions & Modules
KNIME Community Hub Personal Plan
$0
KNIME Analytics Platform
$0
KNIME Community Hub Team Plan
€99
per month 3 users
KNIME Business Hub
From €35,000
per year
Upgrade Version to SAP Crystal Reports 2020
$295
per single user license
SAP Crystal Reports 2020 64-Bit
$495
per single user license
SAP Crystal Reports 2016 32-Bit
$495
per single user license
SAP Crystal Server 2020 1 NUL
$869
per user license + first year maintenance to be added
SAP Crystal Server 2020 5 CAL
$8,744
5 concurrent users + first year maintenance to be added
Offerings
Pricing Offerings
KNIME Analytics PlatformSAP Crystal
Free Trial
NoYes
Free/Freemium Version
YesYes
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeOptional
Additional Details* SAP Crystal Reports 2020 Viewer allows you to view static data within a SAP Crystal Reports file. * SAP Crystal Reports 2020 - Full version allows you to create powerful, richly formatted, and dynamic reports from virtually any data source, delivered in dozens of formats, in up to 28 languages. If you already have an older version of Crystal Reports, buy a license for SAP Crystal Reports 2020 - Upgrade at a discounted, upgrade price. * SAP Crystal Server 2020, 1 NUL includes 1 license of: SAP Crystal Reports 2020 - SAP Crystal Server 2020. * As an add-on to SAP Crystal Server 2020 1 NUL, SAP Crystal Server 2020 5 CAL allows you to support a wider, intermittent audience of end users, up to five logged on at the same time.
More Pricing Information
Community Pulse
KNIME Analytics PlatformSAP Crystal
Features
KNIME Analytics PlatformSAP Crystal
Platform Connectivity
Comparison of Platform Connectivity features of Product A and Product B
KNIME Analytics Platform
9.2
19 Ratings
10% above category average
SAP Crystal
-
Ratings
Connect to Multiple Data Sources9.619 Ratings00 Ratings
Extend Existing Data Sources10.010 Ratings00 Ratings
Automatic Data Format Detection9.119 Ratings00 Ratings
MDM Integration7.98 Ratings00 Ratings
Data Exploration
Comparison of Data Exploration features of Product A and Product B
KNIME Analytics Platform
8.1
18 Ratings
4% below category average
SAP Crystal
-
Ratings
Visualization8.018 Ratings00 Ratings
Interactive Data Analysis8.118 Ratings00 Ratings
Data Preparation
Comparison of Data Preparation features of Product A and Product B
KNIME Analytics Platform
8.3
19 Ratings
2% above category average
SAP Crystal
-
Ratings
Interactive Data Cleaning and Enrichment9.019 Ratings00 Ratings
Data Transformations9.519 Ratings00 Ratings
Data Encryption7.47 Ratings00 Ratings
Built-in Processors7.48 Ratings00 Ratings
Platform Data Modeling
Comparison of Platform Data Modeling features of Product A and Product B
KNIME Analytics Platform
8.0
18 Ratings
4% below category average
SAP Crystal
-
Ratings
Multiple Model Development Languages and Tools9.517 Ratings00 Ratings
Automated Machine Learning8.217 Ratings00 Ratings
Single platform for multiple model development9.318 Ratings00 Ratings
Self-Service Model Delivery5.08 Ratings00 Ratings
Model Deployment
Comparison of Model Deployment features of Product A and Product B
KNIME Analytics Platform
7.3
11 Ratings
15% below category average
SAP Crystal
-
Ratings
Flexible Model Publishing Options8.611 Ratings00 Ratings
Security, Governance, and Cost Controls5.94 Ratings00 Ratings
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
KNIME Analytics Platform
-
Ratings
SAP Crystal
7.8
124 Ratings
5% below category average
Pixel Perfect reports00 Ratings8.0113 Ratings
Customizable dashboards00 Ratings7.1100 Ratings
Report Formatting Templates00 Ratings8.4117 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
KNIME Analytics Platform
-
Ratings
SAP Crystal
8.4
136 Ratings
4% above category average
Drill-down analysis00 Ratings9.0117 Ratings
Formatting capabilities00 Ratings8.7135 Ratings
Integration with R or other statistical packages00 Ratings7.064 Ratings
Report sharing and collaboration00 Ratings8.7120 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
KNIME Analytics Platform
-
Ratings
SAP Crystal
8.8
136 Ratings
7% above category average
Publish to Web00 Ratings9.091 Ratings
Publish to PDF00 Ratings9.4133 Ratings
Report Versioning00 Ratings8.094 Ratings
Report Delivery Scheduling00 Ratings9.097 Ratings
Delivery to Remote Servers00 Ratings8.654 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
KNIME Analytics Platform
-
Ratings
SAP Crystal
7.6
89 Ratings
5% below category average
Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings7.650 Ratings
Location Analytics / Geographic Visualization00 Ratings7.576 Ratings
Predictive Analytics00 Ratings7.841 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
KNIME Analytics Platform
-
Ratings
SAP Crystal
8.6
88 Ratings
1% above category average
Multi-User Support (named login)00 Ratings8.581 Ratings
Role-Based Security Model00 Ratings8.580 Ratings
Multiple Access Permission Levels (Create, Read, Delete)00 Ratings8.580 Ratings
Report-Level Access Control00 Ratings8.63 Ratings
Single Sign-On (SSO)00 Ratings9.040 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
KNIME Analytics Platform
-
Ratings
SAP Crystal
6.7
65 Ratings
15% below category average
Responsive Design for Web Access00 Ratings6.363 Ratings
Mobile Application00 Ratings6.046 Ratings
Dashboard / Report / Visualization Interactivity on Mobile00 Ratings6.360 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
KNIME Analytics Platform
-
Ratings
SAP Crystal
7.8
45 Ratings
1% above category average
REST API00 Ratings7.48 Ratings
Javascript API00 Ratings8.437 Ratings
iFrames00 Ratings7.18 Ratings
Java API00 Ratings8.437 Ratings
Themeable User Interface (UI)00 Ratings7.539 Ratings
Customizable Platform (Open Source)00 Ratings8.433 Ratings
Best Alternatives
KNIME Analytics PlatformSAP Crystal
Small Businesses
Jupyter Notebook
Jupyter Notebook
Score 8.6 out of 10
Yellowfin
Yellowfin
Score 8.7 out of 10
Medium-sized Companies
Posit
Posit
Score 10.0 out of 10
Reveal
Reveal
Score 10.0 out of 10
Enterprises
Posit
Posit
Score 10.0 out of 10
Kyvos Semantic Layer
Kyvos Semantic Layer
Score 9.5 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
KNIME Analytics PlatformSAP Crystal
Likelihood to Recommend
9.6
(22 ratings)
7.1
(159 ratings)
Likelihood to Renew
9.5
(4 ratings)
10.0
(19 ratings)
Usability
9.0
(3 ratings)
7.3
(31 ratings)
Availability
-
(0 ratings)
8.0
(1 ratings)
Performance
-
(0 ratings)
8.0
(1 ratings)
Support Rating
9.3
(6 ratings)
8.6
(21 ratings)
In-Person Training
-
(0 ratings)
10.0
(1 ratings)
Implementation Rating
7.0
(2 ratings)
8.8
(14 ratings)
Configurability
-
(0 ratings)
8.0
(1 ratings)
Ease of integration
10.0
(1 ratings)
7.0
(1 ratings)
Product Scalability
-
(0 ratings)
7.0
(1 ratings)
Vendor post-sale
-
(0 ratings)
8.0
(1 ratings)
Vendor pre-sale
-
(0 ratings)
7.0
(1 ratings)
User Testimonials
KNIME Analytics PlatformSAP Crystal
Likelihood to Recommend
KNIME
KNIME Analytics Platform is excellent for people who are finding Excel frustrating, this can be due to errors creeping in due to manual changes or simply that there are too many calculations which causes the system to slow down and crash. This is especially true for regular reporting where a KNIME Analytics Platform workflow can pull in the most recent data, process it and provide the necessary output in one click. I find KNIME Analytics Platform especially useful when talking with audiences who are intimidated by code. KNIME Analytics Platform allows us to discuss exactly how data is processed and an analysis takes place at an abstracted level where non-technical users are happy to think and communicate which is often essential when they are subject matter experts whom you need for guidance. For experienced programmers KNIME Analytics Platform is a double-edged sword. Often programmers wish to write their own code because they are more efficient working that way and are constrained by having to think and implement work in nodes. However, those constraints forcing development in a "KNIME way" are useful when working in teams and for maintenance compared to some programmers' idiosyncratic styles.
Read full review
SAP
Generation of templated reports is the strong suit of SAP Crystal. Allows users to change formats in templates bases on requirement with minimal effort. Automated report delivery requires the user to be aware of sql which cannot be expected from all users. Should support more document export formats and improve the UI for SAP B1 Users
Read full review
Pros
KNIME
  • Summarize instrument level financial data with relevant statistics
  • Map transactions from core extracts to groups of like transactions using rule engines
  • Machine learning using random forests and other techniques to analyze data and identify correlations for use in predictive models
  • Fill out sampling data from averages.
Read full review
SAP
  • Crystal Reports allows us to create a consistent template for all of our reports.
  • Crystal Reports and Server allows us to house a repository for all of our reports to make them easy to find and update when necessary.
  • Crystal Reports can connect to a wide variety of data sources.
  • Crystal Reports can be a little daunting when first implementing. There are a lot of nuances in learning how to truly master this software and it can be frustrating at times.
Read full review
Cons
KNIME
  • It does not have proper visualization.
  • Some other BI tools (QlikView) have much easier functions for data interaction.
  • Some other BI tools (Tableau) can be set up much faster.
  • It is not an easy tool to use for non-tech savvy staff.
Read full review
SAP
  • The export of reports to Excel is very cumbersome and the results are difficult to format.
  • The design of reports and the graphical features (e.g. charts) feel quite rigid.
  • The learning curve for a non-programmer is incredibly steep, making Crystal a specialty tool.
Read full review
Likelihood to Renew
KNIME
We are happy with Knime product and their support. Knime AP is versatile product and even can execute Python scripts if needed. It also supports R execution as well; however, it is not being used at our end
Read full review
SAP
We have been using this product for so many years and it has truly become a cornerstone to our business processes when it comes to developing and distributing information via reports. We currently have over 500 reports developed to date over about 30 systems and that will continue to grow as user needs change.
Read full review
Usability
KNIME
KNIME Analytics Platform offers a great tradeoff between intuitiveness and simplicity of the user interface and almost limitless flexibility. There are tools that are even easier to adopt by someone new to analytics, but none that would provide the scalability of KNIME when the user skills and application complexity grows
Read full review
SAP
Crystal is very robust, but not always easy to use. It create wonderful looking reports, and so deserves a high rating. However, I have to take a couple of points off for the simple fact that I cannot hand it to a user and expect them to be able to do development with it.
Read full review
Support Rating
KNIME
KNIME's HQ is in Europe, which makes it hard for US companies to get customer service in time and on time. Their customer service also takes on average 1 to 2 weeks to follow up with your request. KNIME's documentation is also helpful but it does not provide you all the answers you need some of the time.
Read full review
SAP
The support community can be difficult to navigate. I've also run into issues with my login. The SAP system has a bizarre mechanism for validating users that requires users to have what is called an S-ID. A basic ID may not give you access to all the features in the portal. The limitation may include not being able to perform a simple task like downloading patches and updates. This isn't a big deal for single user license but for teams it can be a pain.
Read full review
In-Person Training
KNIME
No answers on this topic
SAP
Trainer was patient and thorough in going through the basics and willing to answer questions by email after the initial training
Read full review
Implementation Rating
KNIME
KNIME Analytics Platform is easy to install on any Windows, Mac or Linux machine. The KNIME Server product that is currently being replaced by the KNIME Business Hub comes as multiple layers of software and it took us some time to set up the system right for stability. This was made harder by KNIME staff's deeper expertise in setting up the Server in Linux rather than Windows environment. The KNIME Business Hub promises to have a simpler architecture, although currently there is no visibility of a Windows version of the product.
Read full review
SAP
Just like any other implementation: When designing the differing reports, get end users' input, make sure to design the reports so that they display the information that the company requires, in the best and clearest way possible.
Test, test, test, revise when needed, and, particularly, do sufficient training so users are comfortable using Crystal Reports!
Read full review
Alternatives Considered
KNIME
Having used both the Alteryx and [KNIME Analytics] I can definitely feel the ease of using the software of Alteryx. The [KNIME Analytics] on the other hand isn't that great but is 90% of what Alteryx can do along with how much ease it can do. Having said that, the 90% functionality and UI at no cost would be enough for me to quit using Alteryx and move towards [KNIME Analytics].
Read full review
SAP
Crystal reports is useful in case we want to import data from data base . We can write queries in it but Google Charts require to be implemented in our application using code so crystal reports is better than Google Charts.
Read full review
Return on Investment
KNIME
  • It is suited for data mining or machine learning work but If we're looking for advanced stat methods such as mixed effects linear/logistics models, that needs to be run through an R node.
  • Thinking of our peers with an advanced visualization techniques requirement, it is a lagging product.
Read full review
SAP
  • It is a decent buy for specific departments in terms of reporting capabilities but updates and cost (frequent) demands are higher with the benefits offered.
  • So long as the requirements are not ever changing, with scheduling functionality, it's a handsome tool.
Read full review
ScreenShots

KNIME Analytics Platform Screenshots

Screenshot of the KNIME Modern UI. This is the the new user interface for the KNIME Analytics Platform that is available with improved look and feel as the default interface, from KNIME Analytics Platform version 5.1.0 release.Screenshot of the KNIME Analytics Platform user interface - the KNIME Workbench - displays the current, open workflow(s). Here is the general user interface layout — application tabs, side panel, workflow editor and node monitor.Screenshot of the KNIME user interface elements — workflow toolbar, node action bar, rename components and metanodes.Screenshot of the entry page, which is displayed by clicking the Home tab. From here users can; check out example workflows to get started, access a local workspace, or even start a new workflow by clicking the yellow plus button.Screenshot of the status of a KNIME node, which shows whether it's configured, not configured, executed, or has an error.Screenshot of the KNIME node action bar, which can be used to configure, execute, cancel, reset, and - when available - open the view.

SAP Crystal Screenshots

Screenshot of Pixel-perfect reporting solutionScreenshot of Refresh with a clickScreenshot of Build pixel-perfect documentsScreenshot of Connect to all data sourcesScreenshot of Use drag and dropScreenshot of Build interactive reports