Collect data from Atlassian Jira

This article details how to create a Dataset populated with data sourced from Atlassian Jira.

It assumes that you have already established connectivity to Atlassian Jira.

1. Access New > Dataset > Create New

Add a new element - an example for Report

2. Dataset Editor > Info tab

Define the basics:

  1. Measured: select the measurement interval that applies to the level of aggregation that you want in your result set
  2. Collecting: new Datasets are always disabled by default to make sure that you can take time to configure them properly before enabling. This setting is duplicated at the top of the screen
  3. Name: provide a unique name for your Dataset. Preferably, the Dataset name should explain what kind of data it contains
  4. Description: optionally, provide any additional information about your Dataset
  5. Category: specify the Category where you Dataset will be placed

Move to the Data tab to define the source of data and how often it should be updated.

3. Define the Settings for Data Collection

3.1. Using MIQL Plugin Command

For details on building fetch commands, refer to:

  1. Data Source: select the connection profile you have created for Atlassian Jira
  2. Data collection trigger: specify the Trigger that will be used to collect data for your Dataset
  3. Element: select an Atlassian Jira Object that should serve as a basis of your Dataset
  4. In the Command tab, input an MIQL Plugin Command listing all data that needs to be fetched from Oracle Business Intelligence
  5. Validate your query


  1. Entire field names that contain special characters, aggregation and commas must be enclosed in quotes (single or double). 
  2. It is acceptable to enclose all fields and values in quotes.

[…] + Notation is used to signify that the MIQL parts of a statement are optional/can be repeated. 

4. Plugin command will be validated and data collected on Save

5. Dataset will be displayed in Viewer

In the Dataset Viewer:

  1. You can further refine your data with Dataset's internal filtering options by applying Rules and Grouping Data: