Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. SQL Server
  3. Question
SQL Server

What is data source in SSRS?

Asked by Edyth Ferrill Nov 28, 2019 1.4K views 1 answer
Share

Your answer

1 Answer

Edyth Ferrill Latest answer

Answered on Nov 21, 2019

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.


Was this helpful?

More SQL Server discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.