Integrating Cloud with Data Center for time tracking

Question

Our agents log work in their Cloud Service Desk; however, our reporting is done out of the on-premise back end SQL Server database for Jira Software Data Center.

To avoid aggregating data from both Jira instances for a complete time tracking report, I'm looking for a solution.  I'd like for Agents to log time to DC issues within the Cloud.

Here are some of the potential possibilities; however, I'm not sure any of them will actually work.

Atlassian Tunnel - the Tunnel allows for a connection btwn Cloud and DC; however the functionality seems to be limited to linking issues from one instance to the other.

Automation - An automation rule can be setup to log time to linked issues (the Tunnel provides the linking), but it doesn't seem to recognize the Data Center projects/issues from within Jira Cloud.

Some other possibilities:  Triggers, Webhooks, Jira Edge Connector??

Possible Plugins:  Anyone have experience with these:

ScriptRunner - We have ScriptRunner app on both Cloud and DC and perhaps this is possible with a custom script.

Watch Tower w/ Time Reports for Remote Jira

Backbone Issue Sync for Jira

Jira-Jira issue sync 2-way integration+migration

OpsHub - Enterprise class Integration and Migratio · Answer

Hi @Andrea Hakim

Have you explored an option to migrate from the Data Center to the Cloud? Having two separate systems requires aggregation for generating a single report. To simplify the process, we recommend you to migrate your DC data to Cloud, so you can log a work directly in the cloud itself. So, in the future reporting can be done easily from one place only.

If migration is not feasible, then you can explore scripting or a webhook that triggers sync to DC whenever the work log is updated. However, this solution is recommended for small scale migration where data size is less, and reporting is not needed quite frequently. Sometimes, it slows down the performance of Jira and is not reliable all the time as recovery and other issues may arise in this.

For enterprise-level solutions, you can explore JCMA or any Atlassian Partner that supports migration. OpsHub  an Atlassian Silver Solutions Partner supports migration/integration with Jira and other 60+ ALM tools. We support migration of all system and custom issue types, sub-task types of issues, versions, sprint and worklog too. OpsHub has extensive experience in undertaking complex migration projects ensuring zero downtime, Live ++ migration with continuous access to source system, no data loss, systematic cut-over and factory approach. We are happy to help in your migration planning process.

We support 5.x, 6.x, 7.x, 8.x, 9.x, 10.x versions of Jira Data Center and Cloud Jira as well. You can refer to the Atlassian Partner Directory.
Feel free to get in touch.

Hope this helps!

Carla Ann Rowland · Answer

First: in the Cloud is log time turned on? Jira cloud can track time: here are several links to help: https://support.atlassian.com/jira-software-cloud/docs/log-time-on-an-issue/  and https://support.atlassian.com/jira-cloud-administration/docs/configure-time-tracking/  and https://support.atlassian.com/jira-cloud-administration/docs/configure-time-tracking/#Enable-or-disable-time-tracking-in-projects

Automation rules I think will not work.