User Guide
Before you start, your Jira administrator should grant you Administer Jira permissions to create, edit, watch, and export connectors. Users with Administer Jira permissions always have access to SQL Connector for Jira.
Add Database Configuration
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.
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.
We currently support a wide range of Jira Data Center versions, which requires significant resources. To optimize our efforts, we’ve made a data-driven decision to limit support to versions 9.4.X and later.
Version 9.4.X is a Long-Term Support (LTS) release. Although its official support ended last year, it’s still actively used by many customers.
As a result, this change may affect users on older Jira versions. To use the latest versions of our apps, users will need to upgrade their Jira instance. Existing app versions will remain available and fully functional without requiring an upgrade.
Read a comprehensive step-by-step guide on how to use SQL Connector for Jira in our blog