Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

86 views 1 6
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