AltiGen comm MAXCS 84 Advanced Call Router Manual

							Advanced Call Router
Advanced Call Router Manual   27
The call router
 data source cou
 ld be configured as follows:
1 – Use "routetable" in the Match Conditions list. Advanced Call  Router will 
search IVR data from this table.
2  – Use "age
 nttable" in the Data R etrieve from User Database list . This 
specifies the data t o be retrieved from the second table.
3  
– Enter additional search criteria in the "Where" clause. This will be used 
to link AgentTable with RouteTable. 
Note:You can also create a view, to  make the SQL query simpler.
Route by Query Results Limitation
When using Route by Query Result , multiple match conditions (IVR data, 
caller ID, DNIS, etc) are not supported. 
						

							Testing SQL Server Database28  Advanced Call Router Manual
Testing SQL Server Database
To test SQL server database access performance of Call Router:
1. Add a database for the SQL server. 
For example, for a database “cal ldb” an
 d table name “RTMCALL”, 
10,000 records are  added to the table.
Note:Because the data of DDR request has been hard coded, if you wan t 
a rule match, you need to add the record to the table. The call er ID 
of test request will be “103947 0405.” IVR Path of test request  will 
be “0&9.”
To use the “SessionId” field in t he
  table to match caller ID of the 
request, you must add a record to  the table and set the SessionId  
						

							Advanced Call Router
Advanced Call Router Manual   29
value to “1039470405”. Then duri
ng match p
 rocess, the matched 
result will be true.
2. Add a data source  to “ODBC” config
 uration in Windows.
The “TestSQL” is the  newly added data source. This data source  is 
connected to the SQL serv er’s “calldb” database.
3. In Call Router, add a r ul
 e to access database. 
						

							Testing SQL Server Database30  Advanced Call Router Manual
You can change the rule configur
at
 ion to fit your own conditions.
During the test, Call Router will use this rule to match the DD R 
 request. 
When using this rule, Call Router will access the SQL server to  execute 
the SQL query.