Oracle 连接类型(SSRS 和 Power BI 报表服务器)Oracle Connection Type (SSRS & Power BI Report Server)
11/03/2020
本文内容
若要在报表中使用来自 Oracle 数据库的数据,你必须拥有一个基于 Oracle 类型的报表数据源的数据集。To use data from an Oracle database in your report, you must have a dataset that's based on a report data source of type Oracle. 此内置数据源类型直接使用 Oracle Data Provider,并且需要 Oracle 客户端软件组件。This built-in data source type uses the Oracle Data Provider directly and requires an Oracle client software component. 本文介绍如何下载和安装 Reporting Services、Power BI 报表服务器、报表生成器和 Power BI Desktop 的驱动程序。This article explains how to download and install drivers for Reporting Services, Power BI Report Server, Report Builder, and Power BI Desktop.
使用本文中的信息来生成一个数据源。Use the information in this article to build a data source.
重要
以下命令使用 Oracle 的 OraProvCfg.exe 工具注册 Oracle 的托管和非托管 ODP.NET 驱动程序,在此作为示例展示如何与上述 Microsoft 产品一起使用。The following commands that use Oracle's OraProvCfg.exe tool to register Oracle's Managed and Unmanaged ODP.NET drivers are provided as examples for use with the above Microsoft products. 若要配置特定于环境的 ODP.NET 驱动程序,可能需要联系 Oracle 支持团队或参考 Oracle 文档以配置用于 .NET 的 Oracle 数据提供程序。For the configuration of the ODP.NET drivers specific to your environment, you may need to contact Oracle support or reference Oracle's documentation for Configuring Oracle Data Provider for .NET.
用于报表服务器的 64 位驱动程序64-bit drivers for the report servers
使用 Oracle ODAC 驱动程序 12.2 和更高版本时,只需执行以下步骤。You only need the following steps when using Oracle ODAC drivers 12.2 and later. 否则它们默认安装到新 Oracle 主安装的非计算机范围配置中。Otherwise, they install by default to a non-machine-wide configuration for a new Oracle home installation. 以下步骤假设已将 ODAC 18.x 文件安装到 c:\oracle64 文件夹。These steps assume you've installed the ODAC 18.x files to the c:\oracle64 folder.
分页 (RDL) 报表使用托管的 ODP.NETPaginated (RDL) Reports use Managed ODP.NET
Power BI 报表服务器和 SQL Server Reporting Services