StatServer database

[S2H]

hi,
  For Historical Reporting , StatServer stores data in the StatServer database. Whether for RealTime Reporting , StatSerever stores the data in the StatServer database. If i am wrong, please correct me.
 


Thanks,

[cavagnaro]

Totally wrong, statserver only uses 4 tables as much to store certain type of data.
Read Reporting documentation, introduction will be enought

[Kubig]

You are totally missing the point. Learn about Genesys, visit the Genesys university and you will understand.

[S2H]

I am new to genesys , if i get some information about this, it will be helpful.

[cavagnaro]

Already mentioned. Read the guides. There is no database on real time. StatServer doesn't handle historical neither.

[Kubig]

StatServer is not using database for storing stats information and values. StatServer just collecting the information, holding it within own memory and provide these data to connected client. The DB tables, which has mentioned Cav are for "special" purposes (for example login/logout table, etc.). For hsitorical reporting (CCA) the datasourcer writes/stores data to the database, for real-time reporting there is no database as a source of data.

This is very basic knowledge of Genesys and in case when you do not know that, strongly recommend to visit any training and read documentation. BTW: Information above are public and you could learn/read it before create topic. So, just little bit effor for next time

[victor]

Well, in a way S4 is right... Stat Server does "store" the data, only in one case it does it through DB Server directly and another through Infomart. (oh, no...I am about to get it!)

S4: Adam has really good handbook about Genesys basics, which explains everything in finer detail, but, in a nutshell, StatServer only collects data from T-Server and then provides it to other products to deal with them as they see please. Most of the information is handled by Infomart.

The statserver does write into four tables: LOGIN, QINFO, STATUS, and so on...

There is a very good explanation here as well: http://docs.genesys.com/Documentation/RTME/8.5.0/User/Welcome

What exactly are you having problems with?

[Kubig]

Just question : In what case the statserver writes data directly to the database (with except of login table,etc.)?

[Adam G]

s4 - StatServer is a "pass-thru" point for statistical data transfers.  It makes Requests and accepts Values, which it passes (sometimes through a Database Server (DBServer)) to components it is connected to, both physically and through the settings in CIM/CME.  It depends on what Options and Settings you apply to a StatServer on what Statistics it requests - and for which Objects.

For example;

A StatServer deployed for Real-Time Reporting (Call Centre Pulse Plus (CCP+) will collect Statistics very regularly and "feed" them to Agents with the CCP+ Client.  The CCP+ Client appends and aggregates some of those Statistics, within it's displays for the User.

So, although there are some Data Tables StatServer could pass information to (mentioned by others in this thread), it's primary purpose is to connect and pass statistical information to other components and peripherals within the CIM Platform framework.

If I write any more, I'll be writing a StatServer Guide in this thread - and I pretty much already did that!

AG

[Adam G]

[quote author=Kubig link=topic=8627.msg38093#msg38093 date=1418136938]
Just question : In what case the statserver writes data directly to the database (with except of login table,etc.)?
[/quote]

...hinted by vic; StatServers can have DBServers connected to them, to pass through specific statistical information to pre-defined Tables; QINFO, LOGIN, AREF and STATUS.

StatServers are also used within Solutions, such as (URS) Routing, to provide point-it-time statistics on which to base Routing decisions.  From there, it would then take another StatServer to extract the statistics from the "Decisions" made within routing, to "feed" the Contact Centre Analyzer (CCA) Reporting solution - which has masses of Database Tables!

HTH?

AG

[Kubig]

I know what StatServer is and what he does ;-) I wrote except login,status,etc. tables. ....To be honest, currently I don't know about any other case, when the StatServer writes anything to the database. May be in case, when there are some customization on that level. So, I was just wonder what case Vic and you mean.

[cavagnaro]

vic never said that:

Stat Server does "store" the data, only in one case it does it through DB Server directly and another through Infomart.

- only in one case it does it through DB Server directly (refering about 4 tables we know)
- and another through Infomart.

Even on InfoMart is a little bit inaccurate as is Infomart who does the DB insertion, been feed by StatServer on data only.

[Adam G]

[quote author=Kubig link=topic=8627.msg38105#msg38105 date=1418160682]
I know what StatServer is and what he does ;-) I wrote except login,status,etc. tables. ....To be honest, currently I don't know about any other case, when the StatServer writes anything to the database. May be in case, when there are some customization on that level. So, I was just wonder what case Vic and you mean.
[/quote]

...what cav said.... lol

AG

[Kubig]

My fault, have bad understood. What is the role of StatServer within Infomart solution? Never hear about it :-)

[Fra]

[quote author=Kubig link=topic=8627.msg38110#msg38110 date=1418199223]
What is the role of StatServer within Infomart solution? Never hear about it :-)
[/quote]
Yeah, neither have I.
Stat Server doesn't play any role whatsoever in the Infomart world.

Fra