Question about database integration from Call Studio

hi ,

I am new to this Cisco Unified call studio. I have a question on how to integrate with database. Like as per doc, it seems we should provide a JNDI name for DB connection but not clear on how or where to create the required JNDI to connect to a sql server? I have call studio 11.5.1.

Can anyone help me on this? and also, how do we get session ucid ?

Thanks

1. Download the Sql Server JDBC driver and put that under

C:\cisco\cvp\vxmlservere\tomcat\lib\

2. Modify C:\cisco\cvp\vxmlservere\tomcat\conf\context.xml

<Resource name="jdbc/customer" auth="Container"

type="javax.sql.DataSource"

factory=”org.apache.tomcat.jdbc.pool.DataSourceFactory”

driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"

url="jdbc:sqlserver://hostname:1433;user=someone;password=someone;DatabaseName=yourDbName"

   />

3. Restart VXML Server

4. In studio use the JNDI name that appears after the *jdbc/ *of the

name attribute of the context.xml file.

For example,   in the above example, the JNDI name is customer

Thanks Janine Graves for the quick response .

BUt Issue is I just have the call studio and from call studio , want to test the DB integration..Currently we Don't have CVP.

Not sure about this path: C:\cisco\cvp\vxmlserver\tomcat\lib\. ..How do we get this path?Should call studio be installed in vxml server and is there specific installer to set up vxml server? Is it set up as part of CVP installation. Is there a way we test the DB ntegration only using call studio?

Can anyone please respond to my queries above?

1. install the jdbc driver into C:\Cisco\CallStudio\eclipse\plugins\com.audiumcorp.studio.debug.runtime\CATALINA_HOME\lib

and

2. modify the context.xml file in C:\Cisco\CallStudio\eclipse\plugins\com.audiumcorp.studio.debug.runtime\CATALINA_HOME\conf

3. Then in studio, use the DB element and specify the jndi name as configured in the context.xml file after the slash in the attribute called name

<Resource name="jdbc/yourJndiName" auth="Container"

type="javax.sql.DataSource"

factory=”org.apache.tomcat.jdbc.pool.DataSourceFactory”

driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"

url="jdbc:sqlserver://hostname:1433;user=someone;password=someone;DatabaseName=yourDbName" />

4. Ensure that you've set the permissions correctly on the SqlServer.

5. Once you save the program, you can right-click the appname and select Debug Call Studio Project.

6. In the  bottom right of the Debug Perspective, press Connect to make a simulated call. It should connect to the database if you've configured it right.
If you get an error message then go to C:\Cisco\CallStudio\eclipse\plugins\com.audiumcorp.studio.debug.runtime\AUDIUM_HOME\applications\appname\logs and look at the logs for help.

To test with Studio Debugger, substitute C:\cisco\cvp\vxmlserver\tomcat

with this:

C:\Cisco\CallStudio\eclipse\plugins\com.audiumcorp.studio.debug.runtime\CATALINA_HOME\