Loading data

When the ARCAD Dashboard is configured, you can start to collect the data you wish to monitor. The data is collected from the applications and stored in the data warehouse.

You can decide to import all the data related to a type of model, or select one or more specific tables from a data source for a model. Once the data is loaded in the data warehouse, you can review the content in the Dashboard Web Studio.

Reference

For more information about data warehouse setting, refer to Data warehouse connectors.

Loading data consist in collecting all the source data from the applications' data sources and create the model in the data warehouse. Then the model is loaded to the dashboard client (Grafana or Kibana).

Dashboard Studio Run data loading

Follow the subsequent steps to load data:

Step 1   Import the data:

  • Click LOAD ALL DATA if you want to import all the source (DB2 for i, JIRA, the REST API webservices, or XSLX files) at one time,
  • Click one type of source if you want import only one source.

Confirm to continue, and wait until the import is complete. The data loading results (imported tables and number of records created) are displayed in a view.

Step 2   [Optional] Define the start time of the data import through the scheduler, in the Start scheduler section.

Important!

You must have previously activated the scheduler and defined a data import frequency.

Reference

To manage the scheduler, refer to Scheduling data imports.

Step 3   Load the model.

Note

This action is to be performed only at the first data import, and for each model: it allows to generate automatically the data for its graphic display in Grafana or Kibana.

To be able to consult the data in Grafana or Kibana, you must generate the corresponding model in the application. Select the application to load in the drop-down list and click the LOAD MODEL OF DASHBOARD button.

Result   The data are generated in the data warehouse, and can now be viewed directly in Dashboard Web Studio, Grafana or Kibana.

Dashboard Studio App identifier → Model →

It is also possible to load only certain tables for a define source.

Note

By default, the first source set is detailed. Use the green buttons to select another source.

Step 1   Scroll down to the following mapping:

ARCAD Dashboard - Data Mapping

Step 2   Using green buttons to display the source mapping wanted.

Step 3   Click the checkbox to the left of the metrics heading to activate the settings options for all the tables or select table(s) to be set up.

Step 4   Choose an action to be applied and confirm.

Step 5   Click LOAD DATA

Example

To import a single table from the model (to update its data):

  1. Select all tables,
  2. Disable "Activate" for all tables,
  3. Select the table to be imported,
  4. Enable "Activate",
  5. Click LOAD DATA .

You can also decide by checking the corresponding option:

  • to Clear table,
  • to manage a Campaign. ARCAD Dashboard: App identifier > Option of the model
Warning!

The setting is saved: remember to restore the initial setting to retrieve normal functioning.

Important!

It is not recommended to modify the SQL queries: this can result in errors.

Dashboard Studio View data loaded

Preview the data that has been collected from your data source directly in the Dashboard Web Studio.

To display the data, click  View data in the menu, or in the data model's view.

Step 1   Select a data model in the Select application drop-down list.

Step 2   Select a data source in the Select data source drop-down list.

Step 3   Select a table in the Select data view drop-down list.

Step 4   Click the  Data view button.

Result   All data are displayed in a table.