How to add oracle data source in ssrs

Question

I've installed SQL Server 2012, after I've installed all features including report services. I go to Report Manager link and wanted to add New Data Source, but in Data Source Types there is only Microsoft SQL Server and I want to add Oracle Data Source.

Other way I easily connected to Oracle Data Source in Business Inteligence Studio, but I can't deploy Report file (.rdl) to my report manager because it gives me an error message:

An attempt has been made to use a data extension 'ORACLE' that is either not registered for this report server or is not supported in this edition of Reporting Services.

Does anyone have any idea how to fix this?

sql server 2012 exress advanced edition , version 11.0.2100.60 — user3131955, Jun 23 '15 at 13:52
Have you installed the .NET Framework Data Provider for Oracle? — Sébastien Sevrin, Jun 23 '15 at 13:59
i don't know sure, but is it possible to check if it's already installed? i looked in assemblies an there is assembly named OracleDataAcess — user3131955, Jun 23 '15 at 14:03
Have you installed the Oracle provider on both your dev computer and the server? — Sébastien Sevrin, Jun 23 '15 at 14:21
See my edit, you can't connect to Oracle with an Express Edition. The documentation is confusing though, because if you follow this [link](https://msdn.microsoft.com/en-us/library/ms365166%28v=sql.90%29.aspx), you see that SSRS 2005 Express doesn't support Oracle Data Source and switching to SSRS 2008 R2 Express doesn't mention it, you have to go to this [link](https://msdn.microsoft.com/en-us/library/cc281020%28v=sql.105%29.aspx) to find out that it's not supported in SSRS 2008 R2 Express... — Sébastien Sevrin, Jun 23 '15 at 15:21
Yes I understand thank you a lot, than which version of sql server i must install? — user3131955, Jun 23 '15 at 16:04
Not the express one, so the Standard at least. If you can afford an Enterprise, it's up to you :) (If you want to use Data-Driven subscriptions, then choose at least the BI edition) — Sébastien Sevrin, Jun 23 '15 at 16:09
will it work on standart edition? is it free? or maybe Evaluation how you think? — user3131955, Jun 23 '15 at 16:19
You will be able to target Oracle with a Standard Edition. It is not free, unless you are using it for academic purposes, but this is off-topic. — Sébastien Sevrin, Jun 23 '15 at 16:22

Sébastien Sevrin · Answer 1 · 2015-06-23T15:23:29.417

You should install the .NET Framework Data Provider for Oracle on the server hosting the SSRS instance to be able to target an Oracle database.
Here is a link to download the latest version on Oracle.

Remarks
Before you can connect an Oracle data source, the system administrator must have installed the version of the .NET Data Provider for Oracle that supports retrieving data from the Oracle database. This data provider must be installed on the same computer as Report Builder and also on the report server.

Source: Oracle Connection Type (SSRS)

Useful resources:

If you are using the Express edition of SQL Server, then Oracle Data Sources are not supported:

Analysis Services, Oracle, XML, SAP, SQL Server Integration Services (SSIS), OLE DB, and ODBC data sources are not supported.

Source: Features Supported by Reporting Services in SQL Server Express

It applies to SSRS 2012 Express as well, as stated in this post.

How to add oracle data source in ssrs

1 Answers1