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 most valuable feature of IBM Cognos is security. The solution has updated features that other competitors' solutions come out with long after IBM Cognos has had them."
"The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools."
"IBM Cognos offers tools so that you can design and develop your own test queries and reporting solutions."
"Cognos' most valuable features are the bundled studios, simple UI, and advanced features like the ability to create data modules."
"Integration with Office can enable the 'download' mode of storytelling."
"Security administration tools are powerful and flexible."
"The initial setup is quite straightforward."
"The dashboarding offered by this solution is very valuable to us."
"The product’s most valuable features are flexibility and scalability."
"SSAS is the most interesting feature to organize the data and let the users play with it."
"The most valuable feature is that it is easy to use and you don't have to do a lot of configuration."
"I believe Always On is the most valuable feature. It's also easy to use and not very tricky."
"SQL Server is essentially the backbone of every microservice. From a developer's perspective, it is the backbone of all microservices. The tool enables data retrieval, set data, and essential operations, ensuring the smooth functioning of applications. In essence, it is the integral part that keeps applications operational."
"Its usability is very good. Its performance is satisfactory."
"The most valuable feature of SQL Server is that it is easy to set up."
"The solution can be deployed in a few minutes."
"The performance is a bottleneck and something that can be improved."
"It would be better if it is was easier to implement without extensive training for it."
"The tool needs to improve the connectivity since I see that, at times, there is a need to increase the memory in the database."
"It could have more options for themes."
"Cognos is quite slow - it's missing the performance of the PowerPlay cubes."
"Compared to Tableau and PowerBI, the IBM interface is easier to use. However, the drag-and-drop functionality isn't as straightforward. Formatting is also more challenging in the cloud than in other applications, like Power BI. Also, if you encounter an issue, it takes more time to resolve it on the formatting side."
"The solution seems to slow down the servers."
"There are some small features that are missing. It would be nice if the graphics were better. You can use external sources for charts, but it's quite complex to use and not easy to implement. If you want a new chart, you can download it from multiple tools and implement it into IBM Cognos."
"The integration could be better. They are not open-source, so the integration with other platforms is not that easy."
"SQL Server could be improved with cheaper licensing because it's very expensive."
"SQL Server doesn't have proper bitmap indexing, proper columnar databases, or proper implementation of materialized views."
"I do not think SQL Server is suited for a typical database warehouse environment. However, people do use SQL Server for data warehouse environments but the best use case is for very small databases. If somebody wants to store more than 10 TB of data querying then the performance really degrades. The performance should be improved in the future to allow more scalability."
"SQL Server could improve by increase the performance, it cannot handle large amounts of data. I did not find any additional features compared to others solutions."
"In my experience, I've found that scalability can be improved."
"SQL could be improved by making all features available on the on-premise version of the product as well as the cloud version. When you buy the on-premise version, it's sort of an inferior product compared to the cloud version, which seems to get most of the latest and greatest features."
"SQL Server has good performance, but it could be better."
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.