nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is it possible to get access to the underlying Jira Cloud database, as opposed to using the REST API

Brandon Shinault

It takes several hours to get all epics, stories, bugs, etc. from Jira Cloud through the REST API. Yes, I know it can be broken down to pull by issue type, but that still takes a long time. Is there an underlying Jira Cloud database service, similar to EI for Jira Align, that can be connected to in order to speed up the process?

Accepted answers

__ Jimi Wikman

I am afraid you can't get access to the cloud database.

Have you cleaned out all closed issues that are older than 6-12 months first? No need to download dead items after all

All comments

__ Jimi Wikman

I am afraid you can't get access to the cloud database.

Have you cleaned out all closed issues that are older than 6-12 months first? No need to download dead items after all

Brandon Shinault

That would help some, but of course it's hard to determine what 'dead' really means. Sometimes people will re-animate something from a backlog that's very old or possibly dead. Would need to restrict that or purge old items of course. Is it possible to use Azure Synapse to sync data from Jira Cloud?

__ Jimi Wikman

I usually set a policy that means that any issue that has a closed date older than 12 months will be deleted every quarter.

As long as everyone knows about it, then it is never an issue, especially if people document properly and don't leave documentation in Jira for some reason.

I have never tried Azure Synapse to sync, so I can't answer that. Maybe setup a test for it and see if it works?

Craig Castle-Mead_20fp9z

@Brandon Shinault

You may want to check out if Jira’s GraphQL support can help. This is one of those use cases a mature GraphQL should be a slam dunk.

https://developer.atlassian.com/platform/atlassian-graphql-api/graphql/#examples

CCM

Brandon Shinault

@Craig Castle-Mead thanks, I'll look into that

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud