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, SAP and others in BI (Business Intelligence) Tools."The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools."
"I have worked on the features like dashboards and stories, and I do like them a lot."
"Self-service is possible through the use of dashboards, which are also very intuitive. Stories can be used to pin snapshots, tell the story for meetings, etc."
"The main difference that I like about Cognos compared to other solutions is its data splitting functionality. We have all our company data inside the Cognos environment and so we prefer to split the information Cognos itself. It's more efficient this way."
"The basic platform comes with several meta-modelling tools."
"Mapbox integration for geospatial analytics down to longitude/latitude layers."
"IBM Cognos improves the effectiveness of the sales team."
"The most valuable features of IBM Cognos are governance and enterprise reporting."
"It will do clustering, so you can have two database servers looking at the same data simultaneously."
"SQL Server is a stable product."
"SQL Server is very good, it can be used as a transactional database and used to support the data warehouse. Additionally, the ANSI-compliant satisfies our database properties."
"The solution has a reliable database."
"It's a very capable, efficient, price-performant OLAP server."
"We have found there are many useful features such as the solution is continually being upgraded, ETL capabilities for extracting and transformation, and it is very easy to use."
"The product is easy to use."
"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."
"The high cost of a license makes it hard to scale up on a budget."
"The tool needs to improve the connectivity since I see that, at times, there is a need to increase the memory in the database."
"The data uploads that we do, such as Excel files, have a lot of restrictions. If we can make it a bit more user-friendly, allowing us to have more flexibility it would be a great help."
"Cognos is quite slow - it's missing the performance of the PowerPlay cubes."
"The performance is a bottleneck and something that can be improved."
"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."
"This product could use improvement in terms of usability for those with less technical know how."
"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."
"Its ability to handle certain kinds of large data could be improved."
"The remote access aspect needs to be improved in terms of security."
"SQL Server has good performance, but it could be better."
"SQL Server backups could be better."
"It would be nice if they can reduce its price."
"I would like the SQL Server to be able to provide cloud support. We use the solution with a Korean provider supporting only MySQL rather than Microsoft SQL Server, which would be preferable and cheaper. This would prevent us from having to pay for troubleshooting and hosting the server."
"You do need to have technical knowledge in order to install the solution. It's not something a layperson can do."
"The solution could be better when it comes to security."
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, Oracle Hyperion and Looker, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and CockroachDB.
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.