BIRT reports can connect to a lot of data sources. However, only the SQL for JIRA Driver is supported.
With the Layout tab selected, right click on the Data Source element on the Data Explorer view. Then select the JDBC Data Source and name it JIRA:
In next screen you have to configure the SQL for JIRA JDBC Driver. Well, this might be a bit confusing due some name overlapping. The SQL for JIRA Driver is a plugin that is installed on JIRA from the Marketplace. It transforms JIRA into a real database server listening to the standard HTTP/S port (80 or 443). As any other database vendor a JDBC Java jar library is required to be installed on your Java ClassPath to access to the database server. You have to download that JDBC driver from here and install it on Eclipse:
Fill out the data to connect to the SQL for JIRA Driver application (plugin on JIRA):
- Driver Class: com.kitosoft.jira.jdbc.Driver
- Database URL: It is the regular connect string required by any 3rd party JDCB driiver. jdbc:jira:<JIRA BASE_URL>
- User Name and Password: They are the JIRA user's credentials used to access to the JIRA web application
Click on the Test Connection button to check that everythin is right. Then click on the Finish button to create the Data Source in your BIRT report:
