Friday, 11 April 2014

Connect UCCX9 to Oracle Database


UCCX9 has not supported mysql database.
Required JDBC driver for database integration in uccx 9
Databases
Tested   JDBC Drivers
Oracle 10g R2
ojdbc14.jar
Oracle 10g XE
ojdbc14.jar
Sybase Adaptive Server   12
jTDS 1.2.2, jconn2.jar
IBM DB2 8.2
db2jcc4.jar
MS SQL Server 2000
jTDS 1.2.2
MS SQL Server 2005
jTDS 1.2.2
MS SQL Server 2008
jTDS 1.2.5


Upload database driver:
Connection settings:



If password is not correct. Error message:




If the test connection fails for Oracle JDBC drive connection,
try the following connection url:
jdbc:oracle:thin:[user/password]@[host][:port]:SID




SQL add user and assign privileges :

Look privileges of current uses :

Change user password:
alter user SYSTEM identified by ccievoice;





check current user:


No comments:

Post a Comment