How to add oracle data source in ssrs

reporting-services sql-server-2012 datasource sql-server-2012-express reportmanager
user3131955 picture user3131955 · Jun 23, 2015 · Viewed 19.7k times · Source

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

Sébastien Sevrin picture Sébastien Sevrin · Jun 23, 2015

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.

Related questions

SQL Server LCK_M_S only happens in production

I have a stored procedure that is called by a SQL Server 2012 report that is taking an age to run in production compared to development because of a blocking session lck_m_s The stored procedure runs instantaneously when executed …

Read More
SSRS 2012 Report Models

I am preparing a SSRS 2008 R2 commercial demo for my company, using Report Model to produce a kind of "BO Universe" data model to use with Report Builder, to show how users can produce their own reports by using a …

Read More
The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More