iCore Events via the database
iCore Process Server contains a database table called TblExternalEvent. If you insert a post to the table, a trigger is started. The trigger creates an event via RemoteInput-object.
Before you can use the trigger in the database table to create events, it must be properly configured.
TblExternalEvent
The database table contains the following field for entry:
| Field name | Data type |
|---|---|
| fldEventTypeName | nvarchar (1024) |
| fldParams | nvarchar (1024) |
| fldUserName | nvarchar (1024) |
| fldPassword | nvarchar (1024) |
You also find the following fields, which are automatically filled in:
| Field name | Data type |
|---|---|
| fldStatus | nvarchar (1024) |
| fldExternalEventId | int |
| fldCreatedDateTime | datetime |
| fldStatusDateTime | datetime |
Trigger configuration
To be able to create iCore events via the database, one of the following conditions must be met:
- iCore is installed on the computer with the SQL-server.
- the RemoteInput-object has been registered on the iCore computer via DCOM from the SQL-server computer.