Sync users from an Oracle Database

Hi,

Our Service Desk just switched from OmniTracker to JIRA (Service Desk), all our internal users have been synced and are available as a potential reporter in JIRA through an LDAP directory setup in JIRA & Crowd.

But we also have about 6000 freelancers which contact our service desk from time to time. They do not have an LDAP account but we do keep track of them in an oracle database. Is there a way I can make them available as reporter in JIRA and keep the data in sync?

Best,

Maarten

2 answers

1 accepted

This widget could not be displayed.

Hi Maarten,

There may be a bespoke solution that a 3rd party can advise on.  However, whilst you can run JIRA using an Oracle database, the only external user directories that JIRA will cache and synchronise with are as follows:

  • LDAP (Microsoft Active Directory and all supported LDAP directories) where permissions are set to read only.
  • LDAP (Microsoft Active Directory and all supported LDAP directories) where permissions are set to read only, with local groups.
  • LDAP (Microsoft Active Directory and all supported LDAP directories) where permissions are set to read/write.
  • Atlassian Crowd.
  • Atlassian JIRA.

So in a standard installation the answer is No, there is no way to have an Oracle user directory attached to JIRA.  If your instance is behind a firewall you might want to consider granting reporter rights to anonymous users, or if you don't want to do that then you could add them to a separate LDAP instance and use multiple directories.

This widget could not be displayed.

To be a reporter in JIRA, you need to give them JIRA user accounts.  I'd add them to a user directory.  They could go into your LDAP, but if you don't want to do that, you could set up another LDAP directory for them (or other type of directory) or even just add them to the internal directory.  You'll probably want a script that can read them from the database and add them to JIRA, or better, a directory server that can read the database.

As you have Service Desk, the question that springs to mind is "are these freelancers effectively customers"?  They'll only need customer accounts then.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

165 views 2 0
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