Adding a Data Source

A data source query specifies a metric. Create the metric you want to use before adding the data source.

Procedure

  1. In TIBCO BusinessEvents Studio Explorer, select the metric for which you want to add a data source. (Or you can select it in the wizard.) Click the New Data Source toolbar button.
  2. At the New Data Source wizard, name the data source and optionally provide a description. Select a metric if you did not already do so. You can also add and edit descriptions in the Data Source editor. Click Next.
  3. In the Query field of the New Data Source wizard, a simple query SELECT clause is preconfigured, based on the selected metric, for example:
       select * from /Dashboards/M_Accounts
  4. If you want to specify conditions, do the following:
    • Specify WHERE clause conditions using one or more fields of the metric specified in the SELECT clause, and a value. For example:

      where Balance > 5000.00

    • To specify a value as a parameter, prefix the parameter name you want to use with a dollar ($) sign, for example:

      where Balance > $minBalance

      The parameter name appears in the Params section of the wizard page. The metric field data type is automatically used.

  5. Click Finish. You see the data source editor showing the configured data source. Details you entered in the wizard are saved automatically.

Result

The data source is now ready to use. You can specify it while configuring dashboard components.