Capacity Planner - Jira Team & Resource Management | Tempo
- Nataliya Timoshina
- Liliia Ostrovska
- Inna Kashuba
Tempo Capacity Planner Overview
To be able to analyse Capacity Planner - Jira Team & Resource Management | Tempo app data is necessary for the company owners to ensure making informed and timely decisions. That’s why it is important to integrate all Tempo apps with business intelligence tools such as SQL databases, and SQL Connector for Jira is the proper solution for such integration.
Learn more about Tempo apps data analytics on Tempo blog.
Tempo Capacity Planner fields can be found in the Tempo tab.
How to Add Tempo Client ID
Tempo Client ID is required to view and export the Tempo Capacity Planner data.
Being signed in to your Jira Cloud instance, select Apps, and then select SQL Connector for Jira.
On the left-side menu, select API Integrations, select Tempo, and then copy the redirect URL.
Select Apps, and then select Tempo.
For your convenience, open Tempo in a new tab. To do it, right-click on Tempo, and then select Open link in new tab.
Select .
Scroll down, select OAuth 2.0 Applications, and then select + New Application.
In the Name field, enter any name you’d like.
In our case, it’s SQL Connector, you can select any other name.
In the Redirect URLs, field, paste the redirect URL.
The redirect URL for this form was copied in step 2.
In the Client type field, select Public.
In the Authorization grant type, select Authorization code.
Select Create Application.
The Credentials pop-up window will appear.
Copy the client ID and client secret, and then close the window.
Return to API Integrations, and then select Tempo.
Paste your client ID and client secret to the corresponding fields, and then select Validate & Save.
Select Authorize Access.
The Success! message will appear.
Select Onwards!
Starting now, all users with granted permission to work with the data sources can select Tempo (Tempo Capacity Planner) and Tempo Financial Manager tables and fields for export.
Tempo Tables Overview
Table Name | Table Fields References |
|---|---|
Tempo Teams |
 
|
Tempo Team Members |  
|
Tempo Team Projects | 
|
Tempo Accounts |  
|
Tempo Account Projects |  
|
Tempo Work Attributes |  
|
Tempo Worklogs Tempo Worklogs are exported together with Jira Issue Worklogs. You can find it under the Jira Work Management tab. Check also how worklogs dates are exported. |  
|
Tempo Work Log Work Attributes |  
|
Tempo Plans |  
|
Tempo Programs |  
|
Tempo Holiday Schemes |   
|
Tempo Holidays |  
|
Tempo Workloads |  
|
Tempo Timesheet Reviewers |  
|
Tempo Timesheet Approvals |  
|