There are 3 basic ways you can tell the information is changed in Solomon.   

1)      Time Based Queries - Build queries into the data that compare the last update time stamp on data with the last time the query was run. 

2)      Export and Compare - Use SQL DTS to scheduled exports of the relevant Solomon info into shadow tables and then compare the changes. 

3)      Triggers - Put triggers on the relevant tables in Solomon to publish changes as they occur. 

We have seen companies try all three methods.  We use method 3.  Triggers are placed on the correct pieces of information in Solomon.  The real trick is to know what to trigger on and what to filter out.  This took building a team of Solomon experts from Microsoft, Plumbline and our own team as most of this type of work touches the undocumented aspects of Solomon.  We are always monitoring our testing systems to see what global operations fire the triggers when in fact they are not doing actual updates to information relevant to our process.