09-14-2004 02:28 PM - edited 03-13-2019 10:27 PM
i am very new to cra/ivr, so i hope this isn't a stupid question.
i have a customer that wants to allow remote users to call in, get prompted for a pin, and if the pin authenticates successfully, the user is given the ability to dial out.
the question is, what options are there for the authentication phase. we may have an external database with valid pins, etc. is it possible to use external databases/data sources for pin authentication purposes?
thanks,
callum
09-14-2004 08:11 PM
Hi,
The Cisco CRA system uses the Database subsystem to enable CRA applications to interact with database servers in order to make database information accessible to contacts.
The following Enterprise Databases are supported for the Database subsystem via ODBC:
Microsoft SQL Server 7
Microsoft SQL Server 2000
Oracle 8i
Oracle 9i
Sybase Adaptive Server 12
IBM DB2 7.2
For more details, please take a look at the below URL which explains how to configure the Database Subsystem.
http://www.cisco.com/univercd/cc/td/doc/product/voice/sw_ap_to/apps_3_5/english/admn_app/apadm35.pdf
Hope it helps.
Regards
Venkat
09-14-2004 08:21 PM
Hi,
1. Database Steps : Editor offers database steps that can be used to query the external databases.
The tested and supported versions of Enterprise Databases for Database
subsystems in IPCC Express 3.5 are
. Microsoft SQL Server 7
. Microsoft SQL Server 2000
. Oracle 8i
. Oracle 9i
. Sybase Adaptive Server 12
. IBM DB2 7.2
The above is documented in Cisco Customer Response Application Administrator Guide. URL for the same is...
http://www.cisco.com/univercd/cc/td/doc/product/voice/sw_ap_to/apps_3_5/english/admn_app/apadm35.pdf - Pg.No:6-10
2. For configuring the database subsystem, refer the following URL...
http://www.cisco.com/univercd/cc/td/doc/product/voice/sw_ap_to/apps_3_5/english/admn_app/apadm35.pdf - Pg.No:6-11.
3. For collecting the digits : You can use "Get Digit String" step to collect the caller entered digits and store the same in a variable.
4. Refer the editor step reference guide to know about Database steps and Prompts and Collect Steps
http://www.cisco.com/univercd/cc/td/doc/product/voice/sw_ap_to/apps_3_5/english/admn_app/step.pdf - Pg.No:12-1(database steps) and Pg.No:7-31(Get Digit String step).
5. Also refer Cisco Customer Response Applications Developers Guide...
Do let me know if the above meets your requirement.
Regards
Yogi
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide