nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

What plug-ins does jira software typically use to link to external databases

haiyaner

What plug-ins does jira software typically use to link to external databases?And the implementation of data insertion, extraction

Accepted answers

DPKJ

There 2-3 parts to your question,

What connection type Jira uses?
- Jira being a Java application uses JDBC database connections
- It doesn't require any plugin, it is integrated in Jira itself.
- For MySQL and Oracle, you need to prove JDBC connection library during installation (because of license restrictions by Oracle)
What options plugin-ins have to connect to Jira database?
- If you want to access Jira data via your plugin, Jira provide plugin java API's to do so. https://docs.atlassian.com/software/jira/docs/api/8.3.2/
- If you want to create new tables in database, Jira provide ActiveObjects - https://developer.atlassian.com/server/framework/atlassian-sdk/active-objects-plugin-module/
What does Jira internally uses (like hibernate etc)
- I have seen traces of hibernate in Jira, but it is not exposed to plugin developers.

All comments

DPKJ

There 2-3 parts to your question,

What connection type Jira uses?
- Jira being a Java application uses JDBC database connections
- It doesn't require any plugin, it is integrated in Jira itself.
- For MySQL and Oracle, you need to prove JDBC connection library during installation (because of license restrictions by Oracle)
What options plugin-ins have to connect to Jira database?
- If you want to access Jira data via your plugin, Jira provide plugin java API's to do so. https://docs.atlassian.com/software/jira/docs/api/8.3.2/
- If you want to create new tables in database, Jira provide ActiveObjects - https://developer.atlassian.com/server/framework/atlassian-sdk/active-objects-plugin-module/
What does Jira internally uses (like hibernate etc)
- I have seen traces of hibernate in Jira, but it is not exposed to plugin developers.

haiyaner

Hi, now that I have jira installed, how do I configure it if I want to use groovy script to read and write to an external database

DPKJ

@haiyanerTo use Groovy Scripts in Jira you will need plugin called`ScriptRunner` - https://marketplace.atlassian.com/apps/6820/scriptrunner-for-jira?hosting=cloud&tab=overview

ScriptRunner provide you with recipes to connect with external database and use its data in Jira - https://scriptrunner.adaptavist.com/latest/jira/recipes/misc/connecting-to-databases.html

You can also watch this video - https://youtu.be/qNEdQeY-fMA

Julie d_Antin _Elements__bsgnak

@haiyaner, do you need to populate custom fields in Jira with data from external sources, like SQL databases, LDAPs, or REST APIs?

I work for Elements, and our app Elements Connect might be what you are looking for. You can see examples of how Connect links Jira to external databases on the demo portal.

Let me know if you have any questions.

haiyaner

thanks ,i'll try it

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-software