09 June,2014 by Tom Collins
Question: I’d like to implement a low-cost Reporting solution. The user base is internal IT staff.
We’d like to exploit a large investment in a SQL Server infrastructure
Answer: Based on the SQL Server platform, there are two widely used reporting frameworks. SQL Server Reporting Services (SSRS) and Business Objects (BOBJ). There are other options, but these two frameworks dominate with a wide user-base
Some factors to consider in deciding SSRS versus BOBJ.
1) Does your DBA team support SSRS installations? Do they have standards in place , so customers can easily integrate?
2) BOBJ charges by named user or CPU. SSRS is packaged with SQL Server. There are no additional costs in adding the SSRS toolset
3) Without question BOBJ has a wider range of reporting, dashboards and visualisation build-ins. End-Users prefer the visual approach. Keep in mind the user base. If the end users are more IT oriented , this may not be such a factor
4) SSRS requires developers to build reports. BOBJ implements a user self-service model. Depending on the planned implementation , developer costs may be less with BOBJ
System Reserved Partition and monitoring
SQL Server Database Status,monitoring and Restores
How to report a SQL Server performance problem
SQL Server Database Size and Free Disk Space Daily Report
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |