03-07-2011 12:04 AM - edited 03-14-2019 07:31 AM
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
05-05-2011 06:42 AM
Markus,
Did you ever figure anything out on this? I too am trying to find the answer to this question. Thanks!
05-05-2011 07:11 AM
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
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: