Versions Compared

Old Version 5

changes.mady.by.user Inna Kashuba

Saved on

compared with

New Version 6

changes.mady.by.user Liliia Ostrovska

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Since As not all users should have permission permissions to export Jira data, Jira Cloud Administrators can grant permission necessary permissions to work with the SQL Connector for Jira Cloud for specific users or groups of users. Instructions The instructions below show demonstrate how to grant permission to work with the connector (ability these permissions, allowing users to create, edit, watch, and export connectors).

InfoPlease note that users with the Administrator role

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

Table of Contents
minLevel1
maxLevel7

How to

Enable SQL Connector for Jira and

Grant Permission

  1. Being signed in to

Jira UsersIn Jira's primary navigation menu, click Apps and find

  1. your Jira Cloud instance, select Apps, and then select SQL Connector for Jira

in your app list

  1. .

Image Removed

Select Administration from

  1. On the left-side

navigation

  1. menu, select Administration.

Image Removed

At the SQL Connector for Jira’s Administration page click the Edit icon.

Image Removed
In the Edit permissions window, click the Select groups field and select groups from the available groups in the list. Image Added

  1. Select the Edit permissions button.

Image Added

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

Info

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

You can select as many

groups

individual users as you need to.

Image Removed

To Select users click the Select users field and start to type the username

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

work with the connector. Select user

  1. .

Info

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.

You can select as many

individual users

groups as you need to.

Image Removed

To save the permissions, click the Save button.

Image Removed

How to Check User Permissions to Work

  1. Select Save.

Image Added

Info

Here you can also view who has permission to work with SQL Connector for Jira

If you wish to check which Jira users and/or groups have granted permissions to use the application, go to Apps → select SQL Connector for Jira → click on the Administration tab on the left.

Image Removed

How to Configure Databases

Go to Apps > SQL Connector for Jira > Databases.

Image Removed

Click Create a Database button.

Image Removed

Enter all the required data: title, database type, host, port, database name, username, password. And click Validate connection. If you see the ‘Success!’ message, click Save.

Image Removed

You can view and edit all the created databases in the Databases tab.

Image Removed

Configure Tokens to Export Add-Ons Data

SQL Connector for Jira supports exporting data from the leading marketplace add-ons. You can check the complete list of apps on the Supported Add-Ons page.

To be able to include Jira app data in your export to SQL, Jira users need to configure each add-on separately.

  • Tempo apps configuration

  • Projectrak app set-up

  • Time in Status app configuration

  • Zephyr Scale token

    • Xray app set-up

    , edit, and delete permissions.

    Image Added

    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 Source 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 Added

    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.

    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 Added