• 1bitsolution: Software development
  • 1bitsolution: Software architecture
  • 1bitsolution: IT consulting
  • 1bitsolution: Atlassian, Jira, QlikView, Qlik Sense

Qv Jira ConnectorQv Jira Connector

Qv Jira Connector is QlikView API Connector for Jira developed by .

Qv Jira Connector is developed to retrieve Jira data like Projects, Issues, Worklogs, etc. and import it into QlikView environment. Such an interface allows management team to extend standard Jira metrics and dashboards. The functional diversity of QlikView controls allows to perform such an accomplishment and customization very quickly. For instance, operating with Jira data in QlikView and joining it with sales data obtained from some accounting software allow to see relations between product developed, its features/defects and sold instances.

Installation

Installation procedure is simple - just copy Connector executable into the folder: C:\Program Files (x86)\Common Files\QlikTech\Custom Data\QvJiraConnector

Configuring Jira

Go to Settings screen (Administration->System->General Configuration) for enabling API calls (Accept remote API calls should be ON).

Using

Follow the next steps to use Connector in QlikView

  1. Create new document in QlikView and open Script Editor.
  2. Select QvJiraConnector.exe in the drop-down selection box and then click the Connect button. Enter your credentials in the Connect form and further in the Login form. As a result the connection string will be generated. Connect to Jira Connection string is generated
  3. Now click the Select button to open the Create Select Statement dialog. Here you can select Tables you are interested in. Create Select Statement dialog After closing the Create Select Statement dialog the script is generated. Script is generated
  4. Save the document and Reload to fetch the data from Jira. Reload to fetch the data from Jira

Now you have loaded selected data into the document and thus you are ready to build dashboard. Check Table Viewer to see the tables structure.

Table Viewer

JQL (JIRA Query Language) using

SELECT statement for Issues, Worklogs, IssueCustomFields and IssueChangelogs tables allows to indicate WHERE with JQL condition. Find below examples of syntax:

LOAD Issues_Assignee,
Issues_Created,
Issues_Description,
Issues_DueDate,
Issues_Environment,
Issues_JiraIdentifier,
Issues_Key,
Issues_Priority,
Issues_Project,
Issues_Reporter,
Issues_Resolution,
Issues_Status,
Issues_Summary,
Issues_Type,
Issues_Updated,
Issues_Votes,
Issues_TimeOriginalEstimateSeconds,
Issues_TimeEstimateSeconds,
Issues_TimeSpentSeconds;
SQL SELECT *
FROM Issues WHERE jql=project=[PROJECTKEY] AND status="In
Progress";

SQL SELECT *
FROM Issues WHERE jql=Created >= "2015/06/13";

LOAD Worklogs_Author,
Worklogs_Comment,
Worklogs_CreateDate,
Worklogs_Id,
Worklogs_StartDate,
Worklogs_TimeSpent,
Worklogs_TimeSpentInSeconds,
Worklogs_UpdateDate,
Worklogs_Issue;
SQL SELECT *
FROM Worklogs WHERE jql=project=[PROJECTKEY];

LOAD IssueCustomFields_Id,
IssueCustomFields_Value,
IssueCustomFields_Issue,
IssueCustomFields_Id AS CustomFields_Id;
SQL SELECT *
FROM IssueCustomFields WHERE jql=project=[PROJECTKEY];

LOAD IssueChangelogs_IssueChangelogId,
IssueChangelogs_Author,
IssueChangelogs_Created,
IssueChangelogs_Issue,
IssueChangelogs_Field,
IssueChangelogs_FieldType,
IssueChangelogs_From,
IssueChangelogs_To;
SQL SELECT *
FROM IssueChangelogs WHERE jql=project=[PROJECTKEY];

This is commercial option. Contact us for evaluation and using.


Supported Add-ons

Case Studies

QlikView has a lot of power to visualize data in the way you prefer. You can analyze Jira details using the Pivot tables and Gantt charts.

To perform time filtering you can easily generate the master calendars using the QVC library. Also you can drill-down to Users and Issues.


System Requirements

Before installing Qv Jira Connector, ensure your computer meets the system requirements:

  • Microsoft .Net Framework 4.5.
  • QlikView for Windows 11.

License

Qv Jira Connector is copyright © 2014-2015 1bitsolution. Permission is hereby granted, free of charge, to any person obtaining a copy of this software (the "Software"), to use, copy, and distribute for personal using. Contact us for commercial using.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

You may not reverse engineer, decompile, or disassemble the Software.

Quality Assurance

Qv Jira Connector is tested for Jira OnDemand v. 6.4 and QlikView x64 v. 11.20 on Windows 7 and Windows 8.1.

Download

02.11.2016: Qv Jira Connector v. 1.0.0.16

  • Added ResolutionDate field for Issues table.

23.07.2016: Qv Jira Connector v. 1.0.0.15

  • Added Users, Groups, GroupUsers and GroupLabels tables.

23.03.2016: Qv Jira Connector v. 1.0.0.14

  • Fixed bug related to Issues receiving.

18.03.2016: Qv Jira Connector v. 1.0.0.13

  • Added IssueComponents and IssueFixVersions tables.

11.02.2016: Qv Jira Connector v. 1.0.0.12

  • Added support for GreenHopper Issue Custom Fields (Greenhopper_IssueSprints table).

17.09.2015: Qv Jira Connector v. 1.0.0.11

  • Fixed bug related to Issues receiving.
  • Added support for Tempo Timesheets add-on. Now Qv Jira Connector retrieves data like Customers, Accounts and Worklog attributes.

6.09.2015: Qv Jira Connector v. 1.0.0.10

  • Replaced SOAP with REST.

27.07.2015: Qv Jira Connector v. 1.0.0.9

  • Added support for JQL (JIRA Query Language).

12.05.2015: Qv Jira Connector v. 1.0.0.8

  • Fixed bug related to Issues receiving.

10.05.2015: Qv Jira Connector v. 1.0.0.7

  • Added support for Issue Changelog.
  • Implemented ability to retrieve 1000+ items.

21.03.2015: Qv Jira Connector v. 1.0.0.6

  • Added support for Issue Custom Fields.

5.03.2015: Qv Jira Connector v. 1.0.0.5

  • Added support for Jira Agile (GreenHopper) add-on. Now Qv Jira Connector retrieves data like Rapid Views and Sprints.

23.02.2015: Qv Jira Connector v. 1.0.0.4