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; } } }

How to sync database with Jira

David Pleşu

Hi,

I want to manage the lists from jira - values of custom fields, users, groups, all the lists in a database - MySQL for example, and i want to know if there is a possibility to sync the databse with the jira cloud, maybe with some coding - Rest API, or something like this.

Thank you.

Accepted answers

marc -Collabello--Phase Locked-

Hi @David Pleşu ,

Yes, you can sync Jira information with databases. For this you can use the REST API: https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/ . This requires programming.

All comments

marc -Collabello--Phase Locked-

Hi @David Pleşu ,

Yes, you can sync Jira information with databases. For this you can use the REST API: https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/ . This requires programming.

David Pleşu

Thank you

Matthias Gaiser _K15t_

Hi @David Pleşu

instead of synchronizing all the values, you could also simply reference data from an SQL database. There are apps in the marketplace which can handle this use case. I've used Elements Connect in the past for it with success, but you should probably judge yourself if you want to go that way.

Cheers,
Matthias.

David Pleşu

In my jira instance are 200+ users, it will cost around 1700 per year. I don't know if i can to restrict this app only for my use. Maybe you know if it's possible ?

Matthias Gaiser _K15t_

All the marketplace apps are always licensed based on the number of users of the whole instance. There's no way around it unless the apps would implement another licensing mechanism.

You can check the marketplace if there are some cheaper alternatives - or still script your own solution. If you only have a couple of fields, scripting might be wort it. If it's too much, I think such an app comes handy since you don't need to maintain a script by yourself.

Julie d_Antin _Elements__bsgnak

Thanks for the mention @Matthias Gaiser _K15t_

@David Pleşu Atlassian app pricing does not allow you to limit app availability or usage to only some of your users, and the pricing is necessarily based on the number of users in your instance.

While you may not have planned a budget to meet this need, the customization and time saved from a quality app that meets your needs should be a good investment in the long run.

And to answer your question about getting data from a MySQL database, Elements Connect lets you connect to the following versions

You'll find details of the information you need to prepare in advance to query your database on the documentation.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud