How to add oracle data source in ssrs

4
votes

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?

1
reporting-servicessql-server-2012datasourcesql-server-2012-expressreportmanager
Which version of SQL Server 2012 are you using? - Sébastien Sevrin
sql server 2012 exress advanced edition , version 11.0.2100.60 - user3131955
Have you installed the .NET Framework Data Provider for Oracle? - Sébastien Sevrin
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
Have you installed the Oracle provider on both your dev computer and the server? - Sébastien Sevrin

1 Answers

3
votes

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.