Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,300,432
Community Members
 
Community Events
165
Community Groups

Associating issues with customers from an external table

Hi team

We are using JIRA to keep track of issues that sometimes are related to specific customers (rather than just generic software issues). For the sake of analytics, we would like to be able to map the issues to the customer in a way that allows us to then cross-reference other systems (non-Atlassian).

At the moment, we are using a custom field and write the name of the customer, but this is inefficient (a small typo and we lose track). We have our customers listed in an external system, on a database table.

How could we set up something so that this custom field in JIRA tickets would be populated only by values from a list which is automatically refreshed (say every week) from an external source? I've been looking around for answers but haven't found a definitive one yet...

Thanks!
Acácio

1 answer

0 votes
Dario B Atlassian Team Apr 01, 2021

Hello @Acácio Porta Nova ,

There is no OOB way to load data from an external DB into a custom field in Jira Cloud at this point in time.

However, as already discussed in the below thread, there are a number of 3rd party apps you can install from the Atlassian Marketplace that can allow you to do so:

Please notice that there may be more apps available to help you achieve the same, search the MARKETPLACE for more.

 

Also, having the right skill-set you can build your own integration/app. For details and instructions please see: https://developer.atlassian.com/cloud/jira/platform/

 

I hope this helps.

 

Cheers,
Dario

Thanks for the mention @Dario B 

@Acácio Porta NovaWhat kind of external DB are you using to keep track of your customers? For example is it a Postegre or MySQL database? If it is, Elements Connect for Cloud would work. If you have any questions about how to get your data to display in the custom fields, don't hesitate to contact our support.

Laura

Like Dario B likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Marketplace Partner Spotlight: AppLiger

This month the spotlight is on AppLiger. We caught up with Pavel Pavlovsky, CEO and Product Manager, to learn how the company started and what fuels the team's creativity.    Atlassian:...

398 views 0 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you