How to import data from an external database in Jira Assets / Insight

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Summary

This article guides you on how to import data from another database to from an external database to an instance of Jira Assets without using an integration plugin.

Overview

To import and map the data in Jira Assets you shall:

  1. Create the Object containing the same attributes as the source data
  2. In the Object Schema configuration/ Import, create a new import configuration, and select Database.
  3. Configure the database connection, providing the database URL, JDBC driver, user and password. Following the screen requirements.
  4. Create an importing mapping by manually clicking on Create Object Type mapping
  5. Select the Object Type and in Selector setup the query
  6. Go back to the mapping screen and map the fields - Note that the first column works like a primary key, and will be used as a unique identifier value for this import.
    (Make sure the identifier is set in the right database column. At least one column must be set as an identifier)
  7. Enable this object mapping import, enable the import configuration
  8. Click on Synchronize to test the import


Attention: 

  • You must be a Jira admin to create and configure database imports.
  • Jira uses a common framework (JDBC) to connect to the database, so we support the following ones:

    Database Type

    Driver

    Microsoft SQL Server

    com.microsoft.sqlserver.jdbc.SQLServerDriver

    Oracle

    oracle.jdbc.OracleDriver

    PostgreSQL

    org.postgresql.Driver

    MySQL

    com.mysql.jdbc.Driver

    For database address location, port, and DB name, please follow the guidelines from Connecting Jira applications to a database.

Example

Let's use this table as an example of external database to have the data imported:

With the steps to import:

StepAction

To import data from a Database to Jira Assets, first, we need to create the Object containing the same attributes as the source data:

  • In this case, the attributes are the columns: Name, color, and created date.

Once the object is created and configured as in this image below:

We can now go to the Object Schema configuration./ Import, create a new import configuration, and select Database.

After setting up the import name, we must configure the database connection, providing the database URL, JDBC driver, user and password.

Once finished, it won't create any predefined import mapping. We need to create one manually by clicking on Create Object Type mapping

We can select the object type we created earlier and add the database query that will return the data we want to import:

Once we setup the query, we can go back to the mapping screen and then map the fields. Note that the first column (identifier) works like a primary key, and will be used as a unique identifier value for this import.

Make sure the identifier is set in the right database column. At least one column must be set as an identifier.

After mapping the fields, we have to enable this object mapping import.

And also enable the import configuration and click on Synchronize to test the import.

Once it finishes, we should have a result like this.

And at the end, the data will appear in the object type we created.

Last modified on Apr 5, 2023

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.