Ryan LaFountain Tue, 04/20/2010 - 07:40
User Badges:
  • Cisco Employee,

Hi,


You will have to load the Unix/Linux JDBC driver appropriate for your external database (Oracle, SQL, DB2, Sybase etc.). Once you upload the driver as a .jar file, you will select the class from within the .jar file that runs the driver. This will be replicated over to the second UCCX node automatically so it will not require any manual work on the second node like previous version of UCCX.


For example, I have a connection from UCCX 8 to a MSSQL 2005 database. I have downloaded


net.sourceforge.jtds.jdbc.Driver


from Sourceforge and uploaded it to AppAdmin. I can then define a Datasource to use this drive and also define the JDBC URL as:


jdbc:jtds:sqlserver://


After this, I can then use this Datasource in the Editor as normal.JDBC URLs may be different for different types of servers, so you may just have to look up which one to use for your type of Enterprise Database.


This is explained in the UCCX Admin Guide for 8.0.

ishaqkhan77 Thu, 07/08/2010 - 23:38
User Badges:

Hi there,

basically we have an query of client that for outbound preview dialing we will provide an dynamic list to dialer in UCCX 8.0 .SO for that as a first step i need to have an database access which is Informix in UCCX 8.0 so how can i create a trust relation ship so i can view all the tables of my UCCX 8.0 for making reports and other thing .Please let me know the procedure or if you can provide any screen shots it will be easy to understand.Also in you reply kindly cc me on mishaqakhan@gmail.com i will be thank full


Thanks .

Darren Roback Mon, 12/12/2011 - 10:54
User Badges:

Nice doc outlining the integration between UCCX 8 and SQL 2005. I recently performed an upgrade from UCCX 7.0(1)SR5 to 8.0(2), and got the SQL integration up and running in under five minutes.


Thanks much!

Actions

This Discussion