Can I connect jira to multiple databases?

Question

I am creating a plugin where I need a user to input data and update an external oracle database. Currently, my jira instance is connected to a postgres database for all of it's normal jira functionalities. I need to establish another connection to a separate oracle database to write to that database. Jira is never writing the same data to both databases.

Is this possible?

How can I do it?

Peter DeWitt · Answer

the developer community is here:

https://community.developer.atlassian.com/

Not sure about the db configuration.  Re-ask on the developer community.

.pd

Simon Huang · Answer

@Peter DeWitt

Peter, Can you provide me a link to the dev board? Not sure where it is.

I see that you are a engineer at atlassian so I do want a second opinion from you. Do you think it's possible to setup a second database in the dbconfig.xml or a similar file and in my plugin code I initialize a JDBC driver connection to the data to query the database?

Peter DeWitt · Answer

Simon, post over on the Jira Dev board.  You'll get more eyes for the specifics.