データベース インポート
You might want to import data from an internal or third-party system, like BMC Remedy or Service Now. This article guides you through importing data from another database. More about importing
データベース インポートを作成し、設定して有効化するには、Jira 管理者である必要があります。
次のセクションにジャンプ:
はじめる前に
Here are some additional details that you might need to know to import a database:
Predefined structure and configuration aren’t available for this import type.
You can add any SQL to join multiple tables and conditions to extract the necessary fields.
サポート対象データベース
We're using a common framework (JDBC) to connect to the database. For database address location, port, and database name, go to Connecting Jira applications to a database.
To connect to the Jira database, check the dbconfig.xml in your Jira_HOME directory to find the correct configuration and URL. Below are examples of URL configurations for different database types.
データベース タイプ | ドライバー | URL example |
|---|---|---|
Microsoft SQL Server |
|
|
Oracle | oracle.jdbc.OracleDriver |
|
PostgreSQL |
|
|
MySQL |
|
|
Importing data from databases
For testing purposes, you can use the following example of a database table. In this case, the attributes are the columns: name, color, and date.
# | name | 色 | created_on |
|---|---|---|---|
1 | apple | red | 2023-03-02 13:32:22.455 |
2 | lemon | green | 2023-03-02 13:32:22.455 |
If the attribute “name” is selected as the Label, two objects will be created: “apple” and “lemon”. This will result in a configuration like this:
From your service project, go to Assets, then Object Schemas.
From the Object Schemas list, select More actions and then select Configure.
In the Schema configuration view, open the Import tab.
Under the Import tab:
If there’s no import structure, you’ll see the message “You don't have any import connections yet”. Select Create Import configuration to create a new import structure.
If an import structure has already been created, select Create Configuration.
Select CSV import, then select Next.
Fill in the General, Module, and Scheduling import fields.
7. Select Save Import Configuration.
Next, you’ll need to manually create or review the object type and attribute mapping of your import configuration.
作成されたインポート設定
You can now view your import configuration, but it's not ready yet. Because the predefined structure and configuration aren’t available for this import type, you need to manually create or review the object type and attribute mapping, and make sure there are no problems with your import configuration.
You need to select the object type you created earlier and add the database query that will return the data you want to import. After that, you can map the fields.
Make sure the identifier is set in the right database column. At least one column must be set as an identifier.
When you're ready, go to 2. Create object type and attribute mapping.
最後に一言
次のステップでは、オブジェクト タイプと属性マッピングを作成します。データベース インポート タイプに固有の設定をいくつか紹介します。
オブジェクト タイプ マッピングの設定
The construction of the selector (the SQL statement) depends on the configuration of your database connection. Below are some examples that should guide you in the right direction when setting this up.
データベースタイプ | 例 |
|---|---|
| Microsoft SQL Server |
|
| Oracle |
If |
| PostgreSQL | |
| MySQL | |