08-31-2013 07:08 AM - edited 03-14-2019 12:20 PM
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
09-02-2013 06:49 PM
Check below discussion, hope will be helpful for you.
https://supportforums.cisco.com/message/3026425#3026425
Sent from Cisco Technical Support iPhone App
09-03-2013 11:12 AM
What version of SQL is your external DB? What type of UCCX licensing do you have?
09-04-2013 12:26 AM
Hi
SQL version 2008
UCCX 9.0(1)
CUCM 9.0
UCCX Lic Premium
09-04-2013 11:02 AM
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...
09-05-2013 04:53 PM
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"
09-05-2013 11:17 PM
Thanks everyone.
I have set up ODBC connection.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide