Update the Database Source

Next, we will start using the new trigger to cause a refresh for a data source.

  1. In Workbench, go to Data Connectivity > Databases.
  2. Open SQL Connections > Northwind > Employees.
  3. Go to Data Refresh.
  4. Change the Refresh Type to By Triggers.
  5. Select Click here to add new item.
  6. Then browse for the new trigger that you created:

browseTrigger.png

  1. Select OK to close the browse dialog.
  2. Then select Apply.

The database source is now configured to use the new trigger to force a data refresh, as shown here:

db_refresh.png