All eazyBI for Jira eazyBI for Confluence Private eazyBI

Data from Jira
eazyBI for Jira

On this page:

Initial Import

After creating an eazyBI account, you need to import into the eazyBI database the selected Jira project issues (or space work items in Jira Cloud) that you would like to analyze. You can edit import options at any time.

From the Source Data tab, select Add new source application and then select the Jira application as a source application type.

The data import from Jira is authorized by the user who performs the initial data import: their Jira credentials are used to detect which projects (or spaces in Jira Cloud) and fields could be imported into this eazyBI account and are applied to all consecutive data imports–scheduled or manual. Inactive or non-existent users can't authorize data import: if the user's access rights in Jira change (the user is deactivated or loses access to some of the selected projects), user authorization must be reset.

After that, the next screen, Select application import options, would be opened to continue the initial import setup.

Video Transcript

Welcome to this tutorial on how to import data from Jira into eazyBI!

In the previous video, we provided an overview of the three main steps for getting started with eazyBI:  data import, report creation, and publishing.

In this video, let's take a look at the first step: how to import Jira data into eazyBI. During data import, Jira issues information is organized in a more report-friendly structure and prepared for report creation. You may find that someone has already imported the data. In which case, you can skip this video and go straight to the next one that covers how to create a report! 

Before we dig into imports, it is essential becoming familiar with the concept of eazyBI accounts. In eazyBI you can create one or several eazyBI accounts. In each eazyBI account, import a separate set of Jira projects and create a separate set of reports and dashboards that are needed for those projects. Pay attention that user access to eazyBI accounts should be defined separately from Jira security schemas! Give access to each eazyBI account to selected Jira users or user groups. Users will see only those accounts they were given access to. Dedicated eazyBI admins and Jira administrators are the most powerful roles in eazyBI. Then there are account-specific roles like report admin, user, and viewers. Read more about user access roles in the eazyBI documentation! 

In this video, we will cover the data import into one account. Let's start. Go to eazyBI and if you are the admin create a new account. If not, go to an account that has already been created and open the Source Data. Add a new data source and select Jira. If Jira is already added as a source, you won't be able to add it one more time. 

The General tab is the most important one. It is required that you choose what project data you want to import into this account. Select either by project name or project category. All other selections in the import process only define what kind of data from those projects will be imported. We will import Alpha, Beta, and Scrum projects. eazyBI recognizes what Jira products are used in the selected projects: Jira Core, Jira Software, or Jira Service Desk, and also suggest importing the relevant data for each one of them. Those can be Sprints, Story points or SLAs. If you do not plan to analyze this information, deselect it by clicking on each field name! Now, set up how frequently you want to update data from Jira into eazyBI. It is recommended to do a daily data import at a specified time that falls after working hours. Let's say 4 AM. Then let your team know that each morning, the fresh data will be available in eazyBI. Thankfully, scheduled data imports happen automatically, no one has to wake up for them! From here, if you only need the basic issue information, you are ready to click the Import button. 

But for this example, let's refine the data import a bit more. If you want to include data from other Jira apps, click the Add-ons tab and select what information you need. Only add-on apps available in your Jira as well as are integrated with eazyBI (2), appear in this tab. Please read more about this in the eazyBI documentation! We add Portfolio data.

In the Custom fields tab, you can select the custom fields you want to analyze. Choose how do you want to use them in your reports: dimensions, measures, and properties. Don't worry about choosing the wrong thing: only valid options are available for selection! So, it is OK to just click on the field name to add the field for the import. If some of the fields are missing or you want them to import differently, check out the eazyBI documentation about advanced settings for custom fields! In most cases, this is enough to complete the data import. Let's click the Import!

The first data import may take some time, but regular imports are incremental and, thus, much faster. Also, do not worry that someone can import data they do not have access to. Only issues and projects available in Jira for the person who authorized the data import or, in other words, has run the initial data import, will be imported into eazyBI. Whenever you need to make a change to the data import, open the screen in Edit mode, update the options and run the import again. Scheduled imports will automatically include the changes you made.

After the import is completed, in the Analyze tab you can see the data cube "Issues" is created. You can always know when the last regular data import was run and how fresh the imported data are! If they are stale and you do not have access to the Source Data tab, talk to your admin! Now everything is set up for the first report, all dimensions and measures are available.

Before wrapping this video episode up, one question: 

What kind of data is used to create reports in eazyBI?

  1. eazyBI connects directly to the Jira database, grab data as they are and build reports
  2. eazyBI imports data from Jira, organizes them in measures and dimensions and then you can create reports using them
  3. Jira standard information is imported into eazyBI, while data from custom fields and Jira apps are included directly from Jira

The correct answer is - eazyBI imports data from Jira, organizes them in measures and dimensions and then you can create reports using them

During this video, you learned how eazyBI data are organized into accounts and how to set up a data import from Jira to eazyBI. In the next video, we will talk about creating a meaningful report using imported measures and dimensions.

Select application import options

Select which Jira projects (or spaces in Jira Cloud) you would like to import into eazyBI. You can select all or individual projects, hide unselected ones, and clear the selection [1]. You can use the search filter to find your project [2] or choose between projects and categories when selecting data for import [3]. When a project category is changed in Jira, the project will be automatically deselected from the eazyBI import if the new category isn't selected. 

During data import, eazyBI automatically pulls data from Jira standard fields such as Issue Type, Priority, Label, Fix version, Assignee, and a few others. Here is the list of all dimensions and measures. You don't need to select and import them separately. eazyBI provides additional import options for Software and Service Management project types.

The option to keep archived project data is available on Cloud and eazyBI version 9.0.

You can preserve the data of archived projects in the eazyBI account if the project data was imported into this account before the project was archived [4]. For archived projects, eazyBI keeps previously imported data but does not update or recalculate it during data imports. The archived project list varies for each account based on previously selected projects:

  • If the project is archived and hasn't been imported into the specific account before archiving, it won't appear in the archived project list. 
  • If you deselect the archived project in the data import, eazyBI will remove this project's data during the import, and it won't appear in the archived project list anymore. 
  • If you empty the cube, then the archived project data are deleted, and it won't appear in the archived project list anymore. 

By default, data imports from Jira are scheduled once a day, but you can adjust the scheduler. Jira Cloud customers can also schedule imports more often with Process events.

Statuses and history

In the Statuses and history section, select if you would like to import issue change history [1] as well as indicate Issues closed measure [2].

Option "Import issue change history" should also be selected if you want to import custom field changes (use it together with the option "Import value changes" for custom fields and Sprints).

Process events

Available only in eazyBI for Jira Cloud 

When Process events are selected, eazyBI listens to the most essential Jira Cloud webhooks and updates data every hour, even if the Regular import runs once a day.

Process events import data on:

  • Issue changes - creation, deletion, or update (when the issue’s updated date is changed);
  • Worklog changes - creation, deleted, or updated;
  • Comment changes - created, deleted, or updated;
  • Issue link changes - added, deleted;
  • Sprint changes - deleted, updated, started, and completed;
  • Sprint board configuration changes.

However, process events might not capture changes from Jira calculated fields and Jira apps (Tempo Planner, Xray, Zephyr Squad, etc.) because these changes are not received via webhooks.

Initiate data import by pressing the "Import" button from the Source Data page, or wait till the closest regular incremental import to get data from Jira apps.

When making any changes in the import options page for the Jira source application, you must press the "Import" button to restart process events.

Add-ons

In the Add-ons tab, select to import custom fields specific to Jira apps. Some Jira apps require additional authorization and configuration.

You can install additional add-ons from the eazyBI Marketplace. If your app isn't available yet, build it using a coding AI agent.

Custom fields

In Custom fields tab, you can select the custom fields you need, including custom fields from company-managed and team-managed projects. Depending on the custom field type, you can import a custom field as a dimension, measure, or property, and import its value changes. For details on each custom field type and its import options, see the Jira custom fields page.

