What users are saying about
83 Ratings
83 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100
393 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.6 out of 100

Likelihood to Recommend

DB2

DB2 is suitable for any use. The main one is certainly the creation of an online database that can be queried online through TP queries and through batch reports. It is necessary to take care of the database maintenance to allow maximum performance, for this, there are the utilities that help the system operators to do it.
Anonymous | TrustRadius Reviewer

IBM Cognos Analytics

IBM Cognos is well suited when you are implementing with compatible software like Costpoint and other Deltek products, this will lead to great integration and result in the wonderful presentation of data for your reporting requirement. However, IBM Cognos is not well suited when being implemented with non-Deltek software as this will lead to challenges in integration and will not produce ideal reporting.
Nabeel Chohan | TrustRadius Reviewer

Feature Rating Comparison

BI Standard Reporting

DB2
IBM Cognos Analytics
8.0
Pixel Perfect reports
DB2
IBM Cognos Analytics
7.9
Customizable dashboards
DB2
IBM Cognos Analytics
8.2
Report Formatting Templates
DB2
IBM Cognos Analytics
8.1

Ad-hoc Reporting

DB2
IBM Cognos Analytics
8.3
Drill-down analysis
DB2
IBM Cognos Analytics
8.6
Formatting capabilities
DB2
IBM Cognos Analytics
7.6
Integration with R or other statistical packages
DB2
IBM Cognos Analytics
8.3
Report sharing and collaboration
DB2
IBM Cognos Analytics
8.7

Report Output and Scheduling

DB2
IBM Cognos Analytics
8.1
Publish to Web
DB2
IBM Cognos Analytics
8.1
Publish to PDF
DB2
IBM Cognos Analytics
8.3
Report Versioning
DB2
IBM Cognos Analytics
8.4
Report Delivery Scheduling
DB2
IBM Cognos Analytics
8.1
Delivery to Remote Servers
DB2
IBM Cognos Analytics
7.7

Data Discovery and Visualization

DB2
IBM Cognos Analytics
7.9
Pre-built visualization formats (heatmaps, scatter plots etc.)
DB2
IBM Cognos Analytics
7.7
Location Analytics / Geographic Visualization
DB2
IBM Cognos Analytics
7.7
Predictive Analytics
DB2
IBM Cognos Analytics
8.2

Access Control and Security

DB2
IBM Cognos Analytics
8.9
Multi-User Support (named login)
DB2
IBM Cognos Analytics
9.0
Role-Based Security Model
DB2
IBM Cognos Analytics
9.0
Multiple Access Permission Levels (Create, Read, Delete)
DB2
IBM Cognos Analytics
8.7
Single Sign-On (SSO)
DB2
IBM Cognos Analytics
9.0

Mobile Capabilities

DB2
IBM Cognos Analytics
6.6
Responsive Design for Web Access
DB2
IBM Cognos Analytics
7.3
Dedicated iOS Application
DB2
IBM Cognos Analytics
6.8
Dedicated Android Application
DB2
IBM Cognos Analytics
6.0
Dashboard / Report / Visualization Interactivity on Mobile
DB2
IBM Cognos Analytics
6.5

Application Program Interfaces (APIs) / Embedding

DB2
IBM Cognos Analytics
6.8
REST API
DB2
IBM Cognos Analytics
7.4
Javascript API
DB2
IBM Cognos Analytics
7.2
iFrames
DB2
IBM Cognos Analytics
7.0
Java API
DB2
IBM Cognos Analytics
6.2
Themeable User Interface (UI)
DB2
IBM Cognos Analytics
6.7
Customizable Platform (Open Source)
DB2
IBM Cognos Analytics
6.1

Pros

DB2

  • DB2 maintains itself very well. The Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction or without specific knowledge of cron or Windows Task Scheduler / Scheduled jobs.
  • Its use of ASYNC, NEARSYNC, and SYNC HADR (High Availability Disaster Recovery ) models gives you a range of options for maintaining a very high uptime ratio. Failover from PRIMARY to SECONDARY becomes very easy with just a single command or windowed mouse click.
  • Task Scheduler ( DB2 9.7 and earlier ) allows for jobs to be run within other jobs, and exit and error codes can define what other jobs are run. This allows for ease of maintenance without third party softwares.
  • Tablespace usage and automatic storage help keep your data segmented while at rest, making partitioning easier.
  • Ability to run commands via CLI (Command Line Interface) or via Control Center / Data Studio ( DB2 10.x+) makes administration a breeze.
J.R. Bullington | TrustRadius Reviewer

