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.

Adding a DBReport mediator

Go to Advanced and click DBReport to add a DBLookup mediator. Figure 1 illustrate this,

Figure 1: Adding a DBReport mediator

DBReport mediator options

Clicking on the DBReport mediator created as in figure 1 will open up DBReport mediator specific options. Figure 2 illustrate this,

Figure 2: DBReport options

DBReport mediator options field descriptions,

Adding properties

Figure 3 shows the screen after clicking Add Property,

Figure 3: Adding a property

Property field descriptions,

Adding SQL statements

  1. Click Add Statement link shown in figure 3 and it'll open up the screen where you could enter SQL statement option. This is shown in figure 4.
  2. More than one statement may be specified.

Figure 4: Adding SQL statements