Document toolboxDocument toolbox

Data Source Page Overview

Title Settings and More

 

Below you can find a description of the fields, buttons, and settings of the data source creating page.

 

  • Name* - This field allows you to enter the name of your data source. The field is required.

  • Database* - This field allows you to select the required database and its configuration for exporting Jira data.

 

 

sql-create-ds-name-database.gif

 

  • Users - This setting allows you to share your data source with individual users.

  • Groups - This setting allows you to share your data source with groups you have within your instance.

  • Project Roles - This setting allows you to share your data source with users who have the appropriate project roles.

  • Allow re-sharing this data source - This setting allows users to share data source that was shared with them.

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

 

sql-create-ds-share-settings.gif

 

Auto-Export Section

 

  • Enable Auto-Export - This feature allows you to enable or disable auto-refresh of your data source. Once it’s enabled, your data source will be automatically exported to the pre-defined dataset.

 

 

  • Export interval - This option allows you to select the frequency, ranging from Every 15 minutes to a Daily basis.

 

 

  • Daily at specific time - This option allows you to select a specific time of the auto-export.

 

 

  • Cron - This option allows you to enter cron expression if you need to.

 

 

Search and View Settings

 

Search Field

 

  • Search field - This search box simplifies the search for the required field you want to be displayed in the report.

View Options

 

  • View options - This setting allows you to adjust the appearance of the issues. You can select what option to display: Show IDs or Show Types. The Show Names option is a default. All options can be selected at once.

    • Show IDs - This is how your fields will appear in SQL databases.

 

 

Select Issues Section

 

  • This section allows you to select or cancel selecting issues (tables) for exporting. This section displays standard Jira fields and all installed and configured plug-ins.

    • Jira Work Management - This part of the section displays a list of regular Jia Core fields and items.

    • Jira Software - This part of the section displays a list of regular Jira Software fields and items if Jira Software is licensed.

    • Service Service Management - This part of the section displays a list of regular Jira Service Desk fields and items if Service Management is licensed.

 

 

Save and Preview Section

 

After creating and editing your data source, you can select one of the following options what to do with it.

  • Save - This option creates your new data source or updates if you edit an existing data source.

  • Preview ERD - This option allows you to view the Entity Relationship Diagram for your connector support data source, which is generated based on the checkboxes you have selected before.

 

 

Additional Feature

 

All these settings are applied to already existing data sources.

 

  • Export data - This option exports the data source to SQL database.

 

The Actions (three dots) panel introduces you to different actions:

  • Edit - This function allows you to make changes to the data source.

  • Clone - This function allows you to make a copy of the data source.

  • Archive - This function allows you to mark the data source as archived, data source will be moved to the Archived tab.

  • Preview ERD - This is another way to view the Entity Relationship Diagram of your data source.

  • Auto Export - This function allows you to configure auto-export (auto-refresh) of the data source.

  • Export History - This function allows you to view export history entities.

  • Delete - This function allows you to remove the data source.

  • Share Settings - This function allows you to distribute the data source to users who have permission to use this app.