This connector is currently in beta and subject to change.

The Sisense Jira connector is a standalone connector that allows you to import data from Jira into the ElastiCube Manager. After you have downloaded and installed the connector, you can connect through a connection string you provide Sisense in the ElastiCube Manager. The connection string is used to authenticate users who want to connect to Jira.

Once you have connected to Jira, you can import a variety of tables from the Jira API.

This page describes how to install the Jira connector, how to connect to Jira with a connection string, and what tables you can import into the ElastiCube Manager:

Installing the Jira Connector

Sisense provides the Jira connector as a standalone connector that you can download and add to your list of default Sisense connectors.

To install the Jira connector:

  1. Contact us for the Jira installation file.
  2. Open the installation file and click Install.
  3. After the installation process is complete, click Close.

The Jira connector is displayed in the ElastiCube Manager under Add Data > Web Services.

Adding Jira Tables to Your ElastiCube

After you have installed the Jira connector, you can import your data from Jira by connecting with a connection string. The connection string contains your Jira users credentials. Jira uses the connection string to authenticate your account and allow you to extract the relevant data for your account.

The connection string to Jira is in the following format:

jdbc:jira:APIKey=xxxxxxxxxxxxxxxxxxxxxx;

For example:

jdbc:jira:User=xxxxxxx;Password=xxxxxxx;Url=https://jira.companyname.com;Timeout=0;

You Jira connection string should include the following parameters, separated by a semicolon ;.

User: You Jira username.

Password: Your Jira user password.

URL: The URL for your JIRA REST API endpoint.

Timeout: The value in seconds until the timeout error is thrown, canceling the operation.

To add Jira data:

  1. In ElastiCube Manager, click Add Data and then, Jira. The Connect to Jira window is displayed.
  2. In Datasource Connection String, enter your connection string.
  3. Click Connect to Server. Jira is displayed in the Select Database list.
  4. Click OK. Sisense connects to Jira and displays a list of tables available for you to import.
  5. Select the relevant tables and click Add. The tables are displayed in the ElastiCube Manager.

Jira Tables

The Sisense Jira connector allows you to import the following tables into the ElastiCube Manager.

Available Tables

NameDescription
AttachmentsDelete and query the available Attachments in JIRA.
CommentsCreate, modify, delete and query the available Comment types in JIRA.
IssuesCreate, modify, delete and query Issues in JIRA.
WorklogsCreate, modify, delete and query the available Worklogs in JIRA.

Available Views

NameDescription
ConfigurationQuery the available Configurations in JIRA.
DashboardsQuery the available Dashboards in JIRA.
FieldsQuery the available System and Custom Fields in JIRA.
GroupsQuery the available Groups in JIRA.
IssueChangelogsQuery the available IssueChangelogs in JIRA.
IssueFixVersionsIssueFixVersions
IssueSubtasksQuery the available IssueSubtasks in JIRA.
IssueTransitionsQuery the available IssueTransitions in JIRA.
IssueTypesQuery the available Issue Types in JIRA.
MyPermissionsQuery the available Permissions in JIRA.
ProjectsQuery the available Projects in JIRA.
RoleDetailsQuery Role Details in JIRA.
RolesQuery the available Roles in JIRA.
UsersQuery the available Users in JIRA.
VotesQuery the available Votes in JIRA.
WatchersQuery the available Watchers in JIRA.
WorkflowsQuery the available Workflows in Jira.