Friday, November 08, 2013

SSRS Interview: Different types of datasources

Reporting Services retrieves report data from data sources through a modular and extensible data layer that uses data processing extensions.
To retrieve report data from a data source, you must select a data processing extension that supports the type of data source, the version of software running on the data source, and the data source platform (32-bit or 64-bit x64).
When you deploy Reporting Services, a set of data processing extensions are automatically installed and registered on both the report authoring client and on the report server to provide access to a variety of data source types.
Reporting Services installs the following data source types:

  • Microsoft SQL Server
  • Microsoft SQL Server Analysis Services for MDX, DMX, Microsoft PowerPivot, and tabular models
  • Microsoft Windows Azure SQL Database
  • SQL Server Parallel Data Warehouse
  • Oracle
  • SAP NetWeaver BI
  • Hyperion Essbase
  • Microsoft SharePoint List
  • Teradata
  • OLE DB
  • ODBC
  • XML
For more detail read from below link

No comments:

Post a Comment