MS Reporting Services and Oracle db

[TheEarthWillShake]

There's a chance that the company I work for can get Reporting Services. We use Oracle as the standard db but we can use SQL 2005. It's just that this app might need to hook up to another Oracle database in the future for more financial information so using Oracle for our database might make it easier.

I still need to buy SQL Server 2005 License to use Reporting Services even with Oracle?

Licenses are confusing. I'm still looking into it.

 

[imported_Dhaval00]

SQL Server Express (free version) will not be a viable solution for you - it doesn't support OLE DB, Oracle, scheduled reporting, and crap loads of other features. If you buy SQL Server Standard Edition, you'll get the DB Engine (duh!), SSIS, SSAS, and SSRS. You can then build reports in SSRS, host data models, etc. as well as query your Oracle DB via stored procedures or queries.

The standard edition server license (don't confuse this with the per-processor license) may cost you a few thousand dollars depending on what kind of licensing agreement you have with MS. Overall, it is much, much, much cheaper than an Oracle license.

 

[TheEarthWillShake]

Thanks for the info!

 

[SoundTheSurrender]

aa