Jaspersoft Community Edition vs. SingleStore

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Jaspersoft Community Edition
Score 9.7 out of 10
N/A
Jaspersoft Community Edition is a free product that offers embeddable pixel-perfect reports for Java apps and small workgroups.
$0
per month
SingleStore
Score 7.8 out of 10
N/A
SingleStore aims to enable organizations to scale from one to one million customers, handling SQL, JSON, full text and vector workloads in one unified platform.
$0.69
per hour
Pricing
Jaspersoft Community EditionSingleStore
Editions & Modules
No answers on this topic
OnDemand
$0.69
per hour
Offerings
Pricing Offerings
Jaspersoft Community EditionSingleStore
Free Trial
NoYes
Free/Freemium Version
YesYes
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeOptional
Additional Details
More Pricing Information
Community Pulse
Jaspersoft Community EditionSingleStore
Features
Jaspersoft Community EditionSingleStore
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Jaspersoft Community Edition
9.3
28 Ratings
13% above category average
SingleStore
-
Ratings
Pixel Perfect reports9.024 Ratings00 Ratings
Customizable dashboards9.023 Ratings00 Ratings
Report Formatting Templates10.023 Ratings00 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Jaspersoft Community Edition
9.3
26 Ratings
15% above category average
SingleStore
-
Ratings
Drill-down analysis9.025 Ratings00 Ratings
Formatting capabilities10.025 Ratings00 Ratings
Integration with R or other statistical packages9.02 Ratings00 Ratings
Report sharing and collaboration9.023 Ratings00 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Jaspersoft Community Edition
9.4
27 Ratings
13% above category average
SingleStore
-
Ratings
Publish to Web10.022 Ratings00 Ratings
Publish to PDF9.027 Ratings00 Ratings
Report Versioning9.017 Ratings00 Ratings
Report Delivery Scheduling10.024 Ratings00 Ratings
Delivery to Remote Servers9.016 Ratings00 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Jaspersoft Community Edition
9.3
21 Ratings
15% above category average
SingleStore
-
Ratings
Pre-built visualization formats (heatmaps, scatter plots etc.)9.021 Ratings00 Ratings
Location Analytics / Geographic Visualization10.018 Ratings00 Ratings
Predictive Analytics9.02 Ratings00 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Jaspersoft Community Edition
9.3
26 Ratings
9% above category average
SingleStore
-
Ratings
Multi-User Support (named login)9.024 Ratings00 Ratings
Role-Based Security Model10.025 Ratings00 Ratings
Multiple Access Permission Levels (Create, Read, Delete)9.026 Ratings00 Ratings
Single Sign-On (SSO)9.017 Ratings00 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Jaspersoft Community Edition
9.3
21 Ratings
18% above category average
SingleStore
-
Ratings
Responsive Design for Web Access10.019 Ratings00 Ratings
Mobile Application9.010 Ratings00 Ratings
Dashboard / Report / Visualization Interactivity on Mobile9.016 Ratings00 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
Jaspersoft Community Edition
9.5
23 Ratings
21% above category average
SingleStore
-
Ratings
REST API10.018 Ratings00 Ratings
Javascript API9.019 Ratings00 Ratings
iFrames10.016 Ratings00 Ratings
Java API9.014 Ratings00 Ratings
Themeable User Interface (UI)10.014 Ratings00 Ratings
Customizable Platform (Open Source)9.013 Ratings00 Ratings
Relational Databases
Comparison of Relational Databases features of Product A and Product B
Jaspersoft Community Edition
-
Ratings
SingleStore
6.9
3 Ratings
14% below category average
ACID compliance00 Ratings5.93 Ratings
Database monitoring00 Ratings7.43 Ratings
Database locking00 Ratings6.63 Ratings
Encryption00 Ratings7.43 Ratings
Disaster recovery00 Ratings5.93 Ratings
Flexible deployment00 Ratings7.73 Ratings
Multiple datatypes00 Ratings7.43 Ratings
Best Alternatives
Jaspersoft Community EditionSingleStore
Small Businesses
Yellowfin
Yellowfin
Score 8.7 out of 10
InterSystems IRIS
InterSystems IRIS
Score 8.0 out of 10
Medium-sized Companies
Reveal
Reveal
Score 10.0 out of 10
InterSystems IRIS
InterSystems IRIS
Score 8.0 out of 10
Enterprises
Kyvos Semantic Layer
Kyvos Semantic Layer
Score 9.5 out of 10
SAP IQ
SAP IQ
Score 10.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Jaspersoft Community EditionSingleStore
Likelihood to Recommend
10.0
(29 ratings)
7.7
(73 ratings)
Likelihood to Renew
5.8
(5 ratings)
8.2
(5 ratings)
Usability
9.0
(5 ratings)
8.2
(8 ratings)
Availability
-
(0 ratings)
9.1
(2 ratings)
Performance
-
(0 ratings)
8.3
(47 ratings)
Support Rating
10.0
(8 ratings)
8.3
(9 ratings)
Online Training
4.0
(1 ratings)
7.3
(1 ratings)
Implementation Rating
6.1
(6 ratings)
7.3
(2 ratings)
Ease of integration
-
(0 ratings)
9.1
(1 ratings)
Product Scalability
-
(0 ratings)
8.2
(2 ratings)
Vendor post-sale
-
(0 ratings)
8.2
(2 ratings)
Vendor pre-sale
-
(0 ratings)
8.2
(2 ratings)
User Testimonials
Jaspersoft Community EditionSingleStore
Likelihood to Recommend
Jaspersoft
Any scenario where you need to reach back into TIBCO support is something I would highly avoid. Most responses at the second round get you pointed to engaging their professional services. The general mentality seems to be "since our product acquisition cost is low, why don't you engage PS to get the value you need" If you are looking at enterprise scenarios, I would highly recommend looking at other more established products.
Read full review
SingleStore
Good for Applications needing instant insights on large, streaming datasets. Applications processing continuous data streams with low latency. When a multi-cloud, high-availability database is required When NOT to Use Small-scale applications with limited budgets Projects that do not require real-time analytics or distributed scaling Teams without experience in distributed databases and HTAP architectures.
Read full review
Pros
Jaspersoft
  • Very intuitive tool - An Advanced reporting user can figure out in a day on the end to end operations.
  • Easy customization - Simple changes in UI makes it less headache for the end user who maintains the tool. Being an open source product (offers Jasper web services) makes a lot developer friendly compared to SSRS, Cognos etc.
  • Easy Connectivity - Can connect to any data source (can connect to multiple data sources) for a single report - can be customized.
  • Community - A very strong community available online, videos - on basic how to questions, also provides assistance to use case specific scenarios.
  • Ease of Reporting - Can create a reports with in few clicks with out struggle.
  • Domain Designer - A very powerful tool you can create a dataset using clicks with out writing SQL code.
  • OnDemand Scheduling - A very good scheduling feature and a has got lot more simplistic compared to other popular tools like Cognos.
  • Jasper Studio - Very good programmatic tool (desktop tool) lets you customize the reports more company specific, can embed complex coding with 3rd party languages like Java, Groovy (scripting language).
