Skip to content

Commit 4516588

Browse files
maggiesMSFTmaggiesMSFT
committed
update link text to data-connections-etc
1 parent 1d2ee3b commit 4516588

32 files changed

Lines changed: 39 additions & 39 deletions

‎docs/reporting-services/report-builder/report-design-view-report-builder.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -94,7 +94,7 @@ ms.author: maggies
9494

9595
- [Images (Report Builder and SSRS)](../../reporting-services/report-design/images-report-builder-and-ssrs.md)
9696

97-
- [Data Connections, Data Sources, and Connection Strings (Report Builder and SSRS)](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)
97+
- [Create data connection strings - Report Builder & SSRS](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)
9898

9999
- [Report Embedded Datasets and Shared Datasets (Report Builder and SSRS)](../../reporting-services/report-data/report-embedded-datasets-and-shared-datasets-report-builder-and-ssrs.md)
100100

‎docs/reporting-services/report-data/analysis-services-connection-type-for-dmx-ssrs.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -43,6 +43,6 @@ ms.author: maggies
4343
## See Also
4444
[Data Mining Solutions](https://docs.microsoft.com/analysis-services/data-mining/data-mining-solutions)
4545
[Query Design Tools (SSRS)](../../reporting-services/report-data/query-design-tools-ssrs.md)
46-
[Data Connections, Data Sources, and Connection Strings (Report Builder and SSRS)](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)
46+
[Create data connection strings - Report Builder & SSRS](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)
4747

4848

‎docs/reporting-services/report-data/analysis-services-connection-type-for-mdx-ssrs.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -43,7 +43,7 @@ data source=<server name>;initial catalog=<database name>
4343

4444
- No credentials are required. To use this option, you must have the unattended execution account configured on the report server. For more information, see [Configure the Unattended Execution Account &#40;SSRS Configuration Manager&#41;](../../reporting-services/install-windows/configure-the-unattended-execution-account-ssrs-configuration-manager.md)
4545

46-
For more information, see [Data Connections, Data Sources, and Connection Strings &#40;Report Builder and SSRS&#41;](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md) or [Specify Credential and Connection Information for Report Data Sources](specify-credential-and-connection-information-for-report-data-sources.md).
46+
For more information, see [Create data connection strings - Report Builder & SSRS](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md) or [Specify Credential and Connection Information for Report Data Sources](specify-credential-and-connection-information-for-report-data-sources.md).
4747

4848

4949
## <a name="Query"></a> Queries

‎docs/reporting-services/report-data/bind-a-report-or-model-to-a-shared-data-source-ssrs.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -59,7 +59,7 @@ ms.author: maggies
5959
## See Also
6060
[Upload Documents to a SharePoint Library &#40;Reporting Services in SharePoint Mode&#41;](../../reporting-services/report-server-sharepoint/upload-documents-to-a-sharepoint-library-reporting-services-in-sharepoint-mode.md)
6161
[Create and Manage Shared Data Sources &#40;Reporting Services in SharePoint Integrated Mode&#41;](https://msdn.microsoft.com/library/2d3428e4-a810-4e66-a287-ff18e57fad76)
62-
[Data Connections, Data Sources, and Connection Strings &#40;Report Builder and SSRS&#41;](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)
62+
[Create data connection strings - Report Builder & SSRS](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)
6363
[Data Sources Supported by Reporting Services &#40;SSRS&#41;](../../reporting-services/report-data/data-sources-supported-by-reporting-services-ssrs.md)
6464

6565

‎docs/reporting-services/report-data/convert-data-sources-report-builder-and-ssrs.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -57,6 +57,6 @@ ms.author: maggies
5757

5858
## See Also
5959
[Manage Report Data Sources](../../reporting-services/report-data/manage-report-data-sources.md)
60-
[Data Connections, Data Sources, and Connection Strings &#40;Report Builder and SSRS&#41;](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)
60+
[Create data connection strings - Report Builder & SSRS](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)
6161

6262

‎docs/reporting-services/report-data/create-and-modify-embedded-data-sources.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -29,7 +29,7 @@ ms.author: maggies
2929

3030
2. Specify a connection string using one of the following alternatives:
3131

32-
- Type the connection string directly in the **Connection string** text box. For a list of example connection strings, see [Data Connections, Data Sources, and Connection Strings &#40;Report Builder and SSRS&#41;](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md).
32+
- Type the connection string directly in the **Connection string** text box. For a list of example connection strings, see [Create data connection strings - Report Builder & SSRS](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md).
3333

3434
- Click the expression (**fx)** button to create an expression that evaluates to a connection string. In the **Expression** dialog box, type the expression in the Expression pane. [!INCLUDE[clickOK](../../includes/clickok-md.md)]
3535

‎docs/reporting-services/report-data/create-modify-and-delete-shared-data-sources-ssrs.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,7 @@ ms.author: maggies
3131
|Name|A name that identifies the item within the report server folder hierarchy.|
3232
|Description|A description that appears with the item in the web portal when you view the contents of the folder.|
3333
|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. For more information about data processing extensions included with [!INCLUDE[ssRSnoversion](../../includes/ssrsnoversion-md.md)], see [Data Sources Supported by Reporting Services &#40;SSRS&#41;](../../reporting-services/report-data/data-sources-supported-by-reporting-services-ssrs.md).|
34-
|Connection string|The connection string for the database. For more information and to view examples of connection strings to frequently used data sources, see [Data Connections, Data Sources, and Connection Strings &#40;Report Builder and SSRS&#41;](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md).|
34+
|Connection string|The connection string for the database. For more information and to view examples of connection strings to frequently used data sources, see [Create data connection strings - Report Builder & SSRS](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md).|
3535
|Credential type|Specifies how credentials are obtained for the connection and whether they are to be used after the connection is made. For more information, see [Specify Credential and Connection Information for Report Data Sources](../../reporting-services/report-data/specify-credential-and-connection-information-for-report-data-sources.md).|
3636

3737
A shared data source does not contain query information used to retrieve data. The query is always kept within a report definition.
@@ -163,7 +163,7 @@ Deleting a shared data source deactivates any report, model, or data-driven subs
163163
164164
4. In **Data Source Type**, select the type of data source from the list. For more information, see [Data Sources Supported by Reporting Services &#40;SSRS&#41;](../../reporting-services/report-data/data-sources-supported-by-reporting-services-ssrs.md).
165165
166-
5. In **Connection String**, specify a pointer to the data source and any other settings that are necessary for establishing a connection to the external data source. The type of data source you are using determines the syntax of the connection string. For more information and examples, see [Data Connections, Data Sources, and Connection Strings &#40;Report Builder and SSRS&#41;](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md).
166+
5. In **Connection String**, specify a pointer to the data source and any other settings that are necessary for establishing a connection to the external data source. The type of data source you are using determines the syntax of the connection string. For more information and examples, see [Create data connection strings - Report Builder & SSRS](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md).
167167
168168
6. In **Credentials**, specify how the report server obtains credentials to access the external data source. Credentials can be stored, prompted, integrated, or configured for unattended report processing.
169169
@@ -210,7 +210,7 @@ Deleting a shared data source deactivates any report, model, or data-driven subs
210210
For report models, the list of dependent items shows the reports that were created in Report Builder. For shared data sources, the dependent items list can include both reports and report models.
211211
212212
## See Also
213-
[Data Connections, Data Sources, and Connection Strings &#40;Report Builder and SSRS&#41;](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)
213+
[Create data connection strings - Report Builder & SSRS](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)
214214
[Manage Report Data Sources](../../reporting-services/report-data/manage-report-data-sources.md)
215215
[Configure Data Source Properties for a Paginated Report](../../reporting-services/report-data/configure-data-source-properties-for-a-report-report-manager.md)
216216

‎docs/reporting-services/report-data/embedded-and-shared-datasets-report-builder-and-ssrs.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -57,6 +57,6 @@ ms.author: maggies
5757
[Create a Shared Dataset or Embedded Dataset &#40;Report Builder and SSRS&#41;](../../reporting-services/report-data/create-a-shared-dataset-or-embedded-dataset-report-builder-and-ssrs.md)
5858
[Report Datasets &#40;SSRS&#41;](../../reporting-services/report-data/report-datasets-ssrs.md)
5959
[Dataset Fields Collection &#40;Report Builder and SSRS&#41;](../../reporting-services/report-data/dataset-fields-collection-report-builder-and-ssrs.md)
60-
[Data Connections, Data Sources, and Connection Strings &#40;Report Builder and SSRS&#41;](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)
60+
[Create data connection strings - Report Builder & SSRS](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)
6161

6262

‎docs/reporting-services/report-data/hyperion-essbase-connection-type-ssrs.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,7 @@ Data Source=https://localhost:13080/aps/XMLA; Initial Catalog=Sample
3131

3232
After you publish your report, you may need to change the credentials for the data source so that when the report runs on the report server, the permissions to retrieve the data are valid.
3333

34-
For more information, see [Data Connections, Data Sources, and Connection Strings &#40;Report Builder and SSRS&#41;](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md) or [Specify Credential and Connection Information for Report Data Sources](specify-credential-and-connection-information-for-report-data-sources.md).
34+
For more information, see [Create data connection strings - Report Builder & SSRS](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md) or [Specify Credential and Connection Information for Report Data Sources](specify-credential-and-connection-information-for-report-data-sources.md).
3535

3636

3737
## <a name="Query"></a> Queries

‎docs/reporting-services/report-data/manage-report-data-sources.md‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -39,7 +39,7 @@ ms.author: maggies
3939
|Property|Description|How to manage it|
4040
|--------------|-----------------|----------------------|
4141
|Data source type|Determines which report server data processing extension to use on the external data. Examples of data processors include SQL Server, Analysis Services, and Oracle.|The data source type is a managed property because it is configurable. However, you should only configure a data source type if you are creating a new shared data source.<br /><br /> Do not change the data source type in the property pages of a published report or model, as doing so will almost certainly invalidate the connection. It is unlikely that the data structures required by a report or model will be identical on a different data platform.|
42-
|Connection string|Establishes the initial connection to an external data source. A report can use static or dynamic connection strings.<br /><br /> A *static connection string* is a set of values that the report always uses to connect to the same data source each time the report runs.<br /><br /> A *dynamic connection string* is an expression that you build into the report, allowing the user to select which data source to use at run time. You must build the expression and data source selection list into the report when you create it in Report Designer.|Changing a connection string is useful if you move a data source to another computer, or if you created reports using test data but you want to deploy the reports with a production database.<br /><br /> You can manage a static connection string by replacing the original string with a different one.<br /><br /> To manage a dynamic connection string in the web portal or on a SharePoint site, you are limited to replacing it with a static one. You cannot edit the expression itself, nor change the data source selection list. To change the expression or valid values list, you must edit the report definition and republish it to the report server. For more information, see [Data Connections, Data Sources, and Connection Strings &#40;Report Builder and SSRS&#41;](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md).|
42+
|Connection string|Establishes the initial connection to an external data source. A report can use static or dynamic connection strings.<br /><br /> A *static connection string* is a set of values that the report always uses to connect to the same data source each time the report runs.<br /><br /> A *dynamic connection string* is an expression that you build into the report, allowing the user to select which data source to use at run time. You must build the expression and data source selection list into the report when you create it in Report Designer.|Changing a connection string is useful if you move a data source to another computer, or if you created reports using test data but you want to deploy the reports with a production database.<br /><br /> You can manage a static connection string by replacing the original string with a different one.<br /><br /> To manage a dynamic connection string in the web portal or on a SharePoint site, you are limited to replacing it with a static one. You cannot edit the expression itself, nor change the data source selection list. To change the expression or valid values list, you must edit the report definition and republish it to the report server. For more information, see [Create data connection strings - Report Builder & SSRS](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md).|
4343
|Credentials|Provides the name and password of a user who has permission to read data from the data source.<br /><br /> If a data source does not support authentication (for example, if the data source is an XML file on the file system), you can configure the unattended execution account to allow the report server to connect to the external data source without passing credentials.|You can manage credentials by updating the user account or a password if it expired.<br /><br /> You can also change the way credentials are obtained (for example, prompting users to enter credentials at run time).<br /><br /> If you want to users to be able to subscribe to a report, you must configure the report to use stored credentials.|
4444

4545
## Creating and Using Shared Data Sources
@@ -55,11 +55,11 @@ ms.author: maggies
5555

5656
|Task|Tool|Link|
5757
|----------|----------|----------|
58-
|View examples of connection strings.||[Data Connections, Data Sources, and Connection Strings &#40;Report Builder and SSRS&#41;](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)|
58+
|View examples of connection strings.||[Create data connection strings - Report Builder & SSRS](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)|
5959
|Choose an approach for getting credentials to connect to a data source.||[Specify Credential and Connection Information for Report Data Sources](../../reporting-services/report-data/specify-credential-and-connection-information-for-report-data-sources.md)|
6060
|Add data source connection properties to a report definition (.rdl) file.|Report Designer|[Create an Embedded or Shared Data Source &#40;SSRS&#41;](https://msdn.microsoft.com/library/b111a8d0-a60d-4c8b-b00a-51644b19c34b)|
6161
|Add and link to a shared data source (.rds) file in report project.|Report Designer|[Create, Modify, and Delete Shared Data Sources &#40;SSRS&#41;](../../reporting-services/report-data/create-modify-and-delete-shared-data-sources-ssrs.md)|
62-
|Create a predefined list of data sources that users can select at run time. When a user requests a report, the report provides a list of data sources. The user must select which data source to use prior to running the report. To add a data source selection list to a report, you use an expression.<br /><br /> This is known as a dynamic data source connection.|Report Designer|[Data Connections, Data Sources, and Connection Strings &#40;Report Builder and SSRS&#41;](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)|
62+
|Create a predefined list of data sources that users can select at run time. When a user requests a report, the report provides a list of data sources. The user must select which data source to use prior to running the report. To add a data source selection list to a report, you use an expression.<br /><br /> This is known as a dynamic data source connection.|Report Designer|[Create data connection strings - Report Builder & SSRS](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)|
6363
|Create a shared data source item on a report server.|[Create, Modify, and Delete Shared Data Sources](create-modify-and-delete-shared-data-sources-ssrs.md) |
6464
|Store credentials as a prerequisite for creating subscriptions or report snapshots.|The web portal|[Store Credentials in a Reporting Services Data Source](../../reporting-services/report-data/store-credentials-in-a-reporting-services-data-source.md)|
6565
|Edit data source connection properties on a published report.|The web portal|[Configure Data Source Properties for a Report](../../reporting-services/report-data/configure-data-source-properties-for-a-report-report-manager.md)|
@@ -72,7 +72,7 @@ ms.author: maggies
7272
## See Also
7373
[Bind a Report or Model to a Shared Data Source &#40;SSRS&#41;](../../reporting-services/report-data/bind-a-report-or-model-to-a-shared-data-source-ssrs.md)
7474
[Store Credentials in a Reporting Services Data Source](../../reporting-services/report-data/store-credentials-in-a-reporting-services-data-source.md)
75-
[Data Connections, Data Sources, and Connection Strings &#40;Report Builder and SSRS&#41;](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)
75+
[Create data connection strings - Report Builder & SSRS](../../reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md)
7676
[Data Sources Supported by Reporting Services &#40;SSRS&#41;](../../reporting-services/report-data/data-sources-supported-by-reporting-services-ssrs.md)
7777
[Report Server Content Management &#40;SSRS Native Mode&#41;](../../reporting-services/report-server/report-server-content-management-ssrs-native-mode.md)
7878

0 commit comments

Comments
 (0)