We have a requirement to connect Reporting Services 2008 R2 x64 + Report Builder 3.0 to Oracle database and also to build a web application which connects to Oracle. I installed ODAC (Oracle Data Access Components) which contains ODP.NET (Oracle Data Provider for .NET) and Instant Client (required by the provider). Now the problem is how to make Report Designer, Reporting Services and Report Builder 3.0 to add ODP.NET as an Oracle provider in the drop down list contained by the Data Source Wizard? I found out that Reporting Services and Report Builder work based on Data Extensions so I added Oracle.DataAccess as extension to RsReportServer.config and RsReportDesigner.config as shown in: http://www.bigresource.com/Tracker/Track-ms_sql-aIXqXMEE/. By changing RsReportDesigner the ODP.NET appeared in the list for Report Designer (Business Intelligence Studio) but it couldn't be used because an error was thrown as soon as Test Connection was pressed stating that the provider is not registered with the application. With these changes ODP.NET does not appear in the list of providers for Reporting Services and Report Builder 3.0. For now I managed to connect to Oracle through .NET Provider for Oracle (provided by default) but this seems to be deprecated and in Report Builder 3.0 I can't select tables to be added to the query, I'm prompted only with a blank textbox and one exclamation mark for execution.

im not sure if opd.net is supposed to be used like that, i thought it was more for adding the oracle.dataaccess reference to custom .net apps. I always use the .net provider for oracle option without any problems and never heard anything about it being deprecated. Another option can be to use a oracle odbc connection.

Yes ODP.NET means adding Oracle.DataAccess. .NET Provider for Oracle is about to be deprecated and Oracle will offer the ODP.NET provider. .NET Provider is marked as deprecated also in Visual Studio 2010 and if you use ".net provider for oracle deprecated" on google you'll find several results. Therefore is better to use the provider Oracle is offering (maybe not necessarily right now).

Hi Addrei, Any Data Processing Extension must implement the following interfaces: IDbConnection IDbTransaction IDbCommand IDataParameter IDataParameterCollection IDataReader IExtension There interfaces are included in the Microsoft.ReportingServices.DataProcessing namespace. The Oracle Data Provider for .NET(ODP.NET) is a indenpendent component, it doesn't implement these interface. So, it can be used in the SQL Server Reporting Services(SSRS) directly. In order to use the ODP.NET in SSRS, we need to implement a custom Data Processing Extension using the ODP.NET. We can start implementing a custom Data Processing Extension from: http://msdn.microsoft.com/en-us/library/ms154655.aspx Alternatively, since the .NET Framework Data Provider for Oracle is deprecated and will be removed in a future version of the .NET Framework, I would suggest you submitting a feedback at https://connect.microsoft.com/sql. If the service requests frequently, we may include the ODP.NET in the next release. If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Thank you. Feedback was added: https://connect.microsoft.com/SQLServer/feedback/details/604750/in-need-of-new-provider-for-oracle-on-next-versions.

Installing Oracle Developer Tools for Visual Studio (http://www.oracle.com/technetwork/developer-tools/visual-studio/overview/index.html) enabled me to select an ODP.NET data source in Visual Studio 2010 and in Business Intelligence Development Studio (VS 2008 shell). I haven't used Report Builder.