Pulling data from Jira Cloud into a SQL DB

[Drishti Maharaj]

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.

[Nic Brough -Adaptavist- · Accepted solution]

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]

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-]

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.