Versions Compared

Old Version 8

changes.mady.by.user Liliia Ostrovska

Saved on

compared with

New Version Current

changes.mady.by.user Liliia Ostrovska

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel7

📘 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.

Table of ContentsminLevel1maxLevel7

Panel
panelIconId2699
panelIcon:gear:
panelIconText⚙️
bgColor#DEEBFF

Regular users can now view and search the history of their own and shared data sources. However, permission remains in the Administration module.

To familiarize yourself with the new History module

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.

Image Removed

Select the Edit permissions button

  1. , and then select Edit.

Image Removedadministration-permission-edit.gifImage Added

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

Once you start typing, the drop-down list with username suggestions will appear. Select the user from the list.
Info

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.

Once you select the Group field, the drop-down list with available groups will appear. Select a group from the list.

In our case, it’s the system-administrators group, you select the one you have inside your Jira instance.
Info

You can select as many groups as you need to.

  1. Select Save.

Image Removedsql-admin-edit-permissions.gifImage Added

Info

Here you can also view who has permission to work with SQL Connector for Jira, edit , and delete revoke permissions.

Image Removed

How to View Data Sources History

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

Image Removed

  1. Select Administration, and then select Data Sources History.

Info

The tab displays all changes performed to the data sources by all users, including creating, editing the fields or filters, sharing, changing owner, and more.

Image Removed

How to View Export History

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

Image Removed

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

Info

The tab displays all data related to the export process: ID, user name, data source ID, tables count, rows count, and more. Filtering by statuses (All, Success, and Failed) and dates (Start date and End date) can help to find specific data.

Image Removedsql-admin-permissions-overview.gifImage Added

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.

Code Block
44.225.25.214
52.37.67.206

Info

Find out what is the best BI tool for Jira reporting in our blog ⬇️

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