reporting-services - 如何在ssrs中添加oracle数据源

Question

在安装了包括报表服务在内的所有功能之后，我已经安装了 SQL Server 2012。我转到报表管理器链接并想添加新数据源，但在数据源类型中只有 Microsoft SQL Server，我想添加 Oracle 数据源。

我以其他方式轻松连接到 Business Inteligence Studio 中的 Oracle 数据源，但我无法将报告文件 ( .rdl ) 部署到我的报告管理器，因为它给了我一条错误消息:

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.

有谁知道如何解决这个问题？

Answer 1

您应该在托管 SSRS 实例的服务器上安装适用于 Oracle 的 .NET Framework 数据提供程序，以便能够以 Oracle 数据库为目标。
Here是在 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.

来源: Oracle Connection Type (SSRS)

有用的资源:

Using the .NET Framework Data Provider for Oracle

How to use Reporting Services to configure and to access an Oracle data source

如果您使用的是 express 版 SQL Server，则不支持 Oracle 数据源:

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

来源: Features Supported by Reporting Services in SQL Server Express

它也适用于 SSRS 2012 Express，如 this post 中所述.