Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Pulling data from Jira Cloud into a SQL DB

Drishti Maharaj July 11, 2023

Hi,

So in our previous Jira Server integration, we had a project that was pulling data from the Jira DB into a SQL DB which was then used in another application. 

With our migration to Cloud, we are trying to find out if we would still be able to have this functionality available possibly using API keys?

Would we need to generate an API key from Jira and then provide that to them to use on the DB?

Really unsure how this works.

Thanks.

1 answer

1 accepted

3 votes
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 11, 2023

Fortunately, no, you have no access to the Jira database in Cloud.

You will have to scrape your data over the REST API.

Viktor Fedun September 12, 2023

if it's not possible is there a way to make alternative to 
SELECT
cfv.stringvalue AS "Template Name",
COUNT(*) AS Count
FROM
jiraissue AS ji
INNER JOIN
customfieldvalue AS cfv
ON
ji.id = cfv.issue
INNER JOIN
project AS p
ON
ji.project = p.id
WHERE
cfv.customfield = (SELECT id FROM customfield WHERE cfname = 'Template Name') AND
cfv.stringvalue IS NOT NULL
GROUP BY
cfv.stringvalue
ORDER BY
Count DESC;

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 14, 2023

Probably, but I would suggest asking that in plain English, no-one wants to have to guess what question you are trying to answer from a pile of SQL that requires an understanding of SQL and the database you're running it against.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events