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?

Answer 1

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:

• Using the .NET Framework Data Provider for Oracle
• How to use Reporting Services to configure and to access an Oracle data source

---

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.