Collect Data from Denodo

This article explains how to create a Denodo Dataset and a Report from it.

PREREQUISITE: Established connectivity to a Denodo server.

1. Access New > Dataset > Create New

  1. Select the measurement interval that applies to the level of aggregation that you want in your result set
  2. Data collection is disabled by default to make sure that you can take time to configure the Dataset properly before enabling. This setting is duplicated at the top of the screen.
  3. Provide a descriptive name for your Dataset. You can provide any additional information about your Dataset in Description.
  4. Specify Category where your Dataset will be placed
  5. Move to the Data tab to define the source of data and how often it should be updated

2. Data Tab: Specify Details for Data Collection

  1. Select a Denodo connection profile
  2. Specify the Trigger that will be used to collect data for the Dataset
  3. Input an SQL statement to fetch data from Denodo
  4. [Validate]

[Enable & View] to proceed to Dataset Viewer

3. Create a Report from Viewer

  1. From the Actions menu, select Build Report
  2. Name the current Dataset View
  3. Specify Visibility
    • "Shared": Can be created by Admins and Power Users with the appropriate Privileges and Permissions and accessed by anyone who can view the Dataset
      • Metrics and Reports can be created only from Public Views
    • "Private":  Can only be accessed by Admins or the user who created the View
  4. [Save] to generate the Report

Once the Report Editor opens, [Save & View] in the upper right corner.