Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Usage Tracking (Kibana and Elastisearch)

Received Response
21
Views
4
Comments
3371002
3371002 Rank 5 - Community Champion
edited Aug 13, 2024 6:03PM in Oracle Analytics Forum

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

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    3371002 Rank 5 - Community Champion

    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
    Gianni Ceresa Mod

    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
    Gianni Ceresa Mod

    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.