Friday, November 08, 2013

SSRS Interview: Shared Datasource

A shared data source is a set of data source connection properties that can be referenced by multiple reports, models, and data-driven subscriptions that run on a Reporting Services report server. Shared data sources provide an easy way to manage data source properties that often change over time. If a user account or password changes, or if you move the database to a different server, you can update the connection information in one place.
Shared data sources are optional for reports and data-driven subscriptions, but required for report models. If you plan to use report models for ad hoc reporting, you must create and maintain a shared data source item to provide connection information to the model.

A name that identifies the item within the report server folder hierarchy.
A description that appears with the item in Report Manager
when you view the contents of the folder.
Connection type
The data processing extension used with the data source.
You can only use data processing extensions that are deployed on the report server.
Connection string
The connection string for the database. 
Credential type
Specifies how credentials are obtained for the connection and
 whether they are to be used after the connection is made.

A shared data source does not contain query information used to retrieve data. The query is always kept within a report definition.

Check below link for more details:

No comments:

Post a Comment