Data Connections Management
The Data Connections View is a centralized place from which you can manage the connection strings of the reports' SQL data sources. In this way by using a named connection string you can easily change the location of the database without actually modifying the report definitions. The view also displays read-only Business Object data connections which you can use inside a report. For more information on using business objects as report data sources refer to Business Objects Management.
The Data Connections View provides the following functions:
-
Add a data connection - a new data connection is defined by a name, a description, a data provider and a connection string
Data connections with duplicate names are not allowed.
Edit a data connection - the properties of an existing data connection can be modified at any time
- Delete a data connection - you can delete an existing data connection when it is not used anymore
- Copy a data connection - to create a similar to an existing connection you can simply copy the source connection and modify its properties
- Search by Name, Data Provider, or Connection String. For more information, see Search
In order to read, write, or modify connection strings from the Report Server or from the Standalone Report Designer, the user must have permission for the Data Connections View or they must be assigned the corresponding role - see User Roles.