Oracle XML-type RRS feed

  • Question

  • Hello,


    is there any way SSRS 2008 (or sql server 2008) can handle XMLtype from Oracle?


    kind regards,


    Henk-Jan Buwalda

    Tuesday, July 5, 2011 7:47 AM


  • Hi Henk-Jan,

    Reporting Services provides data extensions that support the following data source types to connect to external database. Such as Microsoft SQL Server, Microsoft SQL, Server Analysis Services, OLE DB, Oracle, ODBC, Report Server Model, SAP NetWeaver BI, Hyperion Essbase, Teradata, XML. For more information, please see: Data Sources Supported by Reporting Services.

    In order to retrieve data from an Oracle data source, Reporting Services provides two ways to connect to an Oracle relational database: the .NET Framework Managed Provider for Oracle data processing extension or the OLE DB data processing extension that uses the Oracle data provider. For more information, please see: How to: Retrieve Data from an Oracle Data Source.

    If you have any more questions, please feel free to ask.

    Bin Long


    • Marked as answer by Elvis Long Tuesday, July 12, 2011 6:08 AM
    Wednesday, July 6, 2011 6:47 AM