cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1718
Views
0
Helpful
6
Replies

Can anyone pls suggest,how to set up ODBC connection in UCCX 9.0(1

Mukesh Singh
Level 1
Level 1

Hi All,

Can anyone pls suggest,how to set up ODBC connection in UCCX 9.0(1) to fatch the record from external SQL Database?if anyone find solution,pls post here.

Thanks,

Mukesh

6 Replies 6

Muhammad Raza
Level 3
Level 3

Check below discussion, hope will be helpful for you.

https://supportforums.cisco.com/message/3026425#3026425


Sent from Cisco Technical Support iPhone App

jpsweeney77
Level 4
Level 4

What version of SQL is your external DB? What type of UCCX licensing do you have?

Hi

SQL version 2008

UCCX 9.0(1)

CUCM 9.0

UCCX Lic  Premium

If you want to use the out of the box solution, you'll first want to download the  JTDS SQL Server driver at the link below.  The highest tested version is 1.2.5. I've seen up to 1.2.8 used in a production environment for some very simple DB interactions. If you're unsure, I'd go with 1.2.5 unless you have a reason to go higher. You could check with TAC to see if they have certified a newer version since the document was released.

http://sourceforge.net/projects/jtds/files/jtds/

Once that is uploaded you can then define a Data Source and refer to the driver you just uploaded. The JDBC URL will look something like this where the database name is Customers

jdbc:jdts:sqlserver://10.75.1.55:1433/Customers

Of course, be sure that you have a user account mapped with the necessary rights to the DB you are trying to access.

You can then script using the created data source and leverage the Data Read, Data Get, Data Write, etc steps that are available in the script editor. Check Chapter 11 of the following guide for additional detail...

http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_9_0/programming/guide/SeriesVol1.pdf

Adding to this: JDBC driver support will be found in the Admin Guide for your version under "Subsystems Menu" > "Add new Database Driver".

Thanks & Regards,
Anirudh
"Protocol, then product"

Thanks & Regards, Anirudh "Protocol, then product"

Thanks everyone.

I have set up ODBC connection.

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: