CISCO IVR PCCE with MSSQL database

[ashik.buhari]

Could anybody assist how to get a data from the database and interact with IVR system.

I have a to create an IVRflow where I need to get a flag value from database and based on that value I need to make a decision flow

Attached the snapshot of the flow where I need to write the code.

[Dmytro Benda]

Hi @ashik.buhari 

Most likely you forgot to attach your screenshot. In general, you should use a Database element in your Call Studio script to connect to your MSSQL DB. Besides that, you have to configure JNDI data in context.xml file located at C:\Cisco\CVP\VXMLServer\Tomcat\conf to specify your MSSQL connection data. After any changes in context.xml don't forget to restart your CVP VXML server. 

My Cisco Unified Communications Blog

[Konstantin Vaksin]

There are multiple ways of doing that.

You can get data on PCCE side via DBW process or via VXML App, that you will have to develop in CVP Call Studio

Kostia

[ashik.buhari]

PFA Screenshot

[ashik.buhari]

Hi,

Can anybody share the code snippet for reference

[Dmytro Benda]

You can start with this document:

https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/hcs-cc/12_6_1/Features_Guide/hcs_b_features-guide-12_6_1/hcs_m_db_integration-12_6_1.pdf

My Cisco Unified Communications Blog