Import assets and keep them synchronized with a database or a CMDB tool.
Database synchronization definition can be made from External System Configuration tab which is under the Settings menu.
| Setting | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Name | Specify a name for your configuration. | ||||||||||
| URL | The URL to connect to the database. | ||||||||||
| Driver | The driver class to connect to the database. Please do not forget to place JDBC driver (*.jar) to <Jira Installation Directory>/lib folder and restart Jira after placing the driver class.
| ||||||||||
| User | An authorized user for the database. | ||||||||||
| Password | Authorized user password. Password will be kept as encrypted. Every time when want to edit a configuration you must enter the password again. | ||||||||||
| Cron Expression | Determine when synchronization should work. | ||||||||||
| Acting Jira User | A Jira user to perform create, update, delete operations. | ||||||||||
| Is Active | Synchronization can be disabled by this option. | ||||||||||
| Test Connection | Settings can be tested by clicking Test Connection |
Asset Type Mapping
Asset Type Mapping is for the mapping queries with asset types.
You can reach the Asset Type Mapping configuration page by configuring a created database configuration.
| Setting | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Name | Specify a name for the configuration. | ||||||||||
| Asset Type | Select an Asset Type that you want to import. | ||||||||||
| Selector | The selector is a SQL query. Enter the SQL query which you want to execute when connection established to the database. Data will be fetched from this execution result.
| ||||||||||
| Date Format | This field is very necessary when a date value imported from a char field. If you are keeping date values in char fields please specify a date format. | ||||||||||
| Date Time Format | This field is very necessary when a date-time value imported from a char field. If you are keeping date-time values in char fields please specify a date-time format. | ||||||||||
| Delimiter | If multiple values are kept in a char field, delimiter will split them while importing. Delimiter provides importing multiple select attributes like Checkbox, List Box - Multiple. | ||||||||||
| Define Non-Existing Attribute Options | When imported value is not an option for the attribute this option provides you to define these values as a new option for attributes like Checkbox, Dropdown List, List Box, List Box - Multiple, Radio Button. | ||||||||||
| Ignore Attribute Existence | When an attribute is not defined in asset type schemes of selected asset type with this option provides the asset created without undefined attribute value. Otherwise, the asset will not be created. | ||||||||||
| Delete Missing Objects | This option provides full synchronization with the database. If this option is enabled, the synchronization system will delete the manually created assets(the assets which are not imported from the database) in selected asset type. | ||||||||||
| Update Multiple Objects | Identifiers(You will see in the Field Mapping configurations) provides the asset uniqueness. When multiple assets found with the identifier search this option decides they all found assets will be updated or non of them. | ||||||||||
| Ignore Empty Values | If imported value is an empty value, with this option you disallow to import them. | ||||||||||
| Ignore Invalid Values | When an imported value is not invalid for an attribute, the asset will not be created. With this option, the asset will be created without the attribute which have invalid value. | ||||||||||
| Is Active | When this option is disabled synchronization will not work for this Asset Type Mapping. Note: Asset Type Mapping can't be activated without Asset Name Field Mapping is defined. |