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.
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