Administrator Guide

As not all users have permissions to export Jira data, Jira Cloud Administrators can grant necessary permissions to work with SQL Connector for Jira Cloud for specific users or groups. The instructions below demonstrate how to grant these permissions, allowing users to create, edit, watch, and export connectors.

Administrators have the permissions to work with the connector by default.

 

How to Grant Permission

 

  1. Being signed in to your Jira Cloud instance, select Apps, and then select SQL Connector for Jira.

 

  1. On the left-side menu, select Administration, and then select the Edit.

administration-permission-edit.gif

 

  1. In the Users field, enter the username you want to grant permissions to.

You can select as many individual users as you need to.

  1. In the Groups field, select the groups you want to grant permissions to.

You can select as many groups as you need to.

  1. Select Save.

 

 

How to View Data Sources History

 

  1. Being signed in to your Jira Cloud instance, select Apps, and then select SQL Connector for Jira.

  1. Select Administration, and then select Data sources history.

 

How to View Export History

 

  1. Being signed in to your Jira Cloud instance, select Apps, and then select SQL Connector for Jira.

  1. On the left-side menu, select Administration, and then select Export history.

 

You can also apply search by data source name or table name.

 

IP Whitelisting

 

Below are the current IP addresses used by the SQL Connector for Jira Cloud application. We recommend whitelisting them only if you are experienced with the process and confident in managing it effectively.

44.225.25.214 52.37.67.206

 

https://www.alphaservesp.com/blog/choosing-the-best-bi-tool-for-your-jira-reporting-comprehensive-comparison