...
The Jira data fields are stored in technical manner in the database used by the Jira Server platform. The data structure is following the Jira logic. If you would like to use your data on functional level and a customised customized structure, you have to concept set first which kind of data you like to store in your data warehouse tables. The dimensions of this concept are:
Server ID: all data in a data warehouse table refer to a unique Jira server ID. You can store data from different Jira instances in a central table.
Jira Projects: You can store data of a single or multiple projects in the data warehouse tables. That depends on your need.
Issue Types: You can store data of a single or multiple issue types per Jira project in the data warehouse tables.
Fields: This is the lowest level allow that allows you to decide which fields you export to the data warehouse tables.
...
In the next step you click on “Issue Types”. The issues types of the previously selected Jira project(s) are listed. Please drag and drop to move the issue types to the right side. These issue types will be considered in the app. You can also use >> or << to move to whole issue types list.
...
In the next step you click on “Fields”. The system and custom fields of the previously selected issue type(s) are listed. Please drag and drop to move the fields to the right side. These fields will be considered in the app. You can also use >> or << to move to whole field list.
...
In the final step you have to enter the schema name. If this value is not set the as default, schema of the DB user will be used.
You have to drop the DB connection, you configured before here.
3 – How to activate the Data Warehouse Rule ?
Once you finalised finalized the configuration of the Data Warehouse Rule, you can
...