Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: hieutx on March 16, 2018, 04:27:52 AM

Title: How to get content of WDE Note and Chat interaction into Infomart DB
Post by: hieutx on March 16, 2018, 04:27:52 AM

Hi everyone,

At a time, our customer need to create a report about wde note and chat content. So is this the way to get them from UCS Database for historical report?

thanks and best regards

Title: Re: How to get content of WDE Note and Chat interaction into Infomart DB
Post by: Kubig on March 16, 2018, 12:00:28 PM

For these purposes I strongly recommend to use PSDK. Of course, you can get data directly from database, but it is not recommended way.

Title: Re: How to get content of WDE Note and Chat interaction into Infomart DB
Post by: cavagnaro on March 16, 2018, 01:52:52 PM

Hey Kubig got me curious here...how does PSDK help here? PSDK for icon or what exactly? To write to another DB via PSDK directly?


Enviado de meu E6633 usando Tapatalk

Title: Re: How to get content of WDE Note and Chat interaction into Infomart DB
Post by: Kubig on March 16, 2018, 02:19:45 PM

You can create UCS queries via PSDK. This topic is not about ICON, but it is related to the UCS. As the UCS will use Cassandra as the database, I cannot recommend to use direct access as it should work just temporarily - until the new UCS is installed.

Title: Re: How to get content of WDE Note and Chat interaction into Infomart DB
Post by: cavagnaro on March 16, 2018, 02:30:18 PM

Right, misread ;)
Cassandra? UCS can use Cassandra? Or will use? I have UCS under MSSQL or Oracle for example, will depend on customer infrastructure, right? It is not like ORS does has a Cassandra engine mandatory.

Title: Re: How to get content of WDE Note and Chat interaction into Infomart DB
Post by: eugene on March 24, 2018, 09:33:58 PM

it'll be updated to use Cassandra for performance reasons.  UCS 9x architecture will finally allow for N+1 configuration

Title: Re: How to get content of WDE Note and Chat interaction into Infomart DB
Post by: cavagnaro on March 24, 2018, 09:39:28 PM

Ouch...more Cassandra to support...wonder how does archive and space consumption will be?
Will be mandatory? What if customer don't want to have it? Support thinking of course


Enviado de meu E6633 usando Tapatalk

Title: Re: How to get content of WDE Note and Chat interaction into Infomart DB
Post by: eugene on March 25, 2018, 09:21:25 PM

Yes it is mandatory and preferably the open source flavor of cassandra 3.x

as for support of cassandra, this is whom genesys has referred me to look into Instaclustr.

honestly i've rarely had any major issues with cassandra. Even when i do Genesys support team had be nothing short of amazing even in troubleshooting their products against Cassandra.

Title: Re: How to get content of WDE Note and Chat interaction into Infomart DB
Post by: OXE_4400 on May 07, 2018, 09:54:06 AM

[quote author=eugene link=topic=10910.msg49573#msg49573 date=1521927238]
it'll be updated to use Cassandra for performance reasons.  UCS 9x architecture will finally allow for N+1 configuration
[/quote]
Does it means that Cassandra will be only option for UCS?

Title: Re: How to get content of WDE Note and Chat interaction into Infomart DB
Post by: eugene on May 08, 2018, 04:43:16 AM

yes UCS 9.x going forward is cassandra only.

Title: Re: How to get content of WDE Note and Chat interaction into Infomart DB
Post by: cavagnaro on May 08, 2018, 04:46:58 AM

And is there an easy way to migrate from Oracle for example to Cassandra?

Enviado de meu E6633 usando o Tapatalk

Title: Re: How to get content of WDE Note and Chat interaction into Infomart DB
Post by: eugene on May 08, 2018, 09:26:22 PM

yea it's my understanding that there is some migration tool that would allow you to do this.

Title: Re: How to get content of WDE Note and Chat interaction into Infomart DB
Post by: n3vek7 on May 10, 2018, 01:33:50 PM

Cassandra again...  :o :o :o
Thanks for the information. So far I've worked with Cassandra only with WWE, and to be  honest, I was not impressed by the clustering configs and the stability... but hey, maybe I need to better understand it  ;D. If Genesys is going more Cassandra, I guess it's a great product.

With all this, did hieutx get his answer ?  :P
[quote]"our customer need to create a report about wde note and chat content"[/quote]
I'm curious, what's in these notes? Shouldn't it be easier to use interaction/disposition codes instead of the notes?
Agree with Kubig, best way to get UCS data is via PSDK.