Edit this page

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 any more

  • 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 permissions for the Data Connections View or they must be assigned the corresponding role - see User Roles.

Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy