How to get content of WDE Note and Chat interaction into Infomart DB

[hieutx]

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

[Kubig]

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

[cavagnaro]

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

[Kubig]

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.

[cavagnaro]

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.

[eugene]

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

[cavagnaro]

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

[eugene]

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.

[OXE_4400]

[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?

[eugene]

yes UCS 9.x going forward is cassandra only.

[cavagnaro]

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

Enviado de meu E6633 usando o Tapatalk

[eugene]

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

[n3vek7]

Cassandra again... 
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  . If Genesys is going more Cassandra, I guess it's a great product.

With all this, did hieutx get his answer ? 
[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.