How to force the Full Load on Enterprise Insights
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
A Full Load in ETL (Extract, Transform, Load) involves transferring the entire dataset from source systems to a destination, such as a data warehouse, without filtering or incremental logic. It's a straightforward process consisting of three steps: extracting all data, transforming it according to business rules, and loading it into the destination system, often replacing existing data.
In Enterprise Insights (EI), a full load can be done when some initial setup goes wrong or when the user needs to force the sync of all data again. As shared above, the full load will overwrite existing data in the EI database.
This article provides the information needed to perform a Full Load in a self-hosted instance of EI.
Environment
Enterprise Insights Self-Hosted
Solution
To force the Full Load on the Enterprise Insights Self-Hosted, the user must run the following update on the Enterprise Insights database:
1
2
3
Update [dbo].[ETL_Settings]
Set [ETL Setting Value]='1/1/1900'
Where [ETL Settings ID] = 2After running it, the user must wait for the next JOB scheduled to finish its sync. This can take a long time, depending on the amount of data that must be synced from Jira Align to the EI database.
Was this helpful?