cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
111
Views
0
Helpful
0
Comments
cdnadmin
Community Member
This document was generated from CDN thread

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”

Regards,
Geoff
Getting Started

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:

Quick Links