What is data source in SSRS?

828    Asked by EdythFerrill in SQL Server , Asked on Nov 28, 2019
Answered by Edyth Ferrill

Data Source: In order to power any report developer must need to find a way to gather the data. As of today, we can store/gather in multiple data storage technologies like RDBMS, Cloud, Big-Data etc. Every time when we create a report in SSRS, we can connect to these data storage thus creating a data source in SSRS. We can then either create our own query to fetch the data from these storages or we can use existing created objects like procedure/views from underlying data sources to fetch the data.

As of today, we can connect to multiple data sources like Azure, SSAS, Oracle, SAP, Teradata etc.



Your Answer

Interviews

Parent Categories