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

Jira in the cloud and backend DB

talha Parvaiz

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 what will be the backend DB on the cloud

Thanks in advance

Accepted answers

All comments

Nic Brough -Adaptavist-

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.

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

talha Parvaiz

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

Nic Brough -Adaptavist-

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)

talha Parvaiz

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

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud