CData JDBC Driver for JIRA 2019 - Online Help
Questions / Feedback?

Data Model

CData 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.

The Tables and Views document API limitations and requirements. See SupportEnhancedSQL for more information on how the driver circumvents API limitations with in-memory client-side processing.

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.

Customizing Schemas

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7362.0