IBM Cognos Analytics

  • List/Table Reporting. It is awesome at providing detailed table lists of rows and provides it in multiple pages of a PDF based on the size of the table being exported.
  • Bursting to the appropriate individuals what they want to see/ have privileges to see.
  • Being able to email reports, whether that is HTML, PDF, or Excel formats.
Anonymous | TrustRadius Reviewer

Cons

DB2

  • IBM is really behind in delivering developer tools. They pride themselves on Data Studio, but it is just frustrating.
  • Marketing. Horrible to do a Google search and get returns for a COMPLETELY different product, for z/os. Why they share the same name is beyond me. Better marketing would also increase the user base and help the product mature.
  • Slower than the competition to roll out next-generation features.
Anonymous | TrustRadius Reviewer

IBM Cognos Analytics

  • Web-based authoring environment is slow, compared to Desktop based environment. It gets slower if the size of data gets bigger.
  • Congas is best when we create reports using coded data based on relational databases. Since a lot of clinical data are unstructured formatted, it may be required of good data wrangling function to include them into the reports.
  • Chart types and look and feel configuration flexibility are limited, especially compared to competitors such as Tableau. They are not terribly ugly, but not faulty looking with the default setting.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

DB2

DB2 8.0
Based on 2 answers
Because it is required to support our business unit
Anonymous | TrustRadius Reviewer

IBM Cognos Analytics

IBM Cognos Analytics 7.9
Based on 23 answers
For an existing solution, renewing licenses does provide a good return on investment. Additionally, while rolling out scorecards and dashboards with little adhoc capabilities, to end users, cognos is very easily scalable. It also allows to create a solution that has a mix of OLAP and relational data-sources, which is a limitation with other tools. Synchronizing with existing security setup is easy too.
Sachin Karkun | TrustRadius Reviewer

Usability

DB2

DB2 5.0
Based on 1 answer
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.
J.R. Bullington | TrustRadius Reviewer

IBM Cognos Analytics

IBM Cognos Analytics 7.5
Based on 6 answers
We have a strong user base (3500 users) that are highly utilizing this tool. Basic users are able to consume content within the applied security model. We have a set of advanced users that really push the limits of Cognos with Report and Query Studio. These users have created a lot of personal content and stored it in 'My Reports'. Users enjoy this flexibility.
Robert Goodman | TrustRadius Reviewer

Reliability and Availability

DB2

DB2 9.9
Based on 10 answers
DB2 for i is extremely stable. I've experienced system slowdowns and performance issues on badly configured systems or badly configured system accessing the DB but that's it, never had a problem caused purely by the software. Support is also pretty good.
Roberto Etcheverry | TrustRadius Reviewer

IBM Cognos Analytics

IBM Cognos Analytics 8.6
Based on 8 answers
Reports can typically be viewed through any browser that can access the server, so the availability is ultimately up to what the company utilizing it is comfortable with allowing, though report development tends to be more picky about browsers and settings as mentioned above. It also has an optional iPad app and general mobile browsing support, but dashboards lack the mobile compatibility. What keeps it from getting a higher score is the desktop tools that are vital to the development process. The compatibility with only Windows when the server has a wide range of compatibility can be a real sore point for a company that outfits its employees exclusively with Mac or Linux machines. Of course, if they are planning on outsourcing the development anyways, it's a rather moot point
Gerrit Goewey | TrustRadius Reviewer

Performance

DB2

DB2 9.6
Based on 10 answers
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.
Anonymous | TrustRadius Reviewer

IBM Cognos Analytics

IBM Cognos Analytics 9.0
Based on 10 answers
Overall no major complaints but it doesn't handle DMR (Dimensionally Modeled for Relational) very well. DMR modelling is a capability that IBM Cognos Framework Manager provides allowing you to specify dimensional information for relational metadata and allows for OLAP-style queries. However, the capability is not very efficient and, for example, if I'm using only 2 columns on a 20-column model, the software is not smart enough to exclude 18 columns and the query side gets progressively larger and larger until it's effectively unusable.
Meghdeep Raval, PMP | TrustRadius Reviewer

Support Rating

DB2

No score
No answers yet
No answers on this topic

IBM Cognos Analytics

IBM Cognos Analytics 7.0
Based on 14 answers
Why is their web application not working as fast as you think it should? They never know, and it is always a a bunch of shots in the dark to find out. Trying to download software from them is like trying to find a book at the library before computers were invented.
Jonathan Kyrlach | TrustRadius Reviewer

In-Person Training

DB2

