Mapping syntax

Mapping defines how the gateway replicates tables by assigning data to appropriate fields in the ObjectServer. The map definition file defines how the gateway maps data received from Amdocs CRM to the Status, Journal, and Details tables within the ObjectServer. Mapping the configuration files for the Gateway for Amdocs CRM must use the following syntaxes.

Use the following syntax when configuring the amdocscrm.rdrwtr.tblrep.def file:

REPLICATE ALL FROM TABLE 'alerts.status'
        USING MAP 'StatusMap'
        FILTER WITH 'LogTicket=1'
        AFTER IDUC DO 'TTState=0';

REPLICATE ALL FROM TABLE 'alerts.journal'
        USING MAP 'JournalMap';

Use the following syntax when configuring the amdocscrm.map file:

CREATE  LOOKUP SeverityTable (
        {5 , 'High'})   
DEFAULT = 'Medium' ;

CREATE  LOOKUP StatusTable (
        {0 , 'Solved Pending Confirmation'})
DEFAULT = '' ;


CREATE MAPPING StatusMap
(
 'alt_first_name' = 'Netcool' ON INSERT ONLY,
 'alt_last_name'  = 'OMNIBUS' ON INSERT ONLY,
 'phone_num'      = '(000)000-0000)' ON INSERT ONLY,
 'case_type_lvl1' = 'Incident' ON INSERT ONLY,
 'creation_time'  =  TO_TIME('@FirstOccurrence') ON INSERT ONLY,
 'case_reporter2contact:contact:first_name' = 'Anonymous' ON INSERT ONLY,
 'case2address:address:address'= '111 Main Street' ON INSERT ONLY,
 'case_reporter2site:site:name' = 'Unknown' ON INSERT ONLY,
 'respsvrty2gbst_elm' = Lookup('@Severity','SeverityTable'),
 'title' = "Netcool Alert:" + '@Summary' ON INSERT ONLY,
 'STATUS' = Lookup('@Severity','StatusTable'),
 'TTNumber'         =    '@TTNumber'
);

CREATE MAPPING JournalMap
(
        'Chrono'                =       '@Chrono',      
        'description'           =       TO_STRING('@Text1') + TO_STRING('@Text2') 
+ TO_STRING('@Text3'
);

The gateway handles mapping relationships in the amdocscrm.map file by populating the mapping field with the information gathered by the parameters set after the colon. For example

case_reporter2contact:contact:first_name' = 'Anonymous' ON INSERT ONLY,

In this example the casereporter2contact field is populated by the contact table row mapped to the filter first_name='Anonymous', thereby populating the casereporter2contact field with anonymous.