Need Help in accessing Custom fields in JIRA Server using ODBC

[Scott.Barker@verscend.com]

Using JIRA Server, would like to pull Issues and related Custom Fields data for reporting.  I need help in identifying the Custom Field values tables in JIRA  7.2.7 using an ODBC Connector.  I see the Jira.Fields tables and the custom field names.  But need help identifying what table has the "values" for these custom fields.

Thanks!

[Nic Brough -Adaptavist-]

Please, don't. 

Jira's database is a data store, not a reporting enabled thing.  SQL is the single worst possible way to report on Jira.  Please, get one of the reporting add-ons, get a scripting add-on, or pull data over REST.

That said - try customfieldvalue if you must.  You'll have great "fun" working out the rest of the type dependent joins.

[Scott.Barker@verscend.com]

We are developing a Dashboard in MicroStrategy and planned to use an ODBC connector to pull the data from JIRA.  What reporting "add-ons" do you recommend to pull data from JIRA?  I am not familiar with REST.  Have you used REST?  Are JIRA Cloud and JIRA Server similar?  We are migrating to JIRA Cloud.   We have added Custom Fields to JIRA and need to pull this data from JIRA.   Is there a JIRA data model available to help with the joins?  Thanks for your help!

[Nic Brough -Adaptavist-]

I tend to use Exalate and EazyBI, as they understand the data model for you. 

Hopefully, https://developer.atlassian.com/server/jira/platform/database-schema/ will put you right off the idea of using the database.

Yes, REST is far easier - you can use JQL to run queries and get back single JSON record for each issue with whatever fields you need.  (As opposed to potentially having to make 50 joins to jira issue, up to 4 layers deep)

Jira Server and Cloud are similar, but gradually diverging.  I don't expect them to diverge much, and certainly not on the basics of the issue data.   Fortunately, you have no access to Jira Cloud's database at all, so you have to do it properly.

[Lauma Cīrule]

@Nic Brough -Adaptavist-, Thanks for suggesting eazyBI as a possible solution!

Scott.Barker@verscend.com, please see eazyBI documentation and a demo account if you are interested in exploring eazyBI further. Let me know if you have any particular question!

Lauma / support@eazybi.com