Delivery Data Source (Data-Driven Wizard)
Use this page to specify a data source that contains subscription data. Further on in the wizard, you will build a query that retrieves data from this data source. The following examples illustrate the kind of data you might need:
- Subscriber e-mail addresses (if you are using Report Server E-mail delivery).
- Data fields that can be mapped to report parameters. If you are preloading the cache for a parameterized report, the subscriber data source is most likely the same data source that provides data to the report.
- Values that specify subscriber preferences for rendering formats.
- Values that specify subscriber preferences for e-mail or file share delivery options.
Options
- Shared data source
Select a predefined shared data source that contains connection information for the subscription data source.
- Custom data source
Specify the data source type, connection string, and how to obtain credentials for connecting to the subscription data source at run time.
- Data source type
Data source type can be any data processing extension that is available on the report server.
Connection string
When defining a custom data source, specify the connection string to t he data source.The connection string syntax varies for each data source type. Specifying credentials on the connection string is not recommended because the values can be viewed in plain text by users who view this subscription information. For more information about connection strings, see Connecting to a Data Source.
Default
Click Default to use a default connection string. The default connection string is a connection to the data source that provides data to the report. The default connection string can be used whenever subscription data and report data are in the same database.If you are using the Null Delivery Provider with this subscription, you should use the default connection string.
After you click Default, the button label changes to Override. You can click Override to enable the connection string text box to type in a specific string.
- Credentials supplied by the user running the report
Do not choose this option. It is not valid for data-driven subscriptions.
Credentials stored securely on the report server
Choose stored credentials when defining a data-driven subscription. Although other options are enabled on the page, only stored credentials or no credentials can be used to access the subscription data source when the subscription is processed.Domain accounts must be specified in this format: <domain>\<user>.
If you are using Windows credentials, select the checkbox "Use as Windows credentials when connecting to the data source".
You can also use database credentials (for example, a SQL Server login). Specify the user name and password, and clear the "Use as Windows credentials" checkbox.Stored credentials are encrypted in the report server database. Storing credentials allows the report server to retrieve credentials for unattended report execution. For more information, see Specifying Credential and Connection Information.
- Windows integrated security
Do not choose this option. It is not valid for data-driven subscriptions.
- Credentials are not required
Select this option when the data source does not require credentials or if you are specifying credentials in the connection string To use this option, you must configure the unattended execution account. For more information, see Configuring an Account for Unattended Report Processing.
For more information about the next page in the wizard, see Delivery Query Page (Data-Driven Subscription Wizard).
See Also
Other Resources
Shared Data Sources and Report-Specific Data Sources
Data Sources Supported by Reporting Services
Storing Encrypted Report Server Data