My Client is dumping all error details in a Oracle Database from various application and systems they have. I need to create JIRA Issue for each of those error records in that Oracle Database. There are various options I am Exploring:
For Using JIRA API, what are the APIs available? How can call this API, say from a database by passing parameters? I am thinking I will need to create a middleware java program to pull these records from the database. But what is that peice that I need to build at the JIra end and how do I expose it to this java program to call and create the issue? Or is there something available out of the JIRA that I can call from a middleware by passing parameters. My client has Oracle OSB middleware. Can we call soemthing from this layer to create Jira Issue?
There's two basic approaches.
1. Write a plugin for Jira, or create Jelly scripts. This is reasonably easy until you get to the part about transmission - how does this *know* that there is data to be imported? Do you run it regularly and execute some form of search? Does it need to listen for messages on some form of bus/queue etc?
2. Probably the better option - write something outside Jira that can poke the data in. Jira exposes a REST interface which is ideal for this - you can use whatever language / system you have available (as long as it can issue REST calls) to enter the data whenever you need it. Java, c, python, shell scripts, I've even seen this done with database triggers.
For REST, have a look at https://developer.atlassian.com/display/JIRADEV/JIRA+REST+API+Tutorials and https://docs.atlassian.com/jira/REST/latest/
JIRA Command Line Interface (CLI) has the runFromSql action which can create issues from information in a database. Or you can script individual createIssue actions. However, you probably need some external scripting to collect the data in an easier to deal with format with some queuing protocol so you can track what has been done and differentiate from new requests. You need to be careful to not miss data and not have duplicates. I have done this with a simple database table as the queue with timestamps and done flags etc... . Whatever you do, make sure you can track and log everything that is done up front or you will regret it later :).
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG