User Guide

User Guide

Your Jira Cloud administrator should grant you Administer Jira permissions to create, edit, view, and export connectors. Users with Administer JiraΒ permissions always have access to app configurations.

Create Database

Before exporting data, we kindly recommend you to create a separate database for Jira data export and add its configurations to SQL Connector.

Create Data Source

A data source is the primary source of data sets containing tables and fields for further analysis. It represents the data selected by the user for export to SQL database.

Export Data from Jira to SQL Database

Exporting data from Jira to SQL database involves connecting to your SQL database and transferring the datasets included in the data source.

History

The History module has been implemented as a separate tab of the SQL Connector. The module includes the following submodules:

  • Data sources history

  • Export history

Data Schema

Since the SQL Connector for Jira does not automatically create relationships between tables and fields in SQL database, we provide info on how to build them correctly in Entity Relationship Diagram.

Have experience with SQL Connector for Jira? We’d love to hear your thoughts! Please leave us a review on the Marketplace!