Read full review
SingleStore
  • Technical support is stellar -- far above and beyond anything I've experienced with any other company.
  • When we compared SingleStore to other databases two years ago, we found SingleStore performance to be far superior.
  • Pipeline data ingestion is exceptionally fast.
  • The ability to combine transactional and analytical workloads without compromising performance is very impressive.
Read full review
Cons
Jaspersoft
  • Easier to customize the Jasper Server GUI. More flexibility with the input controls look and feel and maybe more input control types to select from.
  • Have browser event functionality in the reporting itself.
  • An easier way to iterate through an object. Maybe an option that tells the report Java run-time to stop following the report sequential flow and first integrate through this stated object many times.
  • An easier way to create a list and add values to this list.
  • Maybe one could stipulate the process flow of what needs to be computed first in a given field.
  • The crosstab is a bit buggy on the Jasper studio side, so if that could be improved.
  • Better and more examples of custom components
  • The jive functionality on the tables needs an update. It looks so old and outdated.
Read full review
SingleStore
  • It does not release a patch to have back porting; it just releases a new version and stops support; it's difficult to keep up to that pace.
  • Support engineers lack expertise, but they seem to be improving organically.
  • Lacks enterprise CDC capability: Change data capture (CDC) is a process that tracks and records changes made to data in a database and then delivers those changes to other systems in real time.
  • For enterprise-level backup & restore capability, we had to implement our model via Velero snapshot backup.
Read full review
Likelihood to Renew
Jaspersoft
Even though there are challenges with Architecture, sizing and other areas with Jaspersoft provided that Jaspersoft comes up with the right set of innovation, performance, scalability, and documentation in future it will be great expansion (win-win) situation for the clients and as well as Jaspersoft.
Read full review
SingleStore
We haven't seen a faster relation database. Period. Which is why we are super happy customers and will for sure renew our license.
Read full review
Usability
Jaspersoft
The overall performance of this platform has been excellent. It is easy to work with the user interface. Creation of digital content and publishing on our social media platforms during marketing has been easy. Running our applications and upgrading our system to meet international standards has been successful. The user dashboard displays reports and performance of all departments effectively.
Read full review
SingleStore
[Until it is] supported on AWS ECS containers, I will reserve a higher rating for SingleStore. Right now it works well on EC2 and serves our current purpose, [but] would look forward to seeing SingleStore respond to our urge of feature in a shorter time period with high quality and security.
Read full review
Reliability and Availability
Jaspersoft
No answers on this topic
SingleStore
Solutions are based around a business needs and even when implementing such solution, real time insights are also followed through showing the updates the business are implementing while informing the end users as what is new with technology.
Read full review
Performance
Jaspersoft
No answers on this topic
SingleStore
SingleStore excels in real-time analytics and low-latency transactions, making it ideal for operational analytics and mixed workloads. Snowflake shines in batch analytics and data warehousing with strong scalability for large datasets. SingleStore offers faster data ingestion and query execution for real-time use cases, while Snowflake is better for complex analytical queries on historical data.
Read full review
Support Rating
Jaspersoft
We have only had a couple of tickets to be open while using Jaspersoft. Each time we have a very prompte responses that would meet our expectations. We always felt that our issues were being address in a timely manner
Read full review
SingleStore
The support deep dives into our most complexed queries and bizarre issues that sometimes only we get comparing to other clients. Our special workload (thousands of Kafka pipelines + high concurrency of queries). The response match to the priority of the request, P1 gets immediate return call. Missing features are treated, they become a client request and being added to the roadmap after internal consideration on all client needs and priority. Bugs are patched quite fast, depends on the impact and feasible temporary workarounds. There is no issue that we haven't got a proper answer, resolution or reasoning
Read full review
Online Training
Jaspersoft
While the training was somewhat beneficial, a lot of what was taught to us was what we managed to figure out in the weeks prior. It did provide some useful tips and reference material, but overall something more tailored to our requirements would've been better.
Read full review
SingleStore
Would prefer in person training but for online training, it's almost as good as in person
Read full review
Implementation Rating
Jaspersoft
New releases can be very buggy, also lacking when it comes to standard time zones and formats that are outside the US. As a company we never feel comfortable implementing a new release for at least 3-6 months due to errors that are found
Read full review
SingleStore
We allowed 2-3 months for a thorough evaluation. We saw pretty quickly that we were likely to pick SingleStore, so we ported some of our stored procedures to SingleStore in order to take a deeper look. Two SingleStore people worked closely with us to ensure that we did not have any blocking problems. It all went remarkably smoothly.
Read full review
Alternatives Considered
Jaspersoft
Crystal reports is very expensive and does not integrate well with java based servers. Jasper also provides community edition, if we every want to downgrade the use, we always have the option of eliminating the server and using the reports as they are. Jasper also give you the opportunity to build BI on case by base basis including Dashboards.
Read full review
SingleStore
Greenplum is good in handling very large amount of data. Concurrency in Greenplum was a major problem. Features available in SingleStore like Pipelines and in memory features are not available in Greenplum. Gemfire was not scaling well like SingleStore. Support of both Greenplum and Gemfire was not good. Product team did not help us much like the ones in SingleStore who helped us getting started on our first cluster very fast.
Read full review
Scalability
Jaspersoft
No answers on this topic
SingleStore
Very reliable. Coming from mariadb, singlestore has made our application more reliable and faster!
Read full review
Return on Investment
Jaspersoft
  • Jaspersoft Community Edition has not had any significant impact on our ROI as we have purchased the commercial edition of the product.
  • The only impact on ROI is that when we bring on new developers, he or she can begin work using the community edition while awaiting the installation of the commercial edition.
Read full review
SingleStore
  • As the overall performance and functionality were expanded, we are able to deliver our data much faster than before, which increases the demand for data.
  • Metadata is available in the platform by default, like metadata on the pipelines. Also, the information schema has lots of metadata, making it easy to load our assets to the data catalog.
Read full review
ScreenShots