Jira

Jira is a project management software that is quite popular among many companies. Jira is designed to help users capture, assign, and set priorities to their work. It allows you to manage the whole process of application development making sure that all things are covered, from concept to launch. Its simple, intuitive interface enables collaboration with teammates and allows you to get the job done in an effective manner.

How to Connect

There are two ways to connect to Jira: via the Sources connection wizard in the Web UI (recommended), or using SQL statements in the CData Virtuality Studio or the Code Editor in the Web UI. Here, we describe the first way; for the second way, see the subpage.

1. Go to the Sources tab and click + New Source:

2. Find the Jira button in the list of connectors or type ‘jira’ in the search field:

3. Click the button to open the chat and set up the connection with the help of our support team.

Usage 

The JIRA API connector introduces a new virtual schema jira that contains the following stored procedures:

In addition to these public API procedures, there is the jira_examples virtual schema that shows an exemplary usage of the public API:

If not needed, you can delete all the example views directly by dropping jira_examples.