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.
Part
|
Description
|
|---|---|
Name
|
A name that identifies the item within the report server folder hierarchy.
|
Description
|
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