Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

To be able to analyze Tempo apps data is necessary for the company owners to ensure making informed and timely decisions. That’s why it is important to integrate all Tempo plugins with business intelligence tools such as SQL, and SQL Connector for Jira is the proper solution for such integration.

Exporting Tempo Timesheets data from Jira to SQL can help solve the following issues:

  • You can forecast project complete terms

It’s a common practice for teams to underestimate the amount of time a project or certain tasks will take. With the data provided by time records in Tempo Timesheets, you can not only analyze your previous experience but also make assessments on how long it will take to finish the given task or project. You will have a basis for projections and can set more reasonable deadlines.

  • You can track billable hours

Analyse Tempo Timesheets data for billed hours by customers, projects, teams, assignees etc, as well as easily work with non-billed hours to minimize the risks of underpayment or missed hours.

Tempo Timesheets fields are located in a separate tab.

The following fields are available for export ⬇️

Field Name

Field ID

Field Type

Tempo

Tempo Account

<customfield>

String

Tempo Iteration

<customfield>

String

Tempo Team

<customfield>

String

Tempo Team Role

<customfield>

String

Teams

Team Name

TEAM_NAME

String

Team User Key

TEAM_USER_KEY

String

Team User Name

TEAM_USER_NAME

String

Team Role Id

TEAM_ROLE_ID

Int64

Team Role Name

TEAM_ROLE_NAME

String

Tempo Work Attributes

Work Attribute Name

WORK_ATTRIBUTE_NAME

String

Work Attribute Type

WORK_ATTRIBUTE_TYPE

String

Work Attribute Value

WORK_ATTRIBUTE_VALUE

String

Work Attribute Required

WORK_ATTRIBUTE_REQUIRED

Boolean

Worklog Id

WORK_ATTRIBUTE_WORKLOG_ID

Int64

  • No labels