How to import Time to SLA DC data to Private eazyBI

This article is for Data Center version of Time to SLA.

This documentation guides you through importing Time to SLA data into Private eazyBI for your Data Center instance. Here, we'll focus on transferring custom fields containing SLA data from your Jira projects to corresponding accounts in Private eazyBI.

Use Case

Customer is on a DC instance.
They want to transfer the SLAs custom fields from their respective projects to the accounts in Private eazyBI.
When utilizing the Standard eazyBI plugin, users can proceed directly by following this documentation: https://appfire.atlassian.net/wiki/x/f4A9Aw. The interface of Private eazyBI has minor variations specifically related to custom field configuraiton.

Steps

Install and set up eazyBI.
Define an eazyBI Integration Field custom field in your Jira instance in the Jira Administrators menu > Issues > Custom Fields > TTS-eazyBI Integration.

Before moving on to the third step, you must get the ID of the custom field you just created. To see it, you can click Edit, and check the URL – the ID will be at the end of the URL.

Switch to eazyBI and within eazybi.toml file, add the custom field that was created in Step 2 with its ID. In the following example, the ID of the eazyBI custom field is 11400.

[source_application.jira.site_99]
url = "http://localhost:8080/jira"
[source_application.jira.site_99.customfield_11400]
data_type = "string"
dimension = true
name = "TTSEazybiCF"

On the Private eazyBI UI, navigate to Source Data, and click Custom Fields.

After the changes, an import for Jira source data is performed.

After importing, create a new eazyBI calculated field by clicking Add a new calculated field under Source Data > Custom Fields for different attributes of your SLA data.
After creating the new field, perform an import to bring in the newly created field in case the auto-import feature is not activated.

You can use the following properties in your eazyBI reports:

Description	Key	Type

Description	Key	Type
SLA ID	slaId	Long
SLA Name	slaName	String
SLA Calendar Name	workingCalendarName	String
SLA Status	slaStatus	Enum
SLA Duration	slaValueAsDurationString	String
SLA Duration	slaValue	Integer (Seconds)
SLA Start Date	startDate	Date
SLA End Date	endDate	Date
SLA Target Date	targetDate	Date
SLA Elapsed Duration	workingDuration	Integer (Seconds)
SLA Remaining Duration	remainingDuration	Integer (Seconds)
SLA Overdue Duration	overdueDuration	Integer (Seconds)
SLA Paused Duration	pausedDuration	Integer (Seconds)
SLA Elapsed Percentage	elapsedPercentage	Integer
SLA in Critical Zone?	inCriticalZone	Boolean
SLA Paused	paused	Boolean
SLA Started?	started	Boolean
SLA Finished?	finished	Boolean
Calendar Business Day Hours	businessDayHours	BigDecimal (Hours)