Data Source supported by SQL Server Reporting Services 2014

When we deploy Reporting Services, the set of data processing extension are automatically installed and register on report authoring client as well as report server to provide verity of data source types.

 

SSRS installed following data source type

·        Microsoft SQL server

·        Microsoft SharePoint List

·        Oracle

·        XML

·        Microsoft SQL Server Analysis Services : MDX,DMX, Microsoft Power Pivot, and tabular models

·        Microsoft Azure SQL Database

·        SQL Server Parallel Data Warehouse

·        SAP NetWeaver BI

·        Hyperion Essbase

·        Teradata

·        OLE DB

·        ODBC

 

Custom data processing extension and standard.NET data provider can be installed and register by System administrators manually. Data processing extensions and providers must be installed on report server as well as report authoring client to process and view the report.