bamapie
asked on
SSRS vs BusinessObjects
We have been a BOE XI-R2 shop for the past 5-6 years. We're currently at a fork in the road--pay up to renew support with BO--and upgrade to their latest stuff (Edge?)--or switch over to SSRS for "free".
We have quite a few reports in BO/WebI. These would have to be redone.
But forgetting the whole cost-to-upgrade thing, do you guys happen to see any *current* comprehensive comparison between BOE/Edge and SSRS?
I know beans about SSRS. Is it closing in on maturity? How "self-serve" is it? Can my unsophisticated users build their own reports?
What about user management in SSRS? Everyone needs an AD account, I guess?
One of the things I hate about BOE XI-R2 is that its installation model is astraddle SQL Server and a bunch of cryptically-stored .WID files in that crazy hashed-folder-labyrinth in the InfoStore folder. I just question our ability to recover from a catastrophic event on my BO server.
Maybe BOE is now totally SQL-driven? I'd like to know that restoring BO is as easy as restoring a SQL database.
Anyway, what I'd really like is a good run-down of the two suites -- what will I lose with SSRS? Your anecdotal experience and advice is also welcome.
Thanks.
We have quite a few reports in BO/WebI. These would have to be redone.
But forgetting the whole cost-to-upgrade thing, do you guys happen to see any *current* comprehensive comparison between BOE/Edge and SSRS?
I know beans about SSRS. Is it closing in on maturity? How "self-serve" is it? Can my unsophisticated users build their own reports?
What about user management in SSRS? Everyone needs an AD account, I guess?
One of the things I hate about BOE XI-R2 is that its installation model is astraddle SQL Server and a bunch of cryptically-stored .WID files in that crazy hashed-folder-labyrinth in the InfoStore folder. I just question our ability to recover from a catastrophic event on my BO server.
Maybe BOE is now totally SQL-driven? I'd like to know that restoring BO is as easy as restoring a SQL database.
Anyway, what I'd really like is a good run-down of the two suites -- what will I lose with SSRS? Your anecdotal experience and advice is also welcome.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Well, to be more clear, we are BO users. We already have an investment there...and some inertia built in to any move to another tool.
The only other option we're seriously considering would be SSRS. That decision would be one made totally on (1) cost, and (2) possible better integration with our increasingly MS-centric environment.
The only other option we're seriously considering would be SSRS. That decision would be one made totally on (1) cost, and (2) possible better integration with our increasingly MS-centric environment.
I would say SSRS would be better integrated with MS products (though not necessarily true).
However the learning curve for SSRS can be rather steep and it is a much different method of developing reports.
mlmcc
However the learning curve for SSRS can be rather steep and it is a much different method of developing reports.
mlmcc
ASKER
I keep getting the common sentiment from opinion after opinion (here and elsewhere) the *SSRS IS NOT SELF-SERVE*.
I'm not saying that's accurate or inaccurate. But I keep getting that vibe--that my less sophisticated users are really going to struggle as they try to build reports. True?
I'm not saying that's accurate or inaccurate. But I keep getting that vibe--that my less sophisticated users are really going to struggle as they try to build reports. True?
I couldn't say for sure. I tried on one porject (no training available) and couldn't get a report written. It is (at least from what i saw) a much different process for building a report than Crystal.
If you have some training to get them started they may find it easier to use.
mlmcc
If you have some training to get them started they may find it easier to use.
mlmcc
mlmcc is right with a little training you can go along way. If you have a base temple that you make as a starter report this will help the average user build reports faster.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>t's a pretty big decision to make based on some comments in a forum.
NOT the only input going into this decision!
Thanks for your response.
NOT the only input going into this decision!
Thanks for your response.
lol. Yeah, after I posted that I thought, "Well, he certainly can't base his opinion on this website." Didn't mean to offend. :-)
ASKER
No, not at all. I just want to take a big "sniff" of what folks think about SSRS who have experienced both.
If I had to choose one I would go ahead and go to SSRS.
The overall cost of long term BO lic. is far higher in the long run than a short time of training which would be about one to two months max. with no lics. fees.
The overall cost of long term BO lic. is far higher in the long run than a short time of training which would be about one to two months max. with no lics. fees.
There are many alternatives to the BO enterprise toolset that come much cheaper. Some of them are better than the BO tools.
mlmcc
mlmcc
ASKER
Thanks everyone for your perspectives on the BOE/SSRS question. Very much appreciated.
ok, do we have to buy the SQL Server in order to use the SSRS feature to use with Oracle DB as the backend ?
Hi
Yes you do but there is SQL Server Express (Free) which has SSRS (not SSIS/SSAS and limited DB Engine) but I'm not 100% sure if it can connec to Oracle (I would imagine so but maybe there are some connection limitations in express)
Regards
Emil
Yes you do but there is SQL Server Express (Free) which has SSRS (not SSIS/SSAS and limited DB Engine) but I'm not 100% sure if it can connec to Oracle (I would imagine so but maybe there are some connection limitations in express)
Regards
Emil
ah, OK thanks man ! so glad that we don't have to buy the full version of SQL Server because it is expensive, by the way what's the limitation on Oracle database using that freeware ?
using Microsoft SQL Server 2008 R2 Report Builder 3.0 from: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=d3173a87-7c0d-40cc-a408-3d1a43ae4e33&displaylang=en
using Microsoft SQL Server 2008 R2 Report Builder 3.0 from: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=d3173a87-7c0d-40cc-a408-3d1a43ae4e33&displaylang=en
NONE of these programs are identical.
I'm not sure you can say one is "better" than the other either since each has its strong points and its deficiencies. Each company will have to research these and other products (ie. Microstrategy, Oracle 10g, etc..) to see which program will best fit their BI Reporting Goals and BUDGET.
In my opinion,BI industry reporting tools such as these 3 as an example have become really strong, intuitive tools all of which can basically handle any company's reporting requirements.