connect company database with JIRA 4.3.4 mysql database

[Kalyan Kumar Das]

We are using JIRA 4.3.4 mysql database and my company database is using MSSQL.

I want to connect the JIRA database with my company database i.e MSSQL. So that we can populate the Employee information on JIRA such as project name, project manager name, birthday,Employee-ID, employee project start and end date etc. Whenever the ticket is raised then it will populate everything as per the client requirement or user can view the employee information by searching the employee name.

Kindly suggest me or provide me the link so that i can follow the steps for connecting the JIRA  and my company database.

Also provide me the plugin name for auto-search the employee name.

[Nic Brough -Adaptavist- · Accepted solution]

Do not do this, it will make your upgrades more complex and has no real benefits.

If you add new tables to the Jira database, you will have to re-create them every time you upgrade, the backups won't cover them (unless you start adding code) and you are still going to have to write loads more code to get to it (you'll also be unsupported, but you are already as you're on a very old and insecure version of Jira which you really ought to upgrade)

I would strongly recommend either

• Using a separate database and code to read it remotely (there's several add-ons in the marketplace that do this, although I'm not sure any of them go back as far as Jira 4.x)
• Finding or writing your own add-on that handles the data internally so you don't need to read another database.

[Kalyan Kumar Das]

@Nic Brough -Adaptavist-:

Thanks Nic for providing the suggestions. Most of the cases, add-ons are compatible with 6.2 and above versions. 

[Nic Brough -Adaptavist-]

Ok, that's another good reason to upgrade.

[Prashant Mali]

Hi @Kalyan Kumar Das ,

Welcome to Atlassian Community.

Below KB article help you to connect your JIRA application with company's database.

https://confluence.atlassian.com/adminjiraserver073/switching-databases-861253056.html

Thanks,

Prashant

[Kalyan Kumar Das]

@Prashant Mali:

Is there any other way for add my company database in JIRA 4.3.4 database because we don't want to migrate. Please suggest us or provide me the link.