We performed a comparison between IBM Cognos and SQL Server based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Tableau, Oracle and others in BI (Business Intelligence) Tools."The Report Studio that is aimed at professional report writers."
"IBM Cognos offers tools so that you can design and develop your own test queries and reporting solutions."
"The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools."
"It's enabled us to report directly from our main application systems. We're removing islands of data and we're removing inefficiencies, where people or small divisions had their own store of information."
"The dashboarding offered by this solution is very valuable to us."
"One of the strong suits of Cognos is its robust corporate reporting capability."
"Report Studio: This is the most powerful and sophisticated tool for professional reporting."
"The three IBM Cognos features I find the most valuable are Dynamic Cubes, PowerPlay, and Watson."
"Excel integration is one of its most valuable features."
"The scalability of the product is great."
"The main feature of this solution is ease of use."
"The most valuable aspect is the ability to utilize jobs and various functions to accomplish specific tasks, which cannot be achieved with standard procedures alone. This allows for a combination of features and functionalities to be employed."
"The most valuable feature of SQL Server is that it is easy to set up."
"can extract data from the server and store it in a local data source for BI purposes."
"Without any doubt the Integration Services and Analysis Services are the most widely used. These are the basis for data quality, data gathering, ETL process, as well as collation for the data warehouse, Cube-generation, and ad-hoc processes. The ease in which you may mold a process flow or even modularly add in new structures is something which is much needed in my job."
"It integrates well with other platforms."
"It would be better if it is was easier to implement without extensive training for it."
"In terms of what could be improved, I would say, monitoring, monitoring, monitoring. Some improvements in monitoring would be helpful. I'd like to see more monitoring of specific reports and fields. The way the auditing is now is very limited, so I'd like to see more of that - of the monitoring."
"We need more predictive analytical functions, not only diagnostic or decryptic analytics."
"The high cost of a license makes it hard to scale up on a budget."
"We would like to see development of the product's UI function, to make it more of a UI tool that can be configured as required."
"I don't like that when we use Colab packages, we get less functionality. For example, you can make groups of data with Excel or with the data sets from the packages, but when you use the Colab packages directly, you can only group the data when you analyze it with Analysis Studio. I think Cognos needs to improve more on this functionality."
"It would be good if the solution had conditional formatting."
"Extending dynamic cubes aggregate awareness with calculated measures."
"The tool needs to improve its pricing and technical support."
"The scalability and the high availability feature can be expanded or improved. Currently, there is a limitation on scalability. A feature similar to the Oracle Diagnostic feature can be included to provide a better user experience."
"We need it to support Linux for better troubleshooting flexibility."
"Debugging from the debugger tool functionality should be enhanced."
"The interface could be updated to make it slightly more user-friendly."
"It's difficult to make changes. It's a very complicated product in general — that's the issue."
"The agility of the non-SQL-based features is relevant on the market."
"On the SQL Server Management Studio (SSMS) side, I have noticed more bugs in terms of being able to connect to our SQL servers. I can't tell how many times my recent server list got dropped or cleaned out. It is a pain, and it would be nice to have that recent connect list when you connect in. For whatever reason, once in a while, I get a hard error, and it'll close. When I go back in, everything is cleared out. It is annoying when you are working with more than a hundred database instances."
IBM Cognos is ranked 7th in BI (Business Intelligence) Tools with 132 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. IBM Cognos is rated 8.0, while SQL Server is rated 8.4. The top reviewer of IBM Cognos writes "Improved the quality of our KPIs, while reducing calls to the IT department". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". IBM Cognos is most compared with Microsoft Power BI, Oracle OBIEE, Tableau, SAP BusinessObjects Business Intelligence Platform and Microsoft SQL Server Reporting Services, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and QlikView.
We monitor all BI (Business Intelligence) Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.