No score
No answers yet
No answers on this topic

IBM Cognos Analytics

IBM Cognos Analytics 8.7
Based on 4 answers
Onsite training provided by IBM Cognos was effective and as expected. They did not perform training with our data which was a bit difficult for our end-users.
Robert Goodman | TrustRadius Reviewer

Online Training

DB2

No score
No answers yet
No answers on this topic

IBM Cognos Analytics

IBM Cognos Analytics 8.0
Based on 4 answers
The online courses they offer are thorough and presented in such a way that someone who isn't already familiar with the general design methodologies used in this field will be capable of making a good design. The training environments are provided as a fully self contained virtual machine with everything needed already to create the environments. We've had some persisting issues with the environments becoming unavailable, but support has been responsive when these issues arise and straightening them out for us
Gerrit Goewey | TrustRadius Reviewer

Implementation Rating

DB2

No score
No answers yet
No answers on this topic

IBM Cognos Analytics

IBM Cognos Analytics 7.0
Based on 14 answers
Make sure that any custom tables that you have, are built into your metadata packages. You can still access them via SQL queries in Cognos, but it is much easier to have them as a part of the available metadata packages.
Toni McKee | TrustRadius Reviewer

Alternatives Considered

DB2

DB2 is a similar product that is most respected. Oracle might be supported in a broader context, but DB2 is superior on every platform where the choice is there. Licensing is also a factor in which DB2 is much better, which might offset any cost differences. DB2 support is also much better at all tiers.
Anonymous | TrustRadius Reviewer

IBM Cognos Analytics

IBM is a titan in BI innovation but has arduous competitors as I mentioned before. IBM has prestige in BI and the directors and managers know that. On the other hand, complexity is not the strategy of Cognos, that's why if you need big cubes of data, Tableau, and Microsoft BI are better suited for the job. Even QlikView is more complex than IBM Cognos. On the other hand, your users can benefit from the advantages that set analysis studio and event studio for notifications.
Miguel Angel Merino Vega | TrustRadius Reviewer

Scalability

DB2

DB2 8.7
Based on 10 answers
It can grow as your company grows. It also plays well with Crystal Reports and other BI software once you create an ODBC connection for the DB. It can be managed with SQL management studio so no extra software is needed for that.
Josh Rice, MBA, ACSP | TrustRadius Reviewer

IBM Cognos Analytics

IBM Cognos Analytics 10.0
Based on 1 answer
The Cognos architecture is well suited for scalability. However, the architecture must be designed with scalability in mind from day one of the implementation. We recently upgraded from 10.1 to 10.2.1 and took the opportunity to revamp our architecture. It is now poised for future growth and scalability.
Robert Goodman | TrustRadius Reviewer

Return on Investment

DB2

  • Positive - Very good performance as compared to other traditional DBs.
  • Positive - Transaction and query search are made easy from a DB level with good performance, also runs on top scape on AIX servers.
  • Negative - There is always room for improvement, such as Webex queries and the GUI base tool. Also the available support documentation should be improved.
Pradeep Bele | TrustRadius Reviewer

IBM Cognos Analytics

  • (+) increased efficiency: Less time trying to figure out how to do something w/ another BI tool that may seem impossible -- Cognos will be able to do it 99% of the time
  • (-) increased training required: Training for Cognos had to be longer and more intensive than other BI tools. For example, my team members go through a week long 8-hour/day class and it was just enough to scratch the surface. A good base if required, but real world experience is the only way to become a Cognos pro.
  • (-) more end-user training: We do mostly canned reports with Cognos, so out end-users must be trainied. It is much harder to train them with Cognos than other BI tools. This is why I only turn to Cognos if I cannot accomplish my goal in another tool.
Anonymous | TrustRadius Reviewer

Pricing Details

DB2

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

IBM Cognos Analytics

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

DB2
9.2
IBM Cognos Analytics
7.9

Likelihood to Renew

DB2
8.0
IBM Cognos Analytics
7.9

Usability

DB2
5.0
IBM Cognos Analytics
7.5

Reliability and Availability

DB2
9.9
IBM Cognos Analytics
8.6

Performance

DB2
9.6
IBM Cognos Analytics
9.0

Support Rating

DB2
IBM Cognos Analytics
7.0

In-Person Training

DB2
IBM Cognos Analytics
8.7

Online Training

DB2
IBM Cognos Analytics
8.0

Implementation Rating

DB2
IBM Cognos Analytics
7.0

Scalability

DB2
8.7
IBM Cognos Analytics
10.0

Add comparison