Pushing data from BMC Remedy AR System with SQL
All three BMC Remedy AR System workflow components-active links, filters, and escalations-can send data to external tables and even external databases using the Direct SQL action. The SQL command must be created by the administrator and entered into the SQL Command field on the If Action or Else Action tab. The AR System server performs no pre- or post-processing on the SQL command or the results. The administrator must make sure that the command is correct. When the action is triggered, the AR System server passes the SQL command directly to the SQL database server on which it is running. For more information about the Direct SQL action, see Direct SQL action.