external database


I have already configured my JIRA database. This is SQL Server 2012 database. Now I would like to add more connection (for example to my warehouse data). To do this I only need to add new jdbc-datasource to dbconfig.xml file

Thank You for help



1 answer

0 votes

I'm not sure what the question here is.  You've set up JIRA to use a MS-SQL database.  Great.  

So what's the other connection actually for?  JIRA doesn't need it.  What are you trying to achieve by adding more datasources?

I need to display some information in JIRA from my warehouse data. So now I use post functions to connect my external database but it's a little uncomfortable when I need to change or relocate my external database form one server to another. So I need to configure 2-3 datasource in one place ant then use It in my post functions.

Ahh, I see. That's a good plan, as using the datasource in the Tomcat frees you from having to set it all up internally over and over again. I don't know much about the code you'll need, but I know it's possible to do this, as there are fields which draw data in from other places. The one I'm most familiar with has a config page which I think might help you (but, I am sorry, I am stuck on the code side of it) https://confluence.kepler-rominfo.com/display/DBCF/Data+Source+Configuration

I know that there is something like Kepler controls, but I need something different to use it for normal JIRA fields.

I pointed to that as an example of configuring the datasource. Normal JIRA fields are irrelevant here though, they won't use or care about your new datasources. I'm not sure what you're even aiming to do with them. You said you're displaying information from the external database - that's fine, but I assume it's a display ro custom field you're writing yourself.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,085 views 13 18
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot