Configure a Database datasource
Table of contents
Definition
The Direct Database Connector allows you to declare an access to any relational database reachable from your JIRA server.
Use it if:
- You want to query data from a relational database,
- You don't have access to the Tomcat file, and are not able to configure a JNDI datasource descriptor.
Databases supported by Elements Connect:
- Microsoft SQL Server
- Oracle
- PostgreSQL
- MySQL
Your database is not in this list? Use a JNDI connection instead, which offers a wider databases support and provide some performance benefits.
Database driver
Elements Connect uses the JDBC drivers available in Jira classpath. Depending on your Jira configuration, only one driver could be available.
If you want to configure a connection to another type of database you must make the JDBC driver available.
This task requires 3 steps:
1 - Download the driver
Download the driver corresponding to your database:
Datasource | Driver |
---|---|
PostgreSQL | PostgreSQL JDBC driver (official) |
MySQL | Connector/J (official) |
SQLServer | Microsoft JDBC Driver for SQL Server (official) jTDS JDBC Driver (alternative) |
Oracle | Oracle database JDBC driver (official) |
If you datasource driver is not in this list, it does not means that it does not exists - just google it 'MY_DATABASE jdbc driver'.
2 - Add the driver to the classpath
Copy the .jar file into:
- the <TOMCAT_HOME>/lib folder for WAR installation.
- the <JIRA_APP>/lib folder for standalone installation.
3 - Restart Tomcat
Tomcat must be restarted once in order to have the driver loaded in the classpath.
Datasource configuration
Elements Connect offers two configuration modes for Database datasources, Simple and Advanced.
Simple configuration
With this mode, you'll be guided step by step by the form. It suits most of the use cases.
Form options may vary depending on the selected database type.
From the parameters you've set, Elements Connect will generate the connection URL to the database.
If your database requires some specific parameters in the URL, you must use the Advanced mode.
If you don't know how to configure a Database datasource - contact a Database Administration (DBA) of your organization.
Advanced configuration
This mode requires more DB expertise but it also offers more control, indeed you can configure the connection URL yourself.
Use it if the Simple mode does not cover your use case.
If you don't know how to configure a Database datasource - contact a Database Administration (DBA) of your organization.
Field configuration
Troubleshooting
Related troubleshooting articles: