Data Connections Management

The Data Connections View is a centralized place from which you can manage the connection strings of the reports' 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 data connections view provides the following functions:

  • Search by Name, Data Provider or Connection String. For more information, see Search

  • Add a data connection

A new data connection is defined by a name, a description, a data provider and a connection string.

Make sure the connection string is referencing SQL server with a non local address, so the users can edit reports in the report designer. To have access to read/write/modify connection strings, including from the Standalone Report Designer, the user must have permissions for the Data Connections View or the user must be in the corresponding role - see User Roles. Without write permissions for the Data Connections View, the user will be able to publish a report with connection strings hard-coded in the definition.

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.