locked
'Oracle' data extension not registered RRS feed

  • Question

  • Dears,

    Kindly I have oracle database in our company and we need to create reports using reporting server. I use sql server 2016 with data tool 2015. but when assign provider to be Oracle edit button is being unable and if I write the connection string the following error appear for me.

    kindly help me to solve this error.

    Saturday, June 25, 2016 11:26 AM

Answers

  • Use the right ORACLE data provider.

    Basic requirements to configure an Oracle data source

    To access an Oracle data source in a report, you must first configure the Oracle data source. To configure an Oracle data source, you must complete both of the following steps:
    • Install the Oracle client tools on the report server computer that hosts the report, and then restart Microsoft Internet Information Services (IIS).
    • Install the driver that is used as the provider to connect to the Oracle data source. By default, the drivers are installed with Oracle client tools, with Microsoft Data Access Components (MDAC), or with Microsoft .NET Framework.

    https://msdn.microsoft.com/en-ca/library/ms159219.aspx

    Oracle Data Processing Extension

    When you select data source type Oracle, you are selecting a Reporting Services data processing extension that extends the .NET Framework Data Provider for Oracle. The Oracle data source wraps and extends the System.Data.OracleClient classes needed by Reporting Services. To retrieve report data from an Oracle database, your administrator must install Oracle client tools. This data provider uses the Oracle Call Interface (OCI) from Oracle 8i Release 3 as provided by Oracle Client software. The client application version must be 8.1.7 or later. These tools must be installed on the report authoring client to preview reports and on the report server to view published reports.

    Named parameters are supported by this extension. For Oracle version 9 or later, multivalue parameters are supported. For unnamed parameters that are position-dependent, use the OLE DB data processing extension with the data provider Microsoft OLE DB Provider for Oracle. For more information about configuring Oracle as a data source, see How to use Reporting Services to configure and to access an Oracle data source. For more information about additional permissions configuration, see How to add permissions for the NETWORK SERVICE security principal in the Microsoft Knowledge Base.

    You can retrieve data from stored procedures with multiple input parameters, but the stored procedure must return only one output cursor. For more information, see the Oracle section in Retrieving Data Using the DataReader.

    For more information, see Oracle Connection Type (SSRS). For more information about the associated query designer, see Query and View Designer Tools (Visual Database Tools) and Graphical Query Designer User Interface.

    You can also create models based on an Oracle database.

    https://support.microsoft.com/en-us/kb/834305




    • Edited by MLTC Monday, June 27, 2016 1:32 PM
    • Marked as answer by Amer AL_Tahawy Saturday, July 2, 2016 8:51 AM
    Monday, June 27, 2016 1:31 PM

All replies

  • Use the right ORACLE data provider.

    Basic requirements to configure an Oracle data source

    To access an Oracle data source in a report, you must first configure the Oracle data source. To configure an Oracle data source, you must complete both of the following steps:
    • Install the Oracle client tools on the report server computer that hosts the report, and then restart Microsoft Internet Information Services (IIS).
    • Install the driver that is used as the provider to connect to the Oracle data source. By default, the drivers are installed with Oracle client tools, with Microsoft Data Access Components (MDAC), or with Microsoft .NET Framework.

    https://msdn.microsoft.com/en-ca/library/ms159219.aspx

    Oracle Data Processing Extension

    When you select data source type Oracle, you are selecting a Reporting Services data processing extension that extends the .NET Framework Data Provider for Oracle. The Oracle data source wraps and extends the System.Data.OracleClient classes needed by Reporting Services. To retrieve report data from an Oracle database, your administrator must install Oracle client tools. This data provider uses the Oracle Call Interface (OCI) from Oracle 8i Release 3 as provided by Oracle Client software. The client application version must be 8.1.7 or later. These tools must be installed on the report authoring client to preview reports and on the report server to view published reports.

    Named parameters are supported by this extension. For Oracle version 9 or later, multivalue parameters are supported. For unnamed parameters that are position-dependent, use the OLE DB data processing extension with the data provider Microsoft OLE DB Provider for Oracle. For more information about configuring Oracle as a data source, see How to use Reporting Services to configure and to access an Oracle data source. For more information about additional permissions configuration, see How to add permissions for the NETWORK SERVICE security principal in the Microsoft Knowledge Base.

    You can retrieve data from stored procedures with multiple input parameters, but the stored procedure must return only one output cursor. For more information, see the Oracle section in Retrieving Data Using the DataReader.

    For more information, see Oracle Connection Type (SSRS). For more information about the associated query designer, see Query and View Designer Tools (Visual Database Tools) and Graphical Query Designer User Interface.

    You can also create models based on an Oracle database.

    https://support.microsoft.com/en-us/kb/834305




    • Edited by MLTC Monday, June 27, 2016 1:32 PM
    • Marked as answer by Amer AL_Tahawy Saturday, July 2, 2016 8:51 AM
    Monday, June 27, 2016 1:31 PM
  • Hello,

    Which Edition of SSRS are you using? Is it the free Express Edition? If so see Features Supported by Reporting Services in SQL Server Express => Unsupported Features => "Analysis Services, Oracle, XML, SAP, SQL Server Integration Services (SSIS), OLE DB, and ODBC data sources are not supported"


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, June 27, 2016 6:23 PM