• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MS Reporting Services and Oracle db

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