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; } } }

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.

Accepted answers

Nic Brough -Adaptavist-

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

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

All comments

Nic Brough -Adaptavist-

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.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management