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?

[__ Jimi Wikman · Accepted solution]

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]

@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