What is the difference between Shared Data Source and Embedded Data Source in SSRS Report - SSRS Interview Questions

What is Data Source?

Data Source is a set of data source connection properties. When we create data source, we need to provide below information
Name: Name for the Data Source
Description: Optional, Good idea to provide
Connection Type:  Such as Microsoft SQL Server, Oracle, OLE DB and ODBC etc.
Connection String: Provide the Connection String for Data Provider
Credential Type: Specifies how the credentials are obtained for connection

What is Shared Data Source?

A Data Source that can be used by multiple reports is called Shared Data Source.

What is Embedded Data Source?

The Data Source which is created in a report and can only be used for that report is called embedded Data Source. If non of other report/s need to connect to the data source, it is Ok to create embedded data source but if there is any possibility in future other report/s might use that data source, If yes then it is good idea to create Shared Data Source.

1 comment:

  1. Additionally, their flexibility and willingness to make requested changes made for an ideal partnership. IT Services