IBM Cognos Analytics vs. Toad Data Point

I use predictive analytics techniques, which can help me predict my future sales based on collected data, giving me insight into my market's trends.This market data can be analyzed, giving me the opportunity to gain in-depth insight into my market's competition and positioning it competitively, aided by developing strategies to improve my marketing approach.

Incentivized

Toad Data Point is the clear tool of choice if the end-user is interested in reports that are relatively simple to build using SQL code and export to Excel. It is less useful if the analyst also needs to run statistical models on the data and visualize the data for those functions I usually use RStudio or Jupyter Notebook which incorporates those features much more seamlessly.

Incentivized

• Data Visualization: Plenty of options exist for multiple use cases, and dashboards are easy to implement and customize.
• Integration with IBM Watson: makes it easy to use Watson AI features (NLP etc.) on your data.
• Its advanced analytics functionalities with powerful pattern detection/prediction models.

Incentivized

• Ease of use. It is a very easy product to use without any particular training.
• Multiple data source connection. It easily connects to multiple data sources which allows you to use different data sources to run reports.
• Seamless application. Once you set everything up-- whether it is an FTP or export of data-- you can set it and forget it!

Incentivized

• API integration is not upto the mark with very limited options.
• Laptops get overheated when the tool is used from moderate to heavy use. Also, there is a lag in the tool times.
• Licensing & Maintenance can go from cheap to expensive depending on the scope.
• Lot of scope to improve the customer support & its not upto the industry standards.

Incentivized

• The program can error out when reconnecting to a database from a timeout but that is easily fixed by restarting the program.
• If you aren't familiar with database tools the UI can be overwhelming to some.

Incentivized

It took my BI team one year to become productive at developing useful content on the IBM Cognos platform. After this year, the reports being developed for a client were stale and no longer relative to the ever changing needs of the business client. Given the same opportunity, I would select a platform that allows the team to quickly produce BI content. Fail fast and recover quickly!

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.

I find Toad Data Point easy to use for both the novice and the experienced business analyst. If all you desire is to access data and create spreadsheets...this is a snap. Toad Data Point actually has cool data analysis features built into it. The newer workflow interface makes automating steps a snap

Incentivized

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

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.

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.

Incentivized

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.

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

The implementation was handled very well. The initial implementation exposed a lot of disagreement between our campuses and departments as to how we define data. This was not entirely unexpected, but I thought that we did a nice job as a team to work through some of these challenges.

Power BI is stronger for quick ad-hoc analysis and dashboards, but IBM Cognos Analytics is better when consistency, precision, and mass distribution matter. Tableau is best for interactive analysis, while IBM Cognos Analytics is better for standardized, repeatable enterprise reporting. Sigma shines for customizable dashboards and drill-down analysis while IBM Cognos Analytics holds an edge in data discovery and visualization.

Incentivized

TOAD excels at connecting to divergent data sources, but appears geared more to DBAs than to regular query users. Microsoft's offerings excel against Microsoft SQL Server, but sometimes struggle with other data sources. However, SSMS and vs code excel at many developer productivity/workflow enhancements. vs code, in particular, has a lively extension system that allows it to be tailored for development/querying/model building/etc. That flexibility comes at a cost - the learning curve is steep for new users. The tradeoff between complexity and power may not be good for some environments/users/situations.

Incentivized

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.

• The platform can be pretty pricey.
• Convoluted contracts and they fine you for any breach during audits.
• Things are changed between releases without any warning and break.
• It is second to none at being able to customize list and crosstab type reports.
• You can easily set up a report to be emailed out every day and even have it export the report to a shared folder.
• On-prem environments can be scaled up pretty much as much as you would like.

Incentivized

• It is the least common denominator - not particularly optimized for our environment or workflows.
• Hangs or slowdowns add anywhere from 5% - 7% for projects utilizing large/complicated data setts. (This could be due to other IT-imposed constraints and not entirely due to TOAD.)
• Trying to perform some operations requires reading documentation and experimenting in order to figure out the TOAD-specific approaches and commands.
• It just works (when we understand it). Updates don't break things and things don't suddenly start behaving differently. Best of all, we don't mysteriously lose functionality.

Incentivized