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

    SAP Lumira Discovery

    Score8.4 out of 10
    N/ASAP Lumira Discovery is SAP’s data visualization and discovery application. It facilitates data discovery, visualization, and analysis by assisting users with creation of dashboards, infographics, presentations, data facets, tag clouds, and more.

    $185

    per user

    Pricing
    Db2SAP Lumira Discovery
    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
    SAP Lumira, standard edition
    $185
    per user
    Offerings
    Pricing Offerings
    Db2SAP Lumira Discovery
    Free Trial
    YesYes
    Free/Freemium Version
    YesNo
    Premium Consulting/Integration Services
    YesYes
    Entry-level Setup FeeOptionalNo setup fee
    Additional Details——
    More Pricing Information
    Features
    Db2SAP Lumira Discovery
    BI Standard Reporting
    Comparison of BI Standard Reporting features of Db2 and SAP Lumira Discovery
    Feature
    Db2
    -
    Ratings
    SAP Lumira Discovery
    8.0
    97 Ratings
    2% below category average
    Customizable dashboards00 Ratings8.097 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of Db2 and SAP Lumira Discovery
    Feature
    Db2
    -
    Ratings
    SAP Lumira Discovery
    7.3
    103 Ratings
    9% below category average
    Drill-down analysis00 Ratings10.0100 Ratings
    Formatting capabilities00 Ratings7.0103 Ratings
    Report sharing and collaboration00 Ratings5.098 Ratings
    Report Output and Scheduling
    Comparison of Report Output and Scheduling features of Db2 and SAP Lumira Discovery
    Feature
    Db2
    -
    Ratings
    SAP Lumira Discovery
    6.1
    95 Ratings
    30% below category average
    Publish to Web00 Ratings7.082 Ratings
    Publish to PDF00 Ratings5.094 Ratings
    Report Delivery Scheduling00 Ratings6.355 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of Db2 and SAP Lumira Discovery
    Feature
    Db2
    -
    Ratings
    SAP Lumira Discovery
    4.3
    104 Ratings
    60% below category average
    Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings5.0102 Ratings
    Location Analytics / Geographic Visualization00 Ratings6.095 Ratings
    Predictive Analytics00 Ratings2.072 Ratings
    Best Alternatives
    Db2SAP Lumira Discovery
    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
    Jaspersoft Community Edition
    Score7 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Db2SAP Lumira Discovery
    Likelihood to Recommend
    9.1
    (114 ratings)
    9.0
    (105 ratings)
    Likelihood to Renew
    7.9
    (12 ratings)
    6.0
    (1 ratings)
    Usability
    8.4
    (9 ratings)
    8.0
    (15 ratings)
    Availability
    9.3
    (64 ratings)
    5.0
    (2 ratings)
    Performance
    9.1
    (12 ratings)
    4.0
    (2 ratings)
    Support Rating
    8.9
    (6 ratings)
    1.0
    (12 ratings)
    In-Person Training
    8.2
    (1 ratings)
    6.0
    (1 ratings)
    Online Training
    -
    (0 ratings)
    6.0
    (1 ratings)
    Implementation Rating
    5.6
    (3 ratings)
    4.0
    (4 ratings)
    Configurability
    9.1
    (2 ratings)
    4.0
    (2 ratings)
    Data Sharing and Collaboration
    8.0
    (1 ratings)
    2.0
    (83 ratings)
    Data Sources
    9.0
    (1 ratings)
    10.0
    (89 ratings)
    Ease of integration
    7.8
    (4 ratings)
    4.0
    (2 ratings)
    Product Scalability
    8.3
    (66 ratings)
    4.0
    (2 ratings)
    Professional Services
    -
    (0 ratings)
    5.0
    (1 ratings)
    Vendor post-sale
    9.0
    (2 ratings)
    8.0
    (1 ratings)
    Vendor pre-sale
    9.0
    (2 ratings)
    5.0
    (2 ratings)
    User Testimonials
    Db2SAP Lumira Discovery
    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
    SAP
    Infographics derived from specific data sources appears to be well suited for development using Lumira. The development of executive level dashboards was less appropriate from my perspective. The software does not provide sufficient demonstration or samples for the users to learn from in my opinion.
    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
    SAP
    • SAP has built in features you would expect from a data visualization package, like easy import from other SAP systems.
    • SAP has most of the typical charts that you would expect in order to visualize your data.
    • SAP allows you to have multiple charts on one visualization for your data.
    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
    SAP
    • Even though the process of creating visualizations of data is now greatly improved, it could still be a lot better as users become accustomed to this kind of tool and bring forward edge cases the developers did not anticipate.
    • It would be awesome to have a cross platform tool that works on more than just Windows.
    • Some options for specific graphs feel limiting.
    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
    SAP
    Given the scope ,maintanence , support and budget are the main drivers to deciding renewal of a software
    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
    SAP
    SAP Lumira is very good self service analytical tool with powerful capabilities. However need to look into other SAP products in BI space, like SAP SAC. SAP Lumira is more used for custom and complex analytical need in business intelligence area. Also SAP Lumira is going out of maintenance in coming future replaced by SAP SAC.
    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
    SAP
    Lumira is a desktop application runs in its own JVM. It installs its own java runtime libraries to avoid any core java version conflicts. The availability of the application is completely relies on individual machine hardware configuration. On a decent desktop, it performs well and always launches in either 32 or 64 bit environment based on the hosts system's OS
    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
    SAP
    The performance is linear with amount of data that is being explored. We have done some benchmarks acquiring 10million data cells without having any performance problems. We need to make proper adjustments to jvm run time properties to start with higher heap size and other parameters that optimizes the run time performance
    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
    SAP
    It does not have many bugs or issues since not a lot of new features are being added. The customer support for SAP Lumira Discovery is good and anyone considering this as a self-service tool would be happy. It integrates well in the SAP BI suite of products and the overall experience is positive.
    Incentivized
    Read full review
    In-Person Training
    IBM
    the material was very clear and all subjects have been handled
    Incentivized
    Read full review
    SAP
    We did not take in-person training
    Incentivized
    Read full review
    Online Training
    IBM
    No answers on this topic
    SAP
    Most of the user guides are pretty comprehensive and very easy to understand. The product itself is designed to be self-serve tool, did not need much of the end-user training. Most of the training we had is to how to read the data, how to explore the data, how to acquire the data etc.
    Incentivized
    Read full review
    Implementation Rating
    IBM
    db2 work well with the application, also the replication tool can keep it up
    Read full review
    SAP
    Installing the desktop software on end-user machines is always challenging. The machine specifications are the biggest factor when running Lumira and be able to handle large datasets during data exploration. This often demands beefy machines at least for power-users. Although Lumira software licensing is not a big problem but managing partner's extensions and keeping track of their individual licenses may be an issue. If there is a way to bundle the more popular extensions such as vSQL or vOLAP should be bundled in core product and offer them as part of Lumira license instead of a separate license which causer operational burden.
    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
    SAP
    Even though SAP Analytics Cloud is considered to be better in aspects such as data connectivity or analytics, we decided to choose Lumira as it was easier to understand, learn and use. As our business is not really that big and does not require the inclusion of large amounts of data, Lumira was overall the safest and most comfortable option. Also, some members in our team had previous knowledge so it was easier to adapt
    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
    SAP
    Enterprise wide implementation is a challenge with data security and trustedness. No easy installation can be done across the enterprise. no upgrade paths also available from SAP. They have so much of experience with desktop implementation, there it could be a controlled environment with a capital budget. These may be resolved in the upcoming releases
    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
    SAP
    • We could obtain original data from vast and detailed corporate and personal data sources.
    • We could share visual analysis results with stakeholders via the cloud, and it could also be viewed on a tablet.
    • It is very flexible and accurate to use. It can be used for forecasting sales, resource planning, and scheduling.
    Read full review
    ScreenShots

    Db2 Screenshots

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

    SAP Lumira Discovery Screenshots

    Product screenshotProduct screenshotProduct screenshotProduct screenshotProduct screenshotProduct screenshot