Data Source Page Overview

Owned by Liliia Ostrovska
Last updated: Dec 12, 2024
5 min read

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

 

Data Sources Page Configuration new

 

Before creating a data source, you can customize the view of the data sources list by selecting which information to display on the Data Sources page. This helps you focus on what’s most important. You can adjust the columns view at any time for your convenience.

sql-configure-columns.gif

 

Example of customized columns: Simply check or uncheck columns to display the desired information.

sql-configure-columns-example.gif

 

The changes apply to all types of data sources: your own, those shared with you, and archived data sources.

This applies only to the UI on your side. The column configuration doesn’t impact the data sources themselves.

 

General Settings

 

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

  • Description - This field allows you to enter a description for your data source. These might be some hints you might need in the future. This field is optional.

 

Share Settings

 

These settings allow you to share your data source with users or groups who have permission to use SQL Connector.

  • Users - This setting allows you to share your data source with other users. You can select as many individual users as you need to. The user can be searched by login or full email.

  • Groups - This setting allows you to share your data source with groups. You can select as many groups as you want to.

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.

 

Search and View Settings

 

Search Section

The Search box - This box allows you to quickly find, and then add to your export issue filters you need.

 

View Settings

View Settings - This feature allows you to adjust table visibility, table sorting, and field details.

 

  • Table visibility - This feature allows you to expand or collapse all tables at once by selecting Expand all or Collapse all respectively.

 

  • Table sorting - This feature allows you to sort tables in a way convenient for you. There are two options: Default and Selected first.

    • Default - The tables are arranged in a default way.

    • Selected first - The tables are arranged so that the already selected tables appear first on the page.

 

  • Field details - 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.

 

  • The Show translations option was added to the SQL Connector for your convenience.

By default, the SQL Connector uses untranslated field names during export. The Show translations feature allows you to view the translated names for easier identification of the fields you need.

 

Select Tables Section

 

These settings allow you to select or cancel selecting Jira standard tables and fields (Jira Work Management, Jira Software, Jira Service Management) and also tables and fields of different apps installed on your Jira Cloud instance (e.g. Xray, Projectrak, Tempo, and more)

 

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 -This option allows you to check the source name, source description, issue filters, and export items.

  • 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 Features

 

All these settings are applied to already existing data sources.

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

 

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

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

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

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

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

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

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

  • Preview ERD - This function allows you to view the Entity Relationship Diagram for a data source.

  • Set SQL Database - This function allows you to connect the database to your Jira data source for further exporting.