An essential part of the Integration Framework is mapping relevant ActiveControl fields to the equivalent fields on any external ITSM system.
This is achieved using the table /BTI/TE_INT_MAPP. Ideally, this process will need to be undertaken before the framework can be used. For general fields the field should be entered complete with table name into field TEFIELDREF and the external fieldname must be entered in the EXTERNAL_REF field.
There is also the functionality to be able to reference any ActiveControl Custom fields the custom field ID’s would need to be added to TECUSTFIELD_REF, also multiple line itemed fields are able to be handled here such as text fields. Finally, on the mapping table there is a KEY_FIELD field this is used to hold the external system record key in general use a specific non display custom field on the task would be created for this purpose.
/BTI/TE_INT_MAPP – Integration Mapping
| Field | Description |
| EXTSYS_NO | Main external system identifier, this is the identifier of the system that you wish to integrate with we can have as many systems as we want. An example of this could be: 1 – Remedy 2 – Solution Manager 3 – Service Desk |
| EXTSYS_NAME | Full description of external system |
| TEFIELDREF | This is the Field that needs to be mapped to a field on the external system. This table name is required in the field as well. I.e. /BTI/TE_TASK-PRIORITY |
| EXTERNAL_REF | This is the fieldname that the frameworks calling web service needs to reference to map across the data. |
| KEY_FIELD | This field is the link between the ActiveControl record, in our task record we have set up a custom field which is hidden from view and in here we store the ID of the created record on the integrated system. |
| TECUSTFLD_REF | ID of Custom field to be mapped. |
| DEFAULT_VAL | Defaulted Value to be mapped over to the integrated system field. |
Complex Mapping
For complex mapping scenarios, a specific function module can be created on the ActiveControl domain controller to perform whatever mapping or transformation that may be required.
/BTI/TE_INT_FLDE – Mapping User Exits
| Field | _. Description |
|---|---|
| EXTSYS_NO | Main external system identifier, this is the identifier of the system that you wish to integrate with we can have as many systems as we want. An example of this could be: 1 – Remedy 2 – Solution Manager 3 – Service Desk |
| EXITFIELDNAME | External field that this refers to |
| EXITFUNCNAME | The function module to be executed to perform this exit |
Post your comment on this topic.