CCPulse 7.2 how to connect to external db?

[patbrat]

Hi,
I am a newbie here, so apologies if my question seems too easy (yes, I did look through all posts;)

I want to display external db values on CC Pulse template (schedules) and maybe even cross query them (comparing current state with the scheduled state). How to approach it (the connection issue - I will find a way to cross query later)?
I investigated how to connect out via ODBC and no luck. At the same time I have seen on some old topics that few of you managed to get a template reading external values somehow - can you please advise?

I know the easiest way is to get a proper wallboard software, but given how long it takes to process any request - will be much better trying to improvise I bet

[René]

Hi,

CCPulse doesn't support this. You should look for some other software or built custom one using available SDK.

R.

[patbrat]

Thanks, for me it does not look it supports as well, but I found this topic (alas it is a guest so I can not email him) http://www.sggu.com/smf/index.php/topic,4560.msg20269.html#msg20269
certainly the person claims they built the solution and got into problem with duplicated ODBC calls
The person that responded to the post did not question possibility itself either, did not ask how was it possible and offered some practical follow up (so from the context certainly the responder was sure as well it works)

[tech12]

Hate to be the party pooper, but nothing CCPulse related mentions ODBC to my knowledge.

If you do find otherwise, please, let us know Ohhh the possibilities...... 

[patbrat]

AS I mentioned - I can not find it as well, my only glimmer of hope is that 2 people in some other post (linked above) were discussing about existing, functioning (or malfunctioning) solution, so I have to presume there is something behind it

I could imagine that it is not CCPulse itself, but rather the database (Statserver) pulling data via ODBC and presenting datasets in natural way to CCPulse (as CCPulse does not have any other connections than Statserver)
Or the other way  that any of the ActiveX custom stats/formulas/thresholds invokes ADO connection to an external database and retrieves the third party values as in:
http://www.sggu.com/smf/index.php/topic,2654.msg15800.html#msg15800

[minuteman]

If you want to display external data in CCPulse view, that data should be retrieved from StatServer as value of statistic - there is no other way to do that (unless I missed something fundamental about CCPulse).
Generally speaking, it is doable - you create custom TServer client what registers on some DN, executes query to DB, retrieves results and distribute UserEvents with your DB values as UserData key-value pairs.
Then, you could create several statistics of TotalCustomValue type to retrieve that values from UData of UserEvents and values of these statistics could be displayed in CCPulse.
Sure think it is totally custom solution, but there is no other way to do that.

[fnunezsa]

Do you have access to Genesys Knowledge Base in Genesys Support Site? There's a solution that tells you how to do what you're looking for. Basically you'll need to write a vbscript as your formula in your CCPulse Template.
Solution ID is 11296.

[patbrat]

thanks a million