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
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
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)
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.
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
Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events