Import data from a database into Insight.
Some use cases could be:
- Import data from another CMDB like BMC Remedy or Service Now
- Import CRM data from a proprietary legacy system
- And so much more....
Import Type Fields
These are the module type specific fields that need to be configured for this import type. All of these fields are mandatory.
The database connection URL
The driver class to use to connect to the database.
Place the JDBC driver (*.jar) to the <Jira_INSTALL>/lib folder
Don't forget to restart Jira after adding the driver to lib folder.
The username used to authenticate
The password used to authenticate
You can enter the password for your database.
If you then come to edit your database import later, the password field will be disabled. If you want to edit the password, you have to check the Change value checkbox provided adjacent to the Password field as shown in the screenshot below.
To save your edited password, make sure you keep the Change value checkbox checked until you click on the Next button. If you uncheck it accidentally, the password field is disabled again with its original value retained and the newly entered password will not be saved.
If you want to query the Jira database, you can look into the dbconfig.xml found in Jira_HOME directory, to find out the correct configuration.
Object Type Mapping configuration
The selector for the Database import is a SQL query. How to build SQL queries depends on the database type.
How to build up the selector (the SQL statement) depends on how you have configured the database connection. Below you will see some examples that will hopefully guide you in the right direction when setting this up.
If you want to query the Jira database, you can look into the dbconfig.xml found in Jira_HOME directory, to find out the correct configuration, such as schema name etc.
Predefined Structure & Configuration
There are no predefined structure and configuration implemented for the Database type
Supported database types
We are using a common framework (jdbc) to connect to the database so we support many database types such as:
Microsoft SQL Server
before Jira 7.5 net.sourceforge.jtds.jdbc.Driver
after Jira 7.5 com.microsoft.sqlserver.jdbc.SQLServerDriver
If you want to connect to the Jira database, you can look into the dbconfig.xml in Jira_HOME to find the correct configuration and URL
Here are some examples of URL configurations for different database types:
Microsoft SQL Server
before Jira 7.5 jdbc:jtds:sqlserver://localhost:41972/Jiradb
after Jira 7.5 jdbc:sqlserver://localhost:1433;databaseName=Jiradb
Another connection example:
Connection URL with domain for AD authentication: