Usage Tracking (Kibana and Elastisearch)

3371002

Would anyone happen to have screenshots for a walkthrough on how to set these up?

Gianni Ceresa

Hi,

You can maybe already start by sharing your searches, finding, what you tried and what happened and so have a more explicit question about a precise point? (a bit what suggests).

Asked like that it sounds a bit like "do my job" ...

3371002

The steps Are available on the System Administrator's Guide on how to set up Direct Insertion and such but I was wondering if anyone had Kibana and Elastisearch walkthrough.

Gianni Ceresa

So first thing you can take Kibana out of the equation: Kibana isn't a database, so it can't store your usage tracking.

The admin guide explain how to setup usage tracking in the supported way: inserting into the S_NQ_ACCT table of the BIPLATFORM schema, which means the database is one of the 3 supported for the RCU: Oracle, SQL Server and DB2.

If you look at how the UT works it makes a INSERT into that table, so elasticsearch isn't supported directly.

But you can of course extract things from the UT table to load into elasticsearch.

Gianni Ceresa

As extension: you can also define and setup UT on another kind of DB, as long as it's a standard kind of database talking SQL and that can be defined as a physical source in the RPD, so not really only limited to the 3 kind of DB but 98% of people just use the table in the RCU schema.