JIRA Connector
Intro
JIRA is a proprietary issue tracking product, developed by Atlassian. It provides bug tracking, issue tracking, and project management functions. Use Domo's JIRA connector to compile reports on users or tickets opened or modified in the last month. Yohttps://developer.atlassian.com/jira...e-query-issues.
u can also create your own queries to compile custom reports. To learn more about the JIRA API, seeThe JIRA connector is a "Cloud App" connector, meaning it retrieves data stored in the cloud. In the Data Center, you can access the connector page for this and other Cloud App connectors by clicking Cloud App in the toolbar at the top of the window.
You connect to your JIRA account in the Data Center. This topic discusses the fields and menus that are specific to the JIRA connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.
Primary Use Cases |
|
Primary Metrics |
|
Primary Company Roles |
Product managers |
Average Implementation Time |
This can vary wildly depending on the implementation and the user's level of knowledge of their JIRA system. |
Ease of Use (on a 1-to-10 scale with 1 being easiest) |
7 |
Best Practices
-
You should usually use "Replace" with the JIRA connector, as "Append" does not work well.
-
If the query is for data across a long time period, scheduling should be kept to a minimum (once a day). For shorter queries, more frequent updates are appropriate.
Prerequisites
To connect to your JIRA account and create a DataSet, you must have the following:
-
The username and password you use to log into JIRA
-
The URL for your company's JIRA instance
-
The JQL query you will use to pull data (if you are building a custom report)
Credentials are received upon account creation. A JIRA Admin is likely to have created username and passwords for most users in your company if you use an on-premise JIRA implementation.
SSO
Single Sign-On (SSO) credentials will NOT work. However, you can work around SSO limitations by doing the following:
-
Have your JIRA administrator create a local account with a username and password specifically for API use.
-
Create an API key at http://id.atlassian.com/.
-
On the JIRA connector page in Domo, enter the API key you created instead of the password. (Depending on the account, you may need to enter your username or JIRA account email address as the username.)
Connecting to Your JIRA Instance
This section enumerates the options in the Credentials and Details panes in the JIRA Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.
Credentials Pane
This pane contains fields for entering credentials to connect to your JIRA instance. The following table describes what is needed for each field:
Field |
Description |
---|---|
Username |
Enter the username you use to log into your JIRA instance. |
Password |
Enter the password you use to log into your JIRA instance. |
Server URL |
Enter the URL for your JIRA instance. |
Once you have entered valid JIRA credentials, you can use the same account any time you go to create a new JIRA DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.
Details Pane
In this pane you select a query type, enter your query if you are creating a custom DataSet, and specify other options as necessary.
Menu |
Description |
---|---|
Query Type |
Select whether you want to create a custom report (JQL Issue Query) or use Domo's premade Users Report. The Users Report pulls data on all users of your company JIRA instance, such as first and last name, email address, date of last password change, etc. |
Search Query |
Select a premade search query (Issues modified in the last month or Issues where the status equals open) or select Custom to write your own query. |
JQL Query |
Enter a JQL query to pull custom data. For example:
This query retrieves all open issues that are classified as bugs, defects, or Improvements and sorts them by their creation dates. For more information about writing JQL queries, see https://confluence.atlassian.com/display/JIRA/Advanced+Searching. |
Data Option |
Select your report type. Standard Ticket Report is a large report that contains columns for nearly every parameter for JIRA tickets, such as issue summary and description, creation date, resolution date, impacted customer name, environment, etc. Ticket History Report is a much shorter report that provides historical information about tickets.
|
Other Panes
For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.
Troubleshooting
-
Jira requires a fair amount of configuration from the side of the JIRA admin to ensure that API access is enabled. Common issues include setting the timeouts too short or not providing sufficient resources to the JIRA server.
-
If users have trouble understanding how to format JQL, the easiest thing is to log into the JIRA front end. Via the search bar, JIRA provides a tool that can construct a JQL query with preset filters. After constructing your query, if you hit the Advanced button, JIRA presents you with your selections in JQL format.