Reports (Automatic)
Features
Reports can be automatically generated, in CSV, PDF or HTML formats. And you can create your own automatic report.
SQL Report
Report in CSV format can be automatically generated at a set interval, by pulling data from a relational database (oracle, sql server, mysql, etc).
Elasticsearch Report
Report in CSV format can be automatically generated at a set interval, by pulling data from an Elasticsearch datastore.
Scripted Report
In the event it isn't possible to use SQL to pull data from a database, you can use Scripted Report for more complex report. For instance, Elastic / NoSQL databases in general do not support JOINs between different indexes, since all data is stored distributed across many nodes.
Ability to write MVEL script that can fetch data from Germain datamart and transform into result set
Utility functions that can be used to query related data:
Get parent / children
Get all ancestors (ex: from SQL query up to User Click)
Get all descendants (ex: from User click down to all SQL queries)
etc
Feature Availability: 8.6.0 or later