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

[Mat]

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

[Mat]

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?

[Mat]

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

[cavagnaro]

? And why not use StatServer tables instead?

[Mat]

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