Heads Up :
The post you are writing will appear in a public forum. Please ensure all content is appropriate for public consumption. Review the employee guidelines for the community here.
Created by: Gerard O'Rourke on 01-05-2013 05:20:34 AM I assume that there should be no issue with using SQL 2012 Express for CVP database lookups? http://msdn.microsoft.com/en-ie/library/cc645993.aspx The advantages for using SQL express are that its free. It limits of a 10GB max db size will not be an issue, as the database tables will be small and pretty static in size. Its CPU limits of "lesser of 1 Socket or 4 cores" and 1GB of RAM again should also not be an issue due to the lookup types taking place. Note: there are no concurrent limits in SQL express any more. Purpose: Used for CVP/ICM script DN lookup to configure open/close and various variables tied to a particular DN (DNIS). Solution: VMWare HA server with W2008R2 & SQL 2012 Express Comments / Recommendations? Regards, Gerry
Subject: RE: SQL 2012 Express for CVP DB lookup Replied by: Gerard O'Rourke on 03-05-2013 11:14:10 AM Ok, no response.. Maybe another query? Is there a an list of "supported database" that Cisco say CVP can connect and 'support' through Cisco TAC? Or am I correct in stating that as this is custom CVP development any database which can be set up using JNDI on the Tomcat Java Application will work, but none are "TAC supported" as such. Or do Cisco actually state that CVP database integrations with database server X & Y are support? e.g. SQL2008 R2 etc. Gerry
Subject: RE: SQL 2012 Express for CVP DB lookup Replied by: Paul Tindall on 03-05-2013 11:22:03 AM Gerry, That's correct, there is no explicit statement of support for any particular database or version. The scope of the DB integration is to a JNDI data source.
Subject: RE: SQL 2012 Express for CVP DB lookup Replied by: Gerard O'Rourke on 03-05-2013 11:25:48 AM thanks. G
Subject: RE: New Message from Gerard O'Rourke in Customer Voice Portal (CVP) - Gener Replied by: GEOFFREY THOMPSON on 03-05-2013 11:26:07 AM In my experience, MS SQL in various forms, My SQL, and Oracle all work fine.
I’m tempted to agree with what you say: “any database which can be set up using JNDI on the Tomcat Java Application will work”
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: