SQL Connector for Jira (DC)
SQL Connector for Jira (DC)
Breadcrumbs

Creating Data Source

  1. Being signed in to your Jira instance, select SQL Connector, and then select Data Sources.

sql_connector_for_jira_dc_create_ds_1.gif

  1. Select Create Data Source.

sql_connector_for_jira_dc_create_ds_2.png

  1. In the Name* field, enter your data source name.

  2. Select + to add database.

If you have already created the database where you’d like to export your Jira data, simply select it from the drop-down list.

sql_connector_for_jira_dc_create_ds_3-4.png

  1. In the Title* section, enter the title for your database.

  2. [Optional] In the Comment field, enter any useful information.

  3. In the Database Type* field, select the type of your database.

  4. In the Host* field, enter the host of your database.

  5. In the Port* field, enter the host of your database.

  6. In the Database Name*, enter the name of your database.

  7. [Optional] In the Database Schema*, enter the data schema.

By leaving the Database Schema* field empty, the default data schema will be applied.

  1. In the Username* field, enter your username.

  2. In the Password* field, enter your password.

  3. Select Test connection to check if everything is correct.

sql_connector_for_jira_dc_create_ds_5-14.png

If everything is correct, you will get the corresponding message.

Test connection success.

  1. Select Create.

Test.png

  1. [Optional] In the Users field, enter the username you want to share the data source with.

  1. [Optional] In the Groups field, select the group you need.

  1. [Optional] In the Project Roles field, select the roles you need.

  • You may share this data source with users who have permissions to work with SQL Connector for Jira.

  • Users with administrator permissions have access to all data sources by default.

Other users who have access to SQL Connector might not get all the data from this data source due to different Jira permissions.

sql_connector_for_jira_dc_create_ds_16-18.png

Enable auto-export to have your data source exported at the set time interval.

sql_connector_for_jira_dc_create_ds_auto-export.png

  1. Select all filters and tables you want to be in your data source, and then select Save.

You can select different filter groups:

  • All (by default) - will return all data, select it, if you want to export all existing issues.

  • JQL - Jira Query Language, is a flexible tool that allows you to search for issues, projects, etc. in Jira and pinpoint exactly what you are looking for. Select it, if you want to use JQL to create your own request and filter data.

  • Basic - select it, if you want to use standard fields filters.

sql-create-ds-filters.gif

If you need additional information about Jira filters, please refer to this section.

sql-create-ds-tables.gif