How to modify jira database for custom field data

Question

Hi,

We have created some custom field in jira.

We need to get some data on those custom fields while creating new issue.

Like, Application Manager, Application server name etc.,

For that we want to add details in Jira database [MSSQL].

Please let me know which plugin we need to use to modify/update jira database.

In other words, we need to integrate external data into jira database.

Please let me know how to do that.

Best Regards,

Mahendran

Nic Brough -Adaptavist- · Answer

Any of them that fit with what you're trying to do.

You have not described what you are trying to achieve with enough detail for us to begin to suggest what apps might be best suited.

Nic Brough -Adaptavist- · Answer

I think there's something missing from the conversation here:

* >> For that we want to add details in Jira database [MSSQL].* No, you absolutely do not want to do this.  You can, in theory, but it's a terrible thing to do, will take a massive amount of effort to write and maintain, and renders your system unsupportable.

* >Please let me know which plugin we need to use to modify/update jira database.* None.  None of them modify the Jira database directly.

* >In other words, we need to integrate external data into jira database.* No, you do not.

You want to work with external data.  That's fine, but don't think of it in terms of the Jira database, that way lies madness.

The way to "work with Jira's database" is to work with the APIs - code apps or scripts or even configuration against either the internal Java APIs or the external REST APIs.  If you want to use other data sources, that's also fine, code your apps/scripts to talk to them remotely.

Better, use apps other people have written to do this for you.  Look for Jira apps that can talk to the systems you've got providing your CMDB, UPS, and ATRAC.

If you're working with other databases and they lend themselves to having useful structures you can easily use (this is something the Jira database absolutely does not have), then look for the apps that provide various levels of database access that might work for you - Elements Connect and Scriptrunner for example, provide some Jira custom fields that can work with data held in a remote database, external-data for Jira is good at pulling data out of databases and showing it in Jira as well, and so-on.

But I would start with a clear definition of what you're trying to achieve and what Jira should be looking at your other systems for.

Mahendran Balu_riodtw · Answer

Hi Thomas,

Thanks for the suggestion.

We are using jira software in server only. Not in cloud.

Please suggest best app/plugin for our environment.

It will be great if I get document how to use the app to import/integrate external data into jira's custom field.

Best Regards,

Mahendran