Skip to content

Oracle Database Triggers and FME Server for Task Tracking

Date
Friday, January 16, 2015
Presenters
Jeff Hobbs, San Jose Water Company
City
San Francisco
Location
us
Event
FME World Tour 2015
Session Type
User
Industry
Utilities

Presentation Details

We have an number of GIS data maintenance tasks that require input from another department. For instance, when we modify a line valve marked as "critical" we need to notify the person that marked the valve "critical". To make sure the correct person is notified when we modify different GIS graphics, we have Oracle database triggers setup to call a FME Server workspace. The workspace in turn creates a task in a 3rd party task management tool.The task that is created includes a description of the change along with a Google map showing the location of the GIS graphic. This presentation will discuss the different technology pieces used to make this process work.