How do I connect with jira database

[Amrit Khatri]

Hi I am preety new on Jira plateform.

I am trying to get access database in Jira to fatch actual raw data to use to create report (Burndown Chat speciallly) in our company website. The Licence Type is Atlassian OnDemand

But I don't know where do I go or what do I need to acccess those data.

In addition I have administration access, do i need any thing else except user name and password to login in the Jira website.

[Daniel Wester]

Relying on access to the database to pull out data will cause you a lot of headaches (the schema updates between major revisions, plugins can change the schema at any point etc). If you can pull the data through the rest api that would be the better approach.

[Nic Brough -Adaptavist-]

Very true - database access is a last resort because it's full of pitfalls.

[Amrit Khatri]

Hi Daniel Sorry to intarupt you, I am nable to find the rest api in Jira. Can you help me please, how do I find this api in Jira.

[Daniel Wester]

https://docs.atlassian.com/jira/REST/latest/has the "JIRA" core api's. Now add-ons etc can have their own. The best approach is to use the sdk locally to bring up a local JIRA instance, install the appropriate plugins and then use the rest browser in the sdk.

[Amrit Khatri]

Hi Daniel , Can you suggest me how to use sdk locally. I am beginner of this IT sector so I am very childesh in all..

[Nic Brough -Adaptavist-]

HAve a look at https://developer.atlassian.com/display/DOCS/Getting+Started- it's aimed at getting you writing plugins etc, but it'll get you started with an SDK you can use for REST in general as well.

[Amrit Khatri]

I am not able to get total story point , finished story point and remain story point dynamic throught rest app, Might be I am not so perfect on those thing. Is there any other easy option to get those data.

Help me ...

[AnnWorley]

If your instance is hosted by Atlassian OnDemand the URL will end with atlassian.net, or if the instance is very old, jira.com. You will not be able to directly access the database but Atlassian Support will help you do anything you need.

[Nic Brough -Adaptavist-]

If you are using a self hosted Jira, then you must have given it the database connection settings when you set it up. You can use those, although I'd recommend creating another user which only has *read* access (because writing to a Jira database while it's running can destroy it)

If you are using Jira OnDemand (cloud), then you will not get access to the database.

If you are using another hosted Jira, then you need to talk to your hosting company. Some may let you do it.

[Amrit Khatri]

Hi Nic, thanks for your comment.

How do I know I am using Jira OnDemand(Cloud) or another hosted Jira?

In addition, Is there any way to access data with any AIP.

Forthermore, to create Burndown chat in our website with the Jira database record, which is a needy at the movement, where I need three data field for Burndown chat. Total Story point, done story point and remainning story point.

If there any other way to do this Please help me I am working on it since 4 weeks and I have not get any right solution. Might be becuase I am very new for this tool.