Connection from CCPulse to a external D.B using Java Script

NICE CXone API & Integrations
1

Hello

I need to connect from CCPulse whith an other data base, access or my sql for extract information and meke new formulas using the two information

Thank You

2

La conexiĂłn la consigo con

wscript = new ActiveXObject(“wscript.shell”)
path = wscript.CurrentDirectory
mdb = path + “\PruebaJava.mdb”
conn = new ActiveXObject(“adodb.connection”)
connString = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=”+ mdb +“;User Id=admin;Password=”
conn.open(connString);
Select * from Clientes;

Ahora para hacer consultas o insertar datos?

3

wscript = new ActiveXObject(“wscript.shell”)
path = wscript.CurrentDirectory
mdb = path + “\PruebaJava.mdb”
conn = new ActiveXObject(“adodb.connection”)
connString = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=”+ mdb +“;User Id=admin;Password=”
conn.open(connString);
(“SELECT Nombre FROM Clientes”);

But when I´m going to create a new view a box said me that the sql snetence was removed

I need to show in CCPulse the actual agents logued in and the agent should be logued this are in my data base

Thank you

2 Likes
4

? And why not use StatServer tables instead?

1 Like
5

I need show in CCPulse the number of agent logged in and show our planification. Then I will create a thresold if aggent loged < agent planificated.

Thank you

1 Like