Global calculated fields in eazyBI appear in the custom field list among Jira custom fields. Account-specific calculated fields in eazyBI appear in a separate section, Calculated Custom fields, at the bottom of the page.

eazyBI does not import work item links by default. Use the Issue links section to specify which issue links to import: as a dimension of linked issues, or as an issue property with a comma-separated list of linked issue keys. For details and examples, see the Import issue links page.

Import only the custom fields you need for analysis. Each additional custom field increases the import time.

Additional import options

In additional import options, you can configure the Time dimension and enable Sample reports. The following chapters explain Jira source application-specific import options.

JQL query filter

If you would like to analyze a subset of issues from selected projects (or spaces in Jira Cloud), you can specify a JQL query that would limit which issues (or work items in Jira Cloud) are imported.

  • To not import issues that have been closed for more than one year, you can use JQL status not in (Closed) OR updatedDate > -52w
  • To import issues that do not have any security level, use JQL level is empty
  • To limit by a saved Jira filter filter = "Name of saved Jira filter" (the filter must be available to the user who authorized the data import from Jira)

It is not allowed to use the "ORDER BY" clause of the JQL query in eazyBI. The data import implementation uses its own ordering of issues.
eazyBI recognizes only functions from the Jira advanced searching list. Enhanced search by Scriptrunner and functions provided by other applications are not applicable in eazyBI import options. In those cases, you should use saved Jira filter names in the eazyBI import options page.

We recommend limiting imported versions and components when using JQL filters to import only relevant components, fix versions, and affects version in the data cube. 

Additional dimensions for user groups, intervals, and issue link fields

You can import user project roles for Assignee and Reporter and user groups for Assignee, Reporter, Logged by, or Transition author and specify set of groups you would like to use in your reports [1].

Select the option to import  Age and Resolution Intervals dimensions [2] if you want to create reports by unresolved issue age intervals or Issue resolution intervals.

If you use issue hierarchy in the reports and would like to see issue data at one hierarchy level while filtering by another, you might want to import the issue link field dimensions [3]. For example, get all data by Fix version of the related Epic.

Additional measures for time tracking

If you would like a broader set of time-tracking measures, select the option to import additional measures for hours spent and original estimated hours.

Template account

Select Template account [1] to import reports, dashboards, and calculated measures defined in a common template account. You can override [2] existing reports, dashboards, and calculated measures with reports, dashboards, and calculated measures from the template account. 

Incremental import

After each successful Jira issues import, eazyBI will store a timestamp for processed Jira issues.

During a regular Jira data import (manual or automatic), eazyBI will import only Jira issues that have been created, updated, or deleted since the last import. All issues from archived projects, as well as archived issues, will automatically be removed from the "Issues" data cube. Incremental Jira data imports are much faster than the initial import.

If you change import options (for example, add an additional project or select additional custom fields), eazyBI will force a full re-import of all Jira issues.

The user can initiate the incremental import by manually pressing the Import button from the Source Data screen. By default, the Source Data page is available only to eazyBI account users with the data roles of Owner, User admin, and Data admin. But you can enable the option to start incremental import for the Report admin and User roles, too. This option cannot be combined with any data access roles. If the users can initiate incremental imports, they have unrestricted access to the data imported into the account.

The option to start an incremental import manually by the Report admin or User is available in eazyBI for Jira Cloud, starting with eazyBI version 8.2.

Adjust imported data

Users with data admin or higher role can edit import options and delete imported data.

Delete members without data

You can delete members without data from dimensions in the Issues cube on Cloud, starting with eazyBI version 8.1.

You can delete members with no data from the Issues cube for the following dimensions:

  • Jira dimensions: Assignee, Reporter, Logged by, Priority, Issue Type, Status, Resolution, Security Level, Label, Worklog, Sprint, Transition Status, Transition, Transition Author;
  • Jira custom field: single-choice custom fields imported with separate_table settings enabled.