Do we have any techniques where we can connect Jira that is hosted on Server to the Oracle Analytics Cloud or do we have any technique where we can have the Jira database tables loaded to Oracle cloud database.
You will need to connect to it over the REST interface and pull out the data you want.
You can not get any access to the Jira database on Cloud (and rightly so - it is not designed for reporting and attempts to report against it are always painfully inefficient, slow, and can destroy the performance of the system. Plus most people get them wrong because they don't understand the database)
Thanks a lot Nic for the information. But our Jira is set up on Premise and not on cloud. Please let me know if there is any techniques where we can extract the underlying tables of Jira and dump it Oracle cloud database.
Ah, sorry, I completely misread that, and connected "Cloud" to the wrong place. (It's been a long day, I'm a little tired)
The point about not reporting off the database is still true. That way lies madness (and huge amounts of work that will result in your users getting a lot of really badly inaccurate reports unless you train everyone to understand the database at an Atlassian developer level)
Please, don't just copy, or even directly access the database. Use the REST interface to extract the data you need and put it into tables suitable for reporting.
Thanks Nic again for the information. So you want to say we should be using rest interface to extract the tables from JIRA and put it into oracle cloud database. Please let me know if you have any Jira documentation which have the list of tables and the information they store . Also it would be great if you have any handy document which has the REST interface documentation to extract the JIRA tables.
It looks like you're new here. Sign in or register to get started.
