Data ModelCData JDBC Driver for JIRA 2019 - Build 19.0.7362
The driver models the JIRA API as relational tables, views, and stored procedures, allowing database-like connectivity to JIRA Cloud accounts or JIRA Server instances.
Collaborative Query Processing
The driver offloads as much of the SELECT statement processing as possible to the JIRA APIs and then processes the rest of the query within the driver. In addition to SQL, the Issue tables support native JQL (JIRA Query Language) in the WHERE clause, along with the columns of the view.
Accessing Custom Fields
By default, the table and view schemas describe the column behavior of system fields for JIRA entities. To access Custom Fields for Issues, as well as system fields, you can set IncludeCustomFields in the connection string. You can also extend schemas to configure access to Custom Fields.
The schemas are defined in .rsd configuration files. These files have a simple format that makes them easy to extend; for example, to gain more control over custom fields.
To save a schema to an .rsd file, call the CreateSchema stored procedure; for example, with the IncludeCustomFields connection property set.
To use custom schemas, set the Location property to the folder containing the .rsd files. The schemas included with the driver are located in the db subfolder of the installation folder.