Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

Can anyone pls suggest,how to set up ODBC connection in UCCX 9.0(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

Re: Can anyone pls suggest,how to set up ODBC connection in UCCX

Check below discussion, hope will be helpful for you.

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


Sent from Cisco Technical Support iPhone App

Bronze

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

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

New Member

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

Hi

SQL version 2008

UCCX 9.0(1)

CUCM 9.0

UCCX Lic  Premium

Bronze

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

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

New Member

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

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"
New Member

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

Thanks everyone.

I have set up ODBC connection.

1117
Views
0
Helpful
6
Replies
作成コンテンツを作成するには してください