Jira Database Schema - Modifying a View

Question

I want to modify the View "IssueChangelogs" to add a few fields from the "Issues" table.   Do we need to request a job to take care of this with Atlassian or can an Admin Role handle this.

This is for that back end database.  I use CDATA JIRA ODBC driver and it works great but I would like to not have to link the "Issues" table if I can help it for performance reasons.

Thanks Help.

Marc -Devoteam- · Answer

Hi @jriccardo

To full fill you wishes, you can look at 3rd party applications like; Power BI Connector for Jira.

Trudy P Claspill · Answer

I have not heard of any tools that support connecting directly to the database for Jira Cloud. Atlassian typically does not allow or support that.

I found a Marketplace listing for ODBC Driver for Jira from CData. The app has been Archived and was only ever supported for Jira Server.

https://marketplace.atlassian.com/apps/1216650/odbc-driver-for-jira/version-history?versionHistoryHosting=server

If the view is something that you are getting from that app, as the listing says you might still be able to get support from the app vendor.

jriccardo · Answer

There is no Version nbr so I assume we are Cloud.  I am using the CDATA ODBC driver for Jira Software successfully with Crystal Reports and Power BI