TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Db2

    Score8.6 out of 10
    N/ADB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.

    $0

    Jaspersoft

    Score6 out of 10
    N/AJaspersoft commercial edition is an embedded business intelligence suite designed to be built-into SaaS products as an integrated reporting engine. It provides reports and dashboards for customer-facing applications without requiring app developers to build their own reporting engine.N/A
    Pricing
    Db2Jaspersoft
    Editions & Modules
    Db2 on Cloud Lite
    $0
    Db2 on Cloud Standard
    $99
    per month
    Db2 Warehouse on Cloud Flex One
    $898
    per month
    Db2 on Cloud Enterprise
    $946
    per month
    Db2 Warehouse on Cloud Flex for AWS
    2,957
    per month
    Db2 Warehouse on Cloud Flex
    $3,451
    per month
    Db2 Warehouse on Cloud Flex Performance
    13,651
    per month
    Db2 Warehouse on Cloud Flex Performance for AWS
    13,651
    per month
    Db2 Standard Edition
    Contact Sales
    Db2 Advanced Edition
    Contact Sales
    No answers on this topic
    Offerings
    Pricing Offerings
    Db2Jaspersoft
    Free Trial
    YesYes
    Free/Freemium Version
    YesYes
    Premium Consulting/Integration Services
    YesYes
    Entry-level Setup FeeOptionalNo setup fee
    Additional Details—Jaspersoft offers flexible pricing for ISVs and SaaS per customer or by CPU core.
    More Pricing Information
    Community Pulse
    Db2Jaspersoft
    Considered Both Products
    IBM
    No answer on this topic
    Cloud Software Group
    No answer on this topic
    Key User Insights
    Would buy again
    96%
    Would buy again
    103 Answers
    71%
    Would buy again
    5 Answers
    Delivers good value for the price
    97%
    Delivers good value for the price
    95 Answers
    100%
    Delivers good value for the price
    6 Answers
    Happy with the feature set
    96%
    Happy with the feature set
    103 Answers
    100%
    Happy with the feature set
    7 Answers
    Lived up to sales and marketing promises
    96%
    Lived up to sales and marketing promises
    66 Answers
    100%
    Lived up to sales and marketing promises
    5 Answers
    Implementation went as expected
    99%
    Implementation went as expected
    89 Answers
    83%
    Implementation went as expected
    5 Answers
    Features
    Db2Jaspersoft
    BI Standard Reporting
    Comparison of BI Standard Reporting features of Db2 and Jaspersoft
    Feature
    Db2
    -
    Ratings
    Jaspersoft
    7.6
    100 Ratings
    7% below category average
    Pixel Perfect reports00 Ratings7.687 Ratings
    Customizable dashboards00 Ratings7.588 Ratings
    Report Formatting Templates00 Ratings7.886 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of Db2 and Jaspersoft
    Feature
    Db2
    -
    Ratings
    Jaspersoft
    7.4
    98 Ratings
    8% below category average
    Drill-down analysis00 Ratings7.289 Ratings
    Formatting capabilities00 Ratings7.397 Ratings
    Report sharing and collaboration00 Ratings7.781 Ratings
    Report Output and Scheduling
    Comparison of Report Output and Scheduling features of Db2 and Jaspersoft
    Feature
    Db2
    -
    Ratings
    Jaspersoft
    7.7
    101 Ratings
    6% below category average
    Publish to Web00 Ratings7.176 Ratings
    Publish to PDF00 Ratings8.799 Ratings
    Report Versioning00 Ratings7.759 Ratings
    Report Delivery Scheduling00 Ratings7.582 Ratings
    Delivery to Remote Servers00 Ratings7.562 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of Db2 and Jaspersoft
    Feature
    Db2
    -
    Ratings
    Jaspersoft
    7.7
    72 Ratings
    4% below category average
    Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings8.472 Ratings
    Location Analytics / Geographic Visualization00 Ratings7.153 Ratings
    Access Control and Security
    Comparison of Access Control and Security features of Db2 and Jaspersoft
    Feature
    Db2
    -
    Ratings
    Jaspersoft
    8.1
    98 Ratings
    5% below category average
    Multi-User Support (named login)00 Ratings8.194 Ratings
    Role-Based Security Model00 Ratings8.192 Ratings
    Multiple Access Permission Levels (Create, Read, Delete)00 Ratings8.588 Ratings
    Single Sign-On (SSO)00 Ratings7.773 Ratings
    Mobile Capabilities
    Comparison of Mobile Capabilities features of Db2 and Jaspersoft
    Feature
    Db2
    -
    Ratings
    Jaspersoft
    6.6
    64 Ratings
    16% below category average
    Responsive Design for Web Access00 Ratings7.959 Ratings
    Mobile Application00 Ratings5.528 Ratings
    Dashboard / Report / Visualization Interactivity on Mobile00 Ratings8.141 Ratings
    Application Program Interfaces (APIs) / Embedding
    Comparison of Application Program Interfaces (APIs) / Embedding features of Db2 and Jaspersoft
    Feature
    Db2
    -
    Ratings
    Jaspersoft
    7.6
    90 Ratings
    2% below category average
    REST API00 Ratings7.981 Ratings
    Javascript API00 Ratings8.062 Ratings
    iFrames00 Ratings7.754 Ratings
    Java API00 Ratings8.155 Ratings
    Themeable User Interface (UI)00 Ratings6.558 Ratings
    Customizable Platform (Open Source)00 Ratings7.760 Ratings
    Best Alternatives
    Db2Jaspersoft
    Small Businesses
    Amazon RDS
    Score8.1 out of 10
    Cyfe
    Score4 out of 10
    Medium-sized Companies
    SingleStore
    Score8.2 out of 10
    Qlik Cloud Analytics (Qlik Sense)
    Score8.1 out of 10
    Enterprises
    SAP IQ
    Score5.4 out of 10
    Sisense
    Score6.9 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Db2Jaspersoft
    Likelihood to Recommend
    9.1
    (114 ratings)
    7.3
    (119 ratings)
    Likelihood to Renew
    7.9
    (12 ratings)
    8.0
    (23 ratings)
    Usability
    8.5
    (9 ratings)
    7.9
    (16 ratings)
    Availability
    9.3
    (64 ratings)
    8.0
    (3 ratings)
    Performance
    9.1
    (12 ratings)
    7.0
    (3 ratings)
    Support Rating
    8.9
    (6 ratings)
    7.0
    (26 ratings)
    In-Person Training
    8.2
    (1 ratings)
    8.0
    (4 ratings)
    Online Training
    -
    (0 ratings)
    6.5
    (7 ratings)
    Implementation Rating
    5.6
    (3 ratings)
    7.8
    (15 ratings)
    Configurability
    9.1
    (2 ratings)
    7.0
    (2 ratings)
    Data Sharing and Collaboration
    8.0
    (1 ratings)
    8.0
    (1 ratings)
    Data Sources
    9.0
    (1 ratings)
    8.0
    (1 ratings)
    Ease of integration
    7.8
    (4 ratings)
    7.0
    (2 ratings)
    Product Scalability
    8.3
    (66 ratings)
    8.0
    (3 ratings)
    Vendor post-sale
    9.0
    (2 ratings)
    8.0
    (2 ratings)
    Vendor pre-sale
    9.0
    (2 ratings)
    8.0
    (2 ratings)
    User Testimonials
    Db2Jaspersoft
    Likelihood to Recommend
    IBM
    I have primarily used it as the basis for a SIS - but I have migrated more than a few systems from there database systems to DB2 (Filemaker, MySQL, etc.). DB2 does have a better structural approach, as opposed to Filemaker, which allows for more data consistency, but this can also lead to an inflexibility that can sometimes be counterintuitive when attempting to compensate for the flexibility of the work environment as Schools tend to have an all in one approach.
    Incentivized
    Read full review
    Cloud Software Group
    It is well suited for the fact of scalability itself and the breadth of features this application has in order to make the migration from legacy systems to the newer different versions more seamless and effective. Data integrity and security are the main aspects of this tool which does not lose their value when doing day-to-day operations for data mapping.
    Incentivized
    Read full review
    Pros
    IBM
    • While we query a large set of data, the results are generally available within a minute or so.
    • Always reliable - I have never experienced an application going down.
    • It is easy to write queries and find tables and columns.
    • We can log in smoothly without any headaches.
    Incentivized
    Read full review
    Cloud Software Group
    • TIBCO Jaspersoft allows you to embed reports into your own application, which gives users the feeling they are using a single product.
    • TIBCO Jaspersoft Studio allows for more advanced report development, such as adding subreports, drilldown to detail reports, images, page headers, page footers, maps, and more.
    • TIBCO's Jaspersoft Domain Designer is very easy to use and navigate.
    Incentivized
    Read full review
    Cons
    IBM
    • Learning curve for DB resources - Improvements to UI or native command line built-ins can help with increasing efficiencies for DB resources
    • Better resource utilization monitoring and recommendations
    • Continue to adopt support for modern frameworks and languages making it easier for organizations to see making Db2 the easy first choice
    Incentivized
    Read full review
    Cloud Software Group
    • One of the issues we found during our implementation was that the reporting software would work faster for certain data sources and not the others. Extracting CSVs and XML was slower in comparison to JSON in our experience.
    • Jaspersoft Studio was the main IDE we used for development. Built atop the Eclipse IDE, we found that the tool was really resource intensive and generally take long time to initialize.
    Incentivized
    Read full review
    Likelihood to Renew
    IBM
    The DB2 database is a solid option for our school. We have been on this journey now for 3-4 years so we are still adapting to what it can do. We will renew our use of DB2 because we don’t see. Major need to change. Also, changing a main database in a school environment is a major project, so we’ll avoid that if possible.
    Incentivized
    Read full review
    Cloud Software Group
    JasperSoft has been amazing. It is well documented, fast, and transparent in how it functions. We have been very confident in JasperSoft in every aspect of our business and offerings where we've used it. On top of that, their improvements to the product have been fantastic. I am really looking forward to seeing where they take their product and how we can leverage that to please our clients
    Incentivized
    Read full review
    Usability
    IBM
    You have to be well versed in using the technology, not only from a GUI interface but from a command line interface to successfully use this software to its fullest.
    Incentivized
    Read full review
    Cloud Software Group
    I think it's a tool well suited for a software developer. Others with less coding skills could struggle somewhat with the tool. I find java a little unforgiving as a language for expressions and not very user friendly for the technically dis-inclined. Sometimes the numeric conversions cause issues (who knew that 0 and 0.0 would cause different things to happen). Previous experience with a reporting tool that used visual basic for its' expressions that I found much simpler to use. On the other hand, java is so widespread, you can easily google the syntax to accomplish what you need to do.
    Incentivized
    Read full review
    Reliability and Availability
    IBM
    I have never had DB2 go down unexpectedly. It just works solidly every day. When I look at the logs, sometimes DB2 has figured out there was a need to build an index. Instead of waiting for me to do it, the database automatically created the index for me. At my current company, we have had zero issues for the past 8 years. We have upgrade the server 3 times and upgraded the OS each time and the only thing we saw was that DB2 got better and faster. It is simply amazing.
    Incentivized
    Read full review
    Cloud Software Group
    We've never had an outage of the software itself. If it was unavailable, it was due to a network outage, not a problem with Jasper.
    Incentivized
    Read full review
    Performance
    IBM
    The performances are exceptional if you take care to maintain the database. It is a very powerful tool and at the same time very easy to use. In our installation, we expect a DB machine on the mainframe with access to the database through ODBC connectors directly from branch servers, with fabulous end users experience.
    Incentivized
    Read full review
    Cloud Software Group
    Complex reports on heavy data load may take considerable amount of time. We have experinced some latencies/misfires regarding to this.
    Incentivized
    Read full review
    Support Rating
    IBM
    Easily the best product support team. :) Whenever we have questions, they have answered those in a timely manner and we like how they go above and beyond to help.
    Incentivized
    Read full review
    Cloud Software Group
    They have a great customer support ticketing system in which they always respond same-day. They offer conference calls with srcreensharing as well in order to better understand your issues.
    I wish that the lower level support access came with more than just 12 cases per year though as this makes us less likely to reach out for questions on things that we then instead try to solve ourselves which results in loss of time in trying to acquire new features and or solve a problem.
    Incentivized
    Read full review
    In-Person Training
    IBM
    the material was very clear and all subjects have been handled
    Incentivized
    Read full review
    Cloud Software Group
    It did the job of getting us to our deadline we set for ourselves for initial launch. The customer we launched the product for was also there to learn about it at the same in order to better understand the capabilities. This helped greatly so that the customer was on the same page on what was possible when using jaspersoft. I think most people would not want their customers aware the product they are using is third-party but in this case it was a new experience for us both and so as we learned more about jaspersoft, we both had better communication on what the future road map was for their business needs in BI.
    Incentivized
    Read full review
    Online Training
    IBM
    No answers on this topic
    Cloud Software Group
    Resources available in the TIBCO Knowledge Base are covering almost everything. They are well organized, and covering almost every possibility. There is always the change to get back to the TIBCO support or to the dedicated Customer Success Manager whenever something very specific or bound to a customization is not covered.
    Incentivized
    Read full review
    Implementation Rating
    IBM
    db2 work well with the application, also the replication tool can keep it up
    Read full review
    Cloud Software Group
    Having just completed an upgrade to the latest version of Jaspersoft, I am happy to say their support was very good. There were a couple of small challenges which were not easily resolved, but they were primarily related to the fact that we had skipped updates for a couple of versions. The current update procedures assumed we were upgrading from the prior latest version (6.4) to to the new version (7.1).
    Incentivized
    Read full review
    Alternatives Considered
    IBM
    DB2 was more scalable and easily configurable than other products we evaluated and short listed in terms of functionality and pricing. IBM also had a good demo on premise and provided us a sandbox experience to test out and play with the product and DB2 at that time came out better than other similar products.
    Incentivized
    Read full review
    Cloud Software Group
    When looking at the different features of these reporting engines, and what we were going to be using it for, the answer seemed clear. Jasper offered exactly what we were looking for, and did so for a price that we were happy with. For a scalable, feature-rich reporting engine that doesn't break the bank, Jaspersoft is the way to go.
    Incentivized
    Read full review
    Scalability
    IBM
    By
    using DB2 only to support my IzPCA activities, my knowledge here
    is somewhat limited.

    Anyway,
    from what I was able to understand, DB2 is extremely scallable.

    Maybe the information below could serve as an example of scalability.
    Customer have an huge mainframe environment, 13x z15 CECs, around
    80 LPARs, and maybe more than 50 Sysplexes (I am not totally sure about this
    last figure...)

    Today
    we have 7 IzPCA
    databases, each one in a distinct Syplex.

    Plans
    are underway to have, at the end, an small LPAR, with only one DB2 sub-system,
    and with only one database, then transmit the data from a lot of other LPARs,
    and then process all the data in this only one database.



    The
    IzPCA collect process (read the data received, manipulate it, and insert rows
    in the tables) today is a huge process, demanding many elapsed
    hours, and lots of CPU.

    Almost
    100% of the tables are PBR type, insert jobs run in parallel, but in 4 of the 7
    database, it is a really a huge and long process.



    Combining
    the INSERTs loads from the 7 databases in only one will be impossible.......,,,,



    But,
    IzPCA recently introduced a new feature, called "Continuous
    Collector"
    .
    By
    using that feature, small amounts of data will be transmited to the central
    LPAR at every 5 minutes (or even less), processed immediately,in
    a short period of time, and with small use of CPU,
    instead of one or two transmissions by day, of very large amounts of data and
    the corresponding collect jobs occurring only once or twice a day, with long
    elapsed times, and huge comsumption of CPU



    I
    suspect the total CPU seconds consumed will be more or less the same in
    both cases, but in the new method it will occur in small bursts
    many times a day!!
    Incentivized
    Read full review
    Cloud Software Group
    We haven't really started to explore the scalability of the product as yet, but in terms of existing deployments it has done what we need it to do.
    Incentivized
    Read full review
    Return on Investment
    IBM
    • Negative: Difficult and manual deployment
    • Negative: Missing assistants from common monitoring metrics
    • Positive: Stability
    • Positive: Performance
    • Positive: Resiliency and high availability (HADR)
    • Positive: Data Replication (Q-Rep)
    • Positive: Interaction with storage subsystems for backups (TSM, SVC)
    • Positive: Gigantic monitoring features in the form of table functions
    Incentivized
    Read full review
    Cloud Software Group
    • When we demo our Jaspersoft environment to potential clients, their eyes light up and they sit up in their chairs a bit more. A lot of our meetings have ended with with the client very interested in our product due to Jaspersoft.
    • Our existing clients have been very satisfied with the adhoc features of Jaspersoft. We've been able to provide them better access to their data on their terms instead of ours. Of course this turns into a huge win for us.
    • We've always used SQL Server Reporting Services to deliver our reports to our clients. Converting to Jaspersoft has allowed us to generate the reporting layer that our clients demand. They no longer feel like they are settling for what we offer.
    Read full review
    ScreenShots

    Db2 Screenshots

    Screenshot of Db2 - Data sharingScreenshot of Db2 - Machine LearningScreenshot of Db2 - Real time insights

    Jaspersoft Screenshots

    Screenshot of Report DesignScreenshot of Ad-hoc ReportingScreenshot of Mobile ReportingScreenshot of Dashboard