cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2128
Views
0
Helpful
2
Replies

UCCX 8 access db_cra from script add informix jdbc driver

mschweitzer
Level 1
Level 1

Hi,

I want to use the db_cra database for the last agent routing from the call flow script.

I will run a query which serach wihtin the last 24 hours which agent talked to the customer the last time.

The problem is, that I'm not able to add the informix db into the uccx database subsystems.

I can only select these driver classes:

net.sourceforge.jtds.idbc.driver
com.ibm.db2.jcc.DB2Driver
oracle.jdbc.driver.OrcaleDriver
com.sybase.jdbc2.jdbc.SybDriver

But for the Informix Db I think I would need  the driver class:

com.informix.jdbc.IfxDriver.

Has anyone a idea how to add a driver class or how to access the db_cra from the script?

I know that it is possible to use a differnt database (like MSSQL) and write each time a agent gets a call the data to this db and access this one for last agent routing functions. But I want to use the db_cra for this.

thanks

Markus

2 Replies 2

nathanreynolds
Level 1
Level 1

Markus,

Did you ever figure anything out on this? I too am trying to find the answer to this question. Thanks!

Hi,

there is no way to do it that way.

You can't access the Informix DB directly from UCCX script.

But you can use a SQL server as a middleware. So you have to setup a SQL server and add the Informix db as a linked server.

Now you should be able to access the SQL server from the UCCX script.

Kind regards

Markus

--

CONET Solutions GmbH

Markus Schweitzer,

Theodor-Heuss-Allee 19, 53773 Hennef

Tel.: +49 2242 939-676, Fax: +49 2242 939-393

Mobil: +49 173 5486337

Internet: http://www.conet.de, mailto: mschweitzer@CONET.DE

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: