Connecting JIRA to Oracle: 4 Easy Steps

on Data Integration, ETL, Tutorials • September 30th, 2021 • Write for Hevo

Do you use JIRA for bug and issue tracking? Do you want to export your data from JIRA to Oracle? If yes, then you have landed at the right place. In this blog, you will learn about JIRA, Oracle, and the steps to connect these applications with ease. JIRA is a proprietary product used for bug tracking and agile project management. It creates an immense amount of data that needs the right architecture for storage. In this case, Oracle is a wise choice.

Oracle provides a structured platform for your data. It is an object-relational database management system. Oracle is capable of running different kinds of workloads, such as transaction loads and data warehouse loads. This post aims to provide you with a solution to connect JIRA to Oracle using two different methods. 

Table of Contents

Introduction to JIRA

JIRA is a proprietary product developed by an Australian company, Atlassian. It is used for bug and issue tracking. It leverages all kinds of project management skills, including bug tracking, software development, etc. It is one of the most popular testing tools. JIRA is based on Agile methodology. JIRA is offered in four different packages, as mentioned below:

  1. JIRA Core: It is a generic project management platform.
  2. JIRA Software: It is a base software with agile functionality.
  3. JIRA Service Desk: It is for IT or other business service tasks.
  4. JIRA Ops: It is for intended management.
Jira to Oracle: Jira Suite
Image Source

Introduction to Oracle Database

Oracle is a relational database management system. It is a popular enterprise application. It is known as Oracle database, OracleDB, and Oracle. It provides a logical and physical structure to your data. Oracle offers recovery in case of failure, portability on all platforms, high security, etc. Four different editions of Oracle are as follows:

  1. Enterprise Edition: It is the most robust and secure edition. It offers high security, enhanced performance, etc. 
  2. Standard Edition: It provides all the basic functionality to its users.
  3. Express Edition (XE): It is a lightweight and free edition for Windows and Linux. 
  4. Oracle Lite: It is for mobile devices. 

Simplify your Data Analysis with Hevo’s No-code Data Pipeline

A fully managed No-code Data Pipeline platform like Hevo Data helps you integrate data from 100+ data sources (including 40+ Free Data Sources) to a destination of your choice in real-time in an effortless manner. Hevo with its minimal learning curve can be set up in just a few minutes allowing the users to load data without having to compromise performance. Its strong integration with umpteenth sources allows users to bring in data of different kinds in a smooth fashion without having to code a single line. 

Get Started with Hevo for Free

Check out some of the cool features of Hevo:

  • Completely Automated: The Hevo platform can be set up in just a few minutes and requires minimal maintenance.
  • Transformations: Hevo provides preload transformations through Python code. It also allows you to run transformation code for each event in the Data Pipelines you set up. You need to edit the event object’s properties received in the transform method as a parameter to carry out the transformation. Hevo also offers drag and drop transformations like Date and Control Functions, JSON, and Event Manipulation to name a few. These can be configured and tested before putting them to use.
  • Connectors: Hevo supports 100+ integrations to SaaS platforms such as Salesforce, files, databases, analytics, and BI tools. It supports various destinations including Salesforce CRM, Google BigQuery, Amazon Redshift, Firebolt, Snowflake Data Warehouses; Amazon S3 Data Lakes; and MySQL, MongoDB, TokuDB, DynamoDB, PostgreSQL databases to name a few.  
  • Real-Time Data Transfer: Hevo provides real-time data migration, so you can have analysis-ready data always.
  • 100% Complete & Accurate Data Transfer: Hevo’s robust infrastructure ensures reliable data transfer with zero data loss.
  • Scalable Infrastructure: Hevo has in-built integrations that can help you scale your data infrastructure as required.
  • 24/7 Live Support: The Hevo team is available round the clock to extend exceptional support to you through chat, email, and support calls.
  • Schema Management: Hevo takes away the tedious task of schema management & automatically detects the schema of incoming data and maps it to the destination schema.
  • Live Monitoring: Hevo allows you to monitor the data flow so you can check where your data is at a particular point in time.
Sign up here for a 14-Day Free Trial!

Prerequisites

  • You can use Oracle version 12c R2, 18c, or 19c.
  • You can install JDBC 19.3 from here.
  • Create an XML backup, if you are migrating your data to another server. 
  • Shut down your JIRA before you begin this process. 

Understanding the Data Migration Setup from JIRA to Oracle

To connect JIRA to Oracle, you need to follow these steps:

Jira to Oracle Migration: Configure your Oracle Database

You should have an instance dedicated to JIRA. Either create a new instance or use an old one. Create a new user in your desired instance, using the following command:

create user <user> identified by <user_pass> default tablespace <tablespace_name> quota unlimited on <tablespace_name>;

Grant the following permissions to this user:

grant connect to <user>;
grant create table to <user>;
grant create sequence to <user>;
grant create trigger to <user>;

Jira to Oracle Migration: JDBC Driver Set-up

After you have installed the JDBC driver, copy the downloaded .jar file to your lib/ in the JIRA installation directory.

Jira to Oracle Migration: Configure your JIRA Server

You can configure your JIRA server in 2 ways, as mentioned below:

Let’s see how you will configure your JIRA server for Jira to Oracle Migration in these two methods.

Configure your JIRA Server Using JIRA Set-up Wizard

This method is used when you have just installed JIRA and setting it up for the first time. All your settings will be saved in dbconfig.xml. JIRA set-up wizard will be visible to you when you access JIRA for the first time. Use the following steps to configure your connection using JIRA set-up wizard:

  1. In ‘Configure Language and Database’, set Database Connection as ‘My own database’.
  2. Set your database type as ‘Oracle’.
  3. Fill the fields according to your dbconfig.xml file.
<?xml version="1.0" encoding="UTF-8"?>
 <jira-database-config>
  <name>defaultDS</name>
  <delegator-name>default</delegator-name>
  <database-type>oracle10g</database-type>
  <jdbc-datasource>
    <url>jdbc:oracle:thin:@dbserver:port:SID</url> //url
    <driver-class>oracle.jdbc.OracleDriver</driver-class>
    <username>jiradbuser</username> //username
    <password>password</password> //password
    <pool-min-size>20</pool-min-size>
    <pool-max-size>20</pool-max-size>
    <pool-max-wait>30000</pool-max-wait>
    <pool-max-idle>20</pool-max-idle>
    <pool-remove-abandoned>true</pool-remove-abandoned>
    <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
    <validation-query>select 1 from dual</validation-query>
    <min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
    <time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>
    <pool-test-while-idle>true</pool-test-while-idle>
    <pool-test-on-borrow>false</pool-test-on-borrow>
  </jdbc-datasource>
</jira-database-config>
  • Hostname: This is your “dbserver” in the <url> tag. It is the IP address of the machine on which Oracle is installed.
  • Port: This is your port in the <url> tag. It specifies the TCP/IP port that your Oracle server is listening to.
  • SID: This is your Oracle System Identification (SID) in <url> tag. By default, it is ORCL.
  • Username: It is the JIRA user that connects to Oracle. It is placed inside the <username> tag.
  • Password: It specifies the password of the user that connects with the Oracle. It is placed inside the <password> tag.

Configure your JIRA Server Using JIRA Configuration Tool

This method is for an existing JIRA instance. All settings will be saved in dbconfig.xml file. Use the following steps to configure your connection using the JIRA Configuration Tool:

  • Run the JIRA Configuration tool, as mentioned below:
    In Windows, open a command prompt and run config.sh file in the bin directory of your JIRA installation directory.
    In Linux, open a console and run config.sh file in the bin directory of your JIRA installation directory.
  • In the Database tab, select database type as “Oracle”.
  • Fill the fields according to your dbconfig.xml file.
<?xml version="1.0" encoding="UTF-8"?> 
<jira-database-config>
  <name>defaultDS</name>
  <delegator-name>default</delegator-name>
  <database-type>oracle10g</database-type>
  <jdbc-datasource>
    <url>jdbc:oracle:thin:@dbserver:port:SID</url> //url
    <driver-class>oracle.jdbc.OracleDriver</driver-class>
    <username>jiradbuser</username> //username
    <password>password</password> //password
    <pool-min-size>20</pool-min-size>
    <pool-max-size>20</pool-max-size>
    <pool-max-wait>30000</pool-max-wait>
    <pool-max-idle>20</pool-max-idle>
    <pool-remove-abandoned>true</pool-remove-abandoned>
    <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
    <validation-query>select 1 from dual</validation-query>
    <min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
    <time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>
    <pool-test-while-idle>true</pool-test-while-idle>
    <pool-test-on-borrow>false</pool-test-on-borrow>
  </jdbc-datasource>
</jira-database-config>
  • Hostname: This is your dbserver in the <url> tag. The IP address of the machine on which Oracle is installed.
  • Port: This is your port in the <url> tag. It specifies the TCP/IP port that your Oracle server is listening to.
  • SID: This is your Oracle System Identification in <url> tag. By default, it is ORCL.
  • Username: The JIRA user that connects to Oracle. It is placed inside the <username> tag.
  • Password: It specifies the password of the user that connects with the Oracle. It is placed inside the <password> tag.

Jira to Oracle Migration: Start your JIRA

Voila! You have successfully established a connection from JIRA to Oracle. 

Conclusion

In this blog, you have learned about JIRA, Oracle, and steps to connect JIRA to Oracle. You can use the JDBC driver to connect these platforms manually.

Hevo is a No-code Data Pipeline that will automate your data flow in minutes. Hevo will minimize the efforts required for the connection so that you can focus more on data analysis than data migration. Hevo supports pre-built integrations from 100+ data sources.

Visit our Website to Explore Hevo

Want to take Hevo for a spin? Sign Up for a 14-day free trial and experience the feature-rich Hevo suite first hand. You can also have a look at the unbeatable pricing that will help you choose the right plan for your business needs.

Share your experience of connecting JIRA to Oracle in the comment section below. 

No-code Data Pipeline for Oracle