Svi Sdk Technical Document

Transcript

    Part Number: STPD0083-0002   Version / Date: 3.6/ 03/07/12 Author: AC Page: 1/74Squire Technologies, 64 High WestStreet Dorchester Dorset DT1 1XA   SVI SQL Development Kit 2 nd  July 2012Document STPD0083-0002Version 3.7      Part Number: STPD0083-0002   Version / Date: 3.6/ 03/07/12 Author: AC Page: 2/74Squire Technologies, 64 High WestStreet Dorchester Dorset DT1 1XA   Table of Contents   1   INTRODUCTION 5   1.1   API overview 5   1.2   SQL Software Development Kit Overview 6   1.3   SQL Database Support 6   1.3.1   MYSQL format 6   1.4   Message Flow 6   1.4.1   Call Between Two Fixed SIP end points 7   1.4.2   Call Between SIP end point and SS7 ISUP Network 7   1.4.3   SIP Endpoint Registration / Invite Challenge 8   2   SQL API DEFINITION 9   2.1   Get Routing Information 9   2.1.1   Description 9   2.1.2   Input Parameter Summary 10   2.1.3   Input Parameter Details 12   2.1.4   Invocation From SQL command line 18   2.1.5   Output Parameters Summary 19   2.2   Generating Reports 35   3   CDR DEFINITION 38   3.1   CDR Function Parameters 39   3.2   CDR Stored Procedures 43   3.2.1   CDR_START 43   3.2.2   CDR_UPDATE 43   3.2.3   CDR_FINAL 43   4   REGISTER REQUEST 44   4.1.1   Description 44   4.1.2   Input Parameter Summary 44   4.2   Calculation of MD5 Authorisation for SIP 45   4.2.1   Invocation From SQL command line 48   4.2.2   Output Parameters Summary 49    Part Number: STPD0083-0002   Version / Date: 3.6/ 03/07/12 Author: AC Page: 3/74Squire Technologies, 64 High WestStreet Dorchester Dorset DT1 1XA   5   IMPLEMENTATION GUIDE 50 5.1   General Routing 50   5.1.1   Call Identification and Reference 50   5.1.2   Routing Out Calls 50   5.1.3   Identifying Outgoing Call Destination 50   5.1.4   Specifying Protocol Information 51   5.1.5   Rejecting an incoming call 51   5.1.6   Specifying Multiple Outgoing Routes 51   5.1.7   Contact Details 52   5.2   CDR 52   6   PREMIUM RATE INFORMATION 53   6.1   SQL Database Premium Rate Table 53   6.2   Radius Extensions 54   6.3   Meter Pulse Protocol Support 54   6.4   Message Flows 55   6.4.1   Call with MPM Applied On Incoming Leg 55   6.4.2   Call with MPM Received On Outgoing Leg 56   7   SVI CONFIGURATION 57   7.1   Setting up SQL Access 57   7.2   Setting up Off Peak Times 57   7.3   Setting Up digit manipulation of Called Party Number 57   7.4   Setting Up Routing Criteria to perform SQL Lookup 57   7.5   Adding Radius Server 57   8    ADVANCED PREMIUM RATE OPERATION 58   8.1   Get Rate Req 58   8.1.1   Description 58   8.1.2   Call with MPM Applied On Incoming Leg For Get Rate Req 60   9   MAP / IS41 SERVICES 62   9.1   DIP ServiceLNP Request 62   9.1.1   Input Parameters 62   9.1.2   Output Parameters 63   9.2   DIP Service0800 Request 64   9.2.1   Input Parameters 64   9.2.2   Output Parameters 64   9.3   DIP ServiceCNAM Request 66      Part Number: STPD0083-0002   Version / Date: 3.6/ 03/07/12 Author: AC Page: 4/74Squire Technologies, 64 High WestStreet Dorchester Dorset DT1 1XA   9.3.1   Input Parameters 66   9.3.2   Output Parameters 66   9.3.3   Description Of Parameters 68   9.4   Message Sequence Examples 70   9.4.1   DIP Information Not In Local Database Successful DIP Lookup 70   9.4.2   DIP Information Not In Local Database, Unsuccessful DIP Lookup, Pass back error 71   9.4.3   DIP Information Not In Local Database, Unsuccessful DIP Lookup, Pass back Success 72   9.4.4   DIP Information In Local Database 73   9.4.5   Internal DIP Rejected 73   9.4.6   Polled Internal DIP Request Outgoing DIP 74