Updating 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

  7. Select OK to close the browse dialog.

  8. 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