"Security administration tools are powerful and flexible."
"IBM Cognos improves the effectiveness of the sales team."
"The most valuable features of IBM Cognos are governance and enterprise reporting."
"The initial setup is quite straightforward."
"I have worked on the features like dashboards and stories, and I do like them a lot."
"The product is a very good reporting tool and is very flexible. It allows for the users to get a scheduled report."
"This solution allows you to input a wide range of file formats."
"A drag-and-drop interface for selecting creating ad hoc reports makes this product very easy to use."
"I haven't really experienced any issues that required the assistance of technical support."
"It is easy to use and easy to perform a backup."
"It's a flexible solution."
"I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server."
"The features that we have found the most valuable are reliability, availability perspective, and current scalability."
"We have found the solution to be scalable."
"The solution is very common. It's easy to use."
"For me, the initial setup is very easy as I have years of experience with the product."
"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."
"The solution seems to slow down the servers."
"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."
"The performance is a bottleneck and something that can be improved."
"The high cost of a license makes it hard to scale up on a budget."
"They were lacking in the initial phases of development in the area of big data, and they still need to improve that aspect of the product."
"The AI-based features could be further enhanced by the solution."
"Tableau and Power BI are faster than Cognos."
"For small-scale businesses, Microsoft could improve by removing some limits in SQL Express."
"The free version of SQL Server is time-limited before updating to the paid version."
"Technical support could be faster."
"I would like to see the database become fully automated."
"The integration could be better. They are not open-source, so the integration with other platforms is not that easy."
"They have too many licensing options. They may want to simplify its licensing and bring it down to two, three, or four categories from ten to fifteen categories. Having so many different licensing options makes it difficult to decide which one to choose from. They can club things together. This is an area where they can make things easier for customers."
"Performance could be improved."
"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."
Cognos Software is IBM's Business Intelligence and Performance Management solution, offering BI, strategy management, financial performance, and data analytics applications. Cognos caters to all levels in an organization with products designed for individuals, workgroups, departments, mid-size companies, and big enterprises.
SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.
Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.
IBM Cognos is ranked 8th in Business Intelligence (BI) Tools with 13 reviews while SQL Server is ranked 1st in Relational Databases with 143 reviews. IBM Cognos is rated 8.0, while SQL Server is rated 8.2. The top reviewer of IBM Cognos writes "Excellent correlation analysis, highly scalable, but more features needed". On the other hand, the top reviewer of SQL Server writes "Veteran solution with critical log shipping feature". IBM Cognos is most compared with Tableau, Microsoft BI, Qlik Sense, Microsoft SQL Server Reporting Services and Oracle Hyperion, whereas SQL Server is most compared with SAP HANA, Oracle Database, LocalDB, IBM Db2 Database and SAP SQL Anywhere.
We monitor all Business Intelligence (BI) 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.