DB Report Mediator

The dbreport mediator is very similar to the dblookup mediator, but writes information to a Database, using the specified insert SQL statement.

DBReport mediator options

Figure 1: DBReport options

DBReport mediator options field descriptions,

Data sources

Carbon Datasource

If existing Carbon data source is chosen, clicking "Load Data Sources" will give the available datasource. Then a data source can be selected.

Data Source

Figure 2 : Existing Datasources

External

Like in Pool connection data source configuration properties should be specified.

Data Source

Figure 3: External Datasources

Adding properties

Properties can be add to the DBReport Mediator by clicking Add Property, then the configuration UI appears.

Figure 4: Adding a property

Property field descriptions,

Adding SQL statements

  1. SQL Statements can be added by clicking Add Statement link.
  2. More than one statement may be specified.

Figure 5: Adding SQL statements