JIRA Plugin

The JIRA plugin allows AppSynergy to easily read and write data in JIRA.

This means you can use AppSynergy to build custom business systems that easily pull key data from JIRA for integration purposes. Importantly, changes to that data can easily be pushed back to JIRA in real time.

Typical use cases include creating billing systems that pull project and time data directly from JIRA to eliminate the double entry of data. The custom AppSynergy app might generate invoices, track payment, integrate with customer service or CRM systems, etc.

All of your JIRA data can be integrated:

Boards
Epics
Sprints
Projects
Issues
Worklogs
Comments
etc. etc.

Features

Live Data. The plugin enables the reading and writing of live data. An update to a federated table connected to JIRA means the data in JIRA is changed immediately. Difficult syncing issues are therefore largely eliminated at the source.
SQL Interface. The plugin translates MariaDB SQL to the appropriate underlying API calls to the remote system. This means you can work (and think) in SQL without worrying about as many of the implementation details.
Caching. You can enable query caching to improve the performance of a slow remote system. The cache can be built and refreshed automatically at periodic intervals. In addition you can refresh select portions of the cache manually with a single line of PL/SQL code.
Over-The-Top Role Based Security. If the remote system has limited security features you can apply more granular security over-the-top using AppSynergy Security Roles. Our Security Roles enable control of select/insert/update/delete right down to the table/column/record level. This enables different users assigned to different roles to have differing access permissions even if the remote system doesn't provide such capability.

Specifications

Full read/write capability limited only by the capabilities and/or permissions of the remote system.
Full-featured and consistent SQL access to all supported data end points.
Codeless integration for reporting and dashboards.
Codeless integration for building applications that update JIRA data.
Full support for JIRA metadata discovery and automatic datatype mapping.
Includes enterprise-class security features such as TLS/SSL data encryption for all client-server communications.