Output Reporting Data to the Internal SQLite Database

You can use the Reporting Store Publisher to send data to the embedded CloudView SQLite database.

The Reporting Store Publisher is the default publisher used by all reporters. You can view reporting data for the:

  • search-reporting in the Business Console’s Query Reporting menu.

  • mashup-ui-reporting in the Mashup UI Debug Mode > Timeline tab.

  • mashup-api-reporting, in the Mashup UI Debug Mode > Timeline tab.

  • opendocs-reporting in the Business Console’s Query Reporting > Top Opened Documents.

This task shows you how to:

See Also
About Reporters
Output Reporting Data to CSV Files
Output Reporting Data to a JDBC Database
Output Reporting Data to the Internal SQLite Database
Available Fields for the Reporting Publishers

Output Data to the Reporting Store Publisher

  1. In the Administration Console, go to Search > Reporting.
  2. Under Reporter, expand one of the reporters, and select Reporting Store Publisher.
  3. For Schema, select one of the predefined schemas of the embedded SQLite database. For example, for the:
    • search-reporting reporter, select queries,
    • suggest-reporting reporter, select suggests,
    • etc.
  4. For Rotation cron, enter a cron command to run the rotation job periodically. By default, 0 0 * * * runs once a day at midnight. A rotation is also triggered every time a collection is queried.
  5. For Max records to keep, enter the maximum number of records that can be accumulated. When you reach the limit, the oldest records are discarded. 0 means that there is no limit to the database size.
  6. Click Save.

Access Reporting Store Data

Go to <DATADIR>/reporting_store/<SELECTED SCHEMA>/collection.db