We enable the improved schema by default for connectors set up after September 10, 2020. See our June 2020 release note for details about the improvements, which were previously opt-in, but are now default.
We have added a new column,
is_public, to the
We have improved the mechanism that detects similar fields that might cause data integrity issues. When we detect that similar field names would become duplicate names after normalization, we do not sync them to your destination. Instead, we show a warning on your dashboard and ask you to rename the fields. This prevents duplicates in the destination and avoids writing the values of the different fields into the same history table.
To prevent data integrity issues, we will sync some standard fields in the following way:
Σ Original Estimatefield to the
Σ Time Spentfield to the
Σ Remaining Estimatefield to the
Σ Progressfield to the
We have also improved the mechanism that detects the Jira changelog to avoid syncing values from one field into multiple history tables.
We have changed the styling of the connector name from "JIRA" to "Jira" in the Fivetran dashboard to match Atlassian's official styling.
We have added a new way to sync issue field values and their historical changes. Previously, customers whose
ISSUE table had a large number of fields found that it was generating an overwhelming amount of
ISSUE table contains only columns for the Jira standard fields.
We added a
FIELD table that contains information about all fields.
We sync all values from the custom non-array fields and their history items to a single
We sync all values from the array fields and their history items to a single
We sync initial null values from history items to the history tables to provide a better historical analysis.
If you would like to use this new method, contact our support team to enable it. Then, create a new connector or re-sync the existing one.
We have improved the mechanism that detects the changelog. Now, if a
fieldId is not present in the Jira response, we will find the changelog entries using a
fieldname. This improvement prevents data integrity issues when the current field value is written into the history table as initial.
You can now configure your Jira connector using the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
Previously, when there were multiple changes in the source during the sync, our connector sometimes missed some data. We have fixed this problem by changing our pagination strategy. To ensure that all your data is synced, re-sync your connector.
When the value of a field was null, our Jira connector didn't always update array values. That meant that, for example, if the value was removed from a field in the source, sometimes the destination still showed the previous value. Now when a field value is null, our Jira connector will write a default empty value according to the type of the field.
Our Jira connector can now sync issues from January 1, 1970 forward. Previously, our connector only synced issues from January 1, 2002 forward. If you have issues from 1970-2002, perform a re-sync to ensure that we capture all issues.
We can now sync empty array type fields, such as
labels. This means that any removed values will be accurately reflected in the destination. Previously, we could not sync array fields with null values, which meant that some values deleted in the source were not deleted in the destination.
We now track deletes in the
WORKLOG table. This means that any deleted work logs will be accurately reflected in the destination.
We now support SLA fields in Jira issues. We are gradually rolling out this feature to all our customers.
When it's available for your connector, you will see an additional
sla table in your destination.
You can see the
SLA table on our Jira ERD.
To sync all SLA fields, resync your connector.
We now support capturing deleted issues by using webhooks. We are gradually rolling out this feature to all our customers. When it's available for your account, you will see a switch on the Jira connector setup form labelled "Capture deletes". To enable capturing deletes, toggle the switch.
- We have added the
WORKLOGtable. To sync the
WORKLOGtable, create a new connector or re-sync the existing one.
We have dropped the primary key constraint from the
value field in the
We now remove the relationship between an issue and an issue label if the issue is removed in Jira.
If you deploy your Jira to a custom root path, you can now specify that path in our setup form: