We strongly recommend using our SQL+JQL Driver as data source to access to the Jira data, However, some times organizations might require to access to the Jira database directly: A JDBC Driver is supported for this. Read how to:
First, develop a report against the Jira database remotely by using the database vendor's JDBC Driver. Example for PostgreSQL:
Once the report is finished and remotely working from the Eclipse Report Designer, copy it somewhere in the Jira host filesystem readable by the OS user running the Jira service:
Then reference the driver above from your BIRT report as described here and change the data source configuration to:
Driver Class: com.kintosoft.jira.birt.JiraDBDriver
Database URL: jdbc:jira-db:
Username:
Password:
Upload the BIRT report to Jira.
The report will take a connection from the Jira database connection pool (the same connections that are used by the Jira application internally)