Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

A custom JDBC Driver is supported 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 as usual (by using the database vendor's JDBC Driver. Example for PostgreSQL):



Download and Once the report is finished and remotely working from the Eclipse Report Designer, copy it somewhere in the Jira host where filesystem readable by the system OS user running the Jira service can read:

jira-db-driver.jar

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 it the BIRT report to Jira.


The report will take a connection from the Jira database connection pool (the same connection connections that is are used by the Jira application internally)

...