Hi,
Currently, we have Jira hosted internally and the DB is an oracle. We do some data manipulation and migrate a subset of data over to other DB for reporting and analysis
Once Jira will go on the cloud, A) can you please suggest how will that possibly impact our current reporting and analysis process and B) what will be the backend DB on the cloud
Thanks in advance
You should not be trying to report off a Jira database. It's a bad idea because the database is a mess and very very not intended for reporting.
So, the very blunt answers are:
A) your reports will not work until they're modified to work off the front-end.
B) you do not need to care - you won't have access to it.
Whether you decide to go to Cloud now, or move to DC, your reporting needs to stop looking at the database and move over to using the REST API instead. Where-ever you land, the REST API is what you need to use instead of broken SQL
Hi Nic,
thanks for the suggestion. I will discuss it internally with our team. It helps
as for the alternative, for the sake of exploring option, if we go with the sql route (knowing it’s not the best option). Can you please suggest the database that jira uses in the backend on the cloud? Do they give an option to pick from one
thanks again
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I do know what database they use for Cloud, but it's utterly useless information for you.
You can't choose what they use, you can't get to it, and you don't have any use for knowing what it is.
You can't go with the sql route, you will not be able to use it.
You will have to throw away all your SQL. It's useless. You'll need to build your reports properly, using the REST API or built-in or app reporting. (Which is something I'd strongly recommend for server as well - SQL is the worst possible way to report on Jira data)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you please let me know which dB do they use on the cloud?
i have already share your suggestion of using rest API with my team
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you tell me why you want to know? What would knowing what the database is actually help you with?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Re-reading this, I realise I should apologise for the lack of explanation, which I think looks rude and ignorant on my part. If I have come across that way, I am sorry, I really do not mean to.
I have not answered the core of the question, because the answer is completely useless to you. The database is (mostly) a modified and AWS-suited Postgres variant.
But that does not matter, as you've got no access to it. It's a bit like asking where your electricity comes from - your house is powered by a potential difference over some power lines, but there's no chance you're ever going to see all the power stations that provide that pd. Knowing the database behind a Cloud Jira is actually less useful than knowing that your electricity supplier favours wind or solar.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No worries... we are a tech-family, all good
Now that it's clear that I won't have access to the DB on cloud. how would you suggest accomplishing the following using REST API
1) we want to export Jira data (ticket #, hours worked, dates, etc.) to our reporting data warehouse.
2) export only incremental/changes data to the warehouse.
Thanks again for your assistance
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1) You can read all your Jira issue data with REST
2) Base your regular queries on the updated date. Use JQL such as "updated > -1h" if you are running the scrape hourly
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.