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."One of the strong suits of Cognos is its robust corporate reporting capability."
"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 most valuable feature is developing reports from different data sources, making it a reliable data source."
"Mapbox integration for geospatial analytics down to longitude/latitude layers."
"The product is a very good reporting tool and is very flexible. It allows for the users to get a scheduled report."
"I have worked on the features like dashboards and stories, and I do like them a lot."
"Cognos is the best application with dashboards,batch reporting, jobs, events and ad-hoc reporting for business users."
"Security administration tools are powerful and flexible."
"I have found the whole solution with all its features wonderful."
"The installation is really easy."
"Scalability, cluster ability, ease of use, ease of implementation — these are all great."
"Microsoft SQL Server is one of the better database administration software packages out there. It runs primarily on Windows Server platforms, but it can also run on Linux platforms."
"Backups hardly get corrupt."
"It is easy to deploy and easy to maintain."
"It's a good learning environment, it's easy enough to learn and understand. Anybody that picks up the language early on will be able to develop in it."
"The most valuable feature would most likely be querying. We query a lot, we use a lot of stored procedures. As for other features, such as replication and all other more fancy features we don't use them the most. I do not know, but perhaps the DBAs would be the best people who know of the features that they use, but as far as how I use it, it's just for querying and running stored procedures. We use the bare minimum features."
"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 tool needs to improve the connectivity since I see that, at times, there is a need to increase the memory in the database."
"There are many problems with the product's stability part, making it an area where improvements are required."
"The solution's support could be better."
"There are a lot of limitations with the out-of-the-box tool."
"I would like to have predictive and forecasting capabilities in Cognos. It's one thing to do reporting, and another thing to easily predict or forecast certain data points, which is very important for all the clients."
"It would be better if it is was easier to implement without extensive training for it."
"The performance is not always the best."
"The pricing of the product could be better."
"Database support could be improved."
"The solution’s initial setup could be complex, requiring some design of how you want to lay everything out and what type of storage you want to put certain things on."
"The interface of the tool has certain shortcomings, making it an area where improvements are required."
"The solution could improve by having more integration with other operating systems and other platforms."
"The stability of the solution should be improved in the next release. Sometimes it is great, sometimes it is troublesome. I would also like data conversion and the code pages to be a bit more straightforward."
"It would be better if it had more integration with other systems."
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.