Add a Data Source

A custom data source or a Cityworks SQL data source can be added to connect to database information. The steps for adding a data set differ depending on the version you have installed. Select the version you are on below to complete the task:

IMPORTANT: In Respond 5.9, the Data Sources section is hidden in the Report Designer.

Starting in Respond 5.3, the data source cannot be edited. If a data source needs to be changed, it must be removed and a new data source must be added.

TIP: Starting in 23.3, the data source is automatically populated based on the site information.

  1. Open the Report Designer.
  1. Click the Data tab and click Add.

  1. Enter the Name of the data source.
  1. Select the Provider.
  1. Enter the Server and select the Database.
  1. Select Use Integrated Security if desired.
  1. Enter the Username and Password.
  1. Click Test Connection to validate the data source.
  1. Click Add.

After the data source is connected, a data set needs to be added as well.

The data source is automatically added if you add the DefaultDataSet first. See Add a Data Set for more information. Starting in Respond 5.3, the data source cannot be edited. If a data source needs to be changed, it must be removed and a new data source must be added.

TIP: Starting in 23.3, the data source is automatically populated based on the site information.

  1. Open the Report Designer.
  1. Click the Data tab and click Add.

  1. Enter the Name of the data source.

The Provider is set to Shared Reference.

  1. Select the Reference:
  • Cityworks Resources: Select to add a custom data source that allows access to attachments that can be added to reports.
  • Cityworks SQL: Select to connect to the SQL database of your site.
  1. Click Test Connection to validate the data source.
  1. Click Add.

After the data source is connected, a data set needs to be added as well.