What are different types of Data Sources available in SSRS - SQL Server Reporting Services(SSRS) Interview Questions and Answers

SQL Server Reporting Services can be use to retrieve data from different sources for reports. Below is the list of available data sources in SSRS

  • Microsoft SQL Server
  • Microsoft SQL Server Analysis Services for MDX, DMX, Microsoft Power Pivot, and tabular models
  • Microsoft Azure SQL Database
  • SQL Server Parallel Data Warehouse
  • Oracle
  • SAP NetWeaver BI
  • Hyperion Essbase
  • Microsoft SharePoint List
  • Teradata
  • OLE DB
  • ODBC
  • XML

When you create Data Source, the one of the properties you have to choose for your Data Source is type. You need to choose which data source type you would like to use for your Data Source. Here is how it look when you click type in Data Source Properties window

What type of Data Sources are available in SSRS - SSRS Interview Questions and Answers