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.
How to Export Data from Jira to SQL Database
.gif?version=1&modificationDate=1708687911685&cacheVersion=1&api=v2&width=98)
Data Schema
| Tip |
|---|
Have experience with SQL Connector for Jira? We’d love to hear your thoughts! Please leave us a review on the Marketplace! 😊 |
| Info |
|---|
Read a comprehensive step-by-step guide on how to use SQL Connector for Jira in our blog ⬇️ |
How to Export Data from Jira to SQL Database
1. Create Database in SQL Connector
Initially, you have to add your database configuration to SQL Connector. We kindly recommend to consider it as the first step.
If you already have a database for Jira data exporting, you can simply add its configuration to SQL Connector by accessing the Databases page.
| Info |
|---|
If you need more information on how to add your database configuration, please refer to our step-by-step instruction. |
| Info |
|---|
If you want to configure a separate database for Jira data export first, please use our comprehensive guide on how to do it. |
2. Create Data Source
Now you need to create a data source for the data you want to transfer from your Jira Cloud to your SQL database. You can do it by accessing the Date Sources page inside the SQL Connector for Jira.
You have to name your data source, adjust sharing settings, and filter the tables you’d like to be in your data source.
| Info |
|---|
If you need a detailed description of all fields and features of the Data Source page, please refer to this page. |
| Info |
|---|
If you need more information on how to create a data source, please refer to our step-by-step instruction. |
3. Export Data into SQL Database
After adding the database configuration and creating the data source, you can easily export your data into SQL database. Being on the Data Source page, select Export data.
| Info |
|---|
If you need more information on how to export data, please refer to our step-by-step guide. |
