Migrating zAgileConnect from JIRA On-Premise to JIRA Cloud

Following options describe the steps for migrating zAgileConnect Salesforce-Jira links from on-premise Jira to Jira Cloud.  The steps will depend on whether the migration of Jira Issue data from Jira Server to Jira Cloud retains the same Issue Keys and Issue IDs, since these are also captured in the corresponding links in Salesforce.  For more details on Jira Issue IDs versus Issue Keys, please refer to How to retrieve Jira Issue IDs

Option 1 - If the Jira Issue Keys and IDs migrated from Jira Server to Jira Cloud will remain the same

Option 2 - If Issue IDs will change and Issue Keys will remain the same during the migration to Jira Cloud

Option 3 - If both Issue Keys and Issue IDs will change during the migration to Jira Cloud - please contact us to discuss steps

Migration Option 1

This process assumes that Issues being referenced in Salesforce have not been removed or imported with different Issue IDs and Issue Keys during the JIRA migration. In other words, it assumes that JIRA Cloud and JIRA On-Premise match with respect to Issues.

Migration of Salesforce Object-Issue links maintained by zAgileConnect from on-premise JIRA to JIRA Cloud involves the following steps:

1. Connect and configure the Salesforce org to the new Jira Cloud instance
2. Run the “Refresh Salesforce Properties in Jira“ to push relationships into Jira Cloud

These steps are described below.  It is strongly recommended that the following steps be exercised first in test environments.

Connect and configure zAgileConnect with Jira Cloud

The same Salesforce instance that was previously connected to Jira Server can be re-connected to Jira Cloud following the Jira Cloud installation instructions zAgileConnect Installation & Configuration 

Please note that after after authentication steps are completed, the remaining zAgileConnect package configuration (Steps 3 thru 6) that is inherited from the Jira Server should either be ‘Saved’ as-is or modified and Saved to allow these configurations to also be pushed to the new Jira Cloud instance.

Refresh Salesforce Properties in Jira

After Salesforce is connected to Jira Cloud the final step is to create the relationships into JIRA Cloud. For that you need to go to: Setup → Installed Packages → zAgileConnect Configure → Refresh Salesforce Properties in JIRA

Click on Refresh, it will send all the Salesforce Object-Issue relationships to JIRA. This process will be executed in background and can take several minutes/hours depending on the number of relationships.

Migration Option 2

This process assumes that Issues referenced in Salesforce will be migrated to Jira Cloud with different Issue IDs but same Issue Keys

Migration of Salesforce-Jira links maintained by zAgileConnect to JIRA Cloud (from Jira Server or another Jira Cloud instance) involves the following steps:

1. Backup zAgileConnect junction objects

2. Create a CSV file with Case-Issue relationships

3. Connect and configure the Salesforce org to the new Jira Cloud instance

4. Remove zAgileConnect junction objects data

5. Import the Case-Issue relationships from the CSV file

These steps are described below.

Backup zAgileConnect junction objects

In Salesforce setup go to Data Export and export the data for ZIssue__c, ZIssue_SF__c and ZIssue_Case__c

Create a CSV file with Case-Issue relationships

Generate a CSV file with only 3 column headers CASENUMBER, ISSUEKEY, ISSUEWASCREATED.

You can use the following SOQL query to retrieve the case-issue relationship data:

SELECT zsfjira__Case__r.CaseNumber, zsfjira__ZIssue__r.zsfjira__IssueKey__c, zsfjira__IssueCreated__c FROM zsfjira__ZIssue_SF__c WHERE zsfjira__Case__c != null

Workbench can be used to export the data to CSV file via SOQL query.

Make sure to rename the CSV headers to CASENUMBER, ISSUEKEY, ISSUEWASCREATED.

Connect and configure zAgileConnect with Jira Cloud

The same Salesforce instance that was previously connected to the original (source) Jira instance can be re-connected to new Jira Cloud (destination) following the Jira Cloud installation instructions zAgileConnect Installation & Configuration

Please note that after after authentication steps are completed, the remaining zAgileConnect package configuration (Steps 3 thru 6) that is inherited from original Jira should either be ‘Saved’ as-is or modified and Saved to allow these configurations to also be pushed to the new (destination) Jira Cloud instance.

Remove zAgileConnect junction objects data

Delete all the records for ZIssue__c Salesforce object. This delete will also delete in cascade the data for the junction objects (ZIssue_SF and ZIssue_Case).

Execute the following APEX code via an anonymous block using developer console or workbench to remove existing Salesforce-Jira relationships.

delete[SELECT Id FROM zsfjira__ZIssue__c];

The DML operation above may fail if there are too many (>10,000) records to be deleted. In such scenario, you can change the SOQL to append a “LIMIT” clause to it to reduce the number of records returned by the query and execute it multiple times.

Import the Case-Issue relationships from the CSV file

Before importing make sure any custom trigger, process or flow on ZIssue__c, ZIssue_SF__c and ZIssue_Case__c objects are disabled to avoid any unexpected error when importing the CSV.

Follow this guide to import the relationships CSV file Importing Existing Case-Issue Relationships into zAgileConnect

Please note that the example in the link above has only two columns but you will be importing the CSV file with 3 columns (CASENUMBER, ISSUEKEY, ISSUEWASCREATED).

** Please make sure to perform these steps in a test environment (Salesforce sandbox; preferably fullcopy and test Jira) prior to migrating the production data.