Oracle Analytics Cloud and Server

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

Any way to log user "Export to external format" action in OBIEE 12c

Received Response
121
Views
14
Comments
2»

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Then I would DEFINITELY go for the log writer. Write your own custom logs and trickle-feed them into a DB table. If you do it, do it properly A to Z and forget the JH part.

    Nice little project you got there.

  • As extra info, this is the kind of logging I talk about: https://docs.oracle.com/middleware/12212/biee/BIESG/GUID-BC51D576-D373-4EEF-8C09-47FD10127F68.htm

    As you can see the writer implementations aren't many, not much more than logging in a file or standard output. It isn't like a Java logger which could more easily write in a database directly.

    But, if you have an Oracle database, you could try to read the file directly there. If you set it as XML output you have good chances to be able to define the log file as an external table and query it (just don't sure how it will deal with the constant writing to that file). So it's either manual scripting, or database work or use one of the many tools on the market (or opensource) to deal with log files, parse them and write them somewhere else.

  • deniska
    deniska Rank 5 - Community Champion

    I tried and this works...but

    1. There is no info about who did the export - only xml and source file with data. We havw to identify who did this

    2. CVS-exports aren't logging

  • deniska
    deniska Rank 5 - Community Champion