Jira is a software management platform that allows you to plan and track the progress of your development teams on the road to release. This article will give you an overview of the Jira/Grow integration and what you can expect.
Contents in This Article
- How to Connect
- Data Warehouse
- Direct Query
- API Documentation
How to Connect
Grow connects to Jira Software Cloud. Before you get started, you will need to obtain your Jira host domain, the email address used for the account you're connecting, and an API token. Click here to see instructions to obtain your API token.
- Click on the Data tab at the top left of the global navigation. Then click on "Connections" in the Data Library section.
- Click on the blue "Connect" button and search for Jira.
- Click on the Jira logo.
- A window will pop up to log in with your Jira credentials. Enter your host domain, email (username) and an API token. (If you are not using a host domain on atlassian.net, enter your full host URL.)
- After entering your credentials you will see a green confirmation message that the connection has been made.
And that’s it! You are good to go.
Jira is on the Grow Data Warehouse, which we highly recommend you use. For more information about warehousing your data, visit the Data Warehouse Help Article.
The following suggested tables are available in Grow. These are toggled on by default when you sync your data for the first time.
- Board Issues
- Board Issues (Formatted)
- Board Issue - Comments
- Board Issue - Fix Versions
- Board Issue - Links
- Board Issue - Subtasks
- Board Issue - Worklogs
- Issues (Formatted)
- Issue - Linked Issues
- Issue - Fix Versions
- Issue - Subtasks
How to Warehouse your Data
- Starting with the Connections Overview Page, navigate to your Jira connection and click on it to open the Connection Details page.
- Select the “Manage Connection” button inside the Connection Details section to open the warehouse table selection flow.
- If your data source isn't already connected, refer to the How to Connect section of this article for more details. If your data source is already connected, you can immediately select which tables of data you want to warehouse.
- Once you have finished selecting the data that you want stored in Grow’s Data Warehouse, click the “Sync & Store” button at the bottom of the Manage Connection page. This will begin the initial population of your warehouse with the tables you defined. Populating your data warehouse for the first time may take a while, even up to several hours.
- While your data is "In Queue" or "Processing", you may continue working within the app.
The default sync interval is 12 hours per table for the following tables:
- Board Issues
When incremental sync is available, the default incremental sync interval is 1 hour, while the default full sync interval is 1 week.
Incremental sync is not currently available for Jira warehoused tables.
To learn more about sync intervals and how to adjust the default settings, please visit this section of the Data Warehouse help article.
A direct query connection can be used to pull data into Grow. With abnormal usage, Direct Query can run into API limitations depending on the data source. For this reason, we recommend that you use Grow's Data Warehouse for a more performant, reliable experience.
Currently supported with no projection to stop maintaining
The Jira/Grow integration has two custom reports available called Issue Search & Board Issues. While only two reports may seem limited, Jira Query Language (JQL) is available when selecting Issue Search, a box will pull up where you can write JQL making it very dynamic.
Examples of possible searches include current and completed issues for a given time period and issues competed by project team. The reports returned in the Grow app include filterable fields such as assignee, status, status category, created date, creator name, issue type, etc.
Selecting Board Issues lets the user to select from a drop down which displays the boards they have created, allowing them to get data on board-specific issues.
This is for reference only; you should not need to consult this to use the connection in Grow.
FAQs + Tips and Tricks
Querying Jira data using Jira Query Language (JQL)
While it is not a database query language, JQL has some similarities to SQL syntax. JQL is used to create advanced searches in Jira.
The Jira/Grow integration has one custom report available called “Issue Search.” While a single report may seem limited, JQL makes it actually very dynamic. Once you select the report, a box will pull up where you can write JQL.
A basic query consists of three parts: a field, an operator, and then one or more values or functions.
A simple query might be the following: project = “TEST”. This would find all of the issues in the project called TEST.
Using these fields, keywords, and operators, you have the potential to build much more complex queries. You can also use the following help documents Jira provides on writing JQL:
- For available fields, check out this document
- For available operators, check out this document
- For available keywords, check out this document
- For available functions, check out this document
You can also read Jira’s documentation here.