Directly accessing the database JIRA?

[Rahul Aich [Nagra]]

Hi

We want to connect a 3rd party tool to JIRA by creating a plugin in-house. we tried connecting it using REST API but the performance is quite slow.

I want to know if it is advisable to allow read-only access to the 3rd party tool directly to the JIRA database ?

Do you think that is a good option to try or is it a strict no (read-only access only)

Rahul

[Norman Abramovitz · Accepted solution]

It depends on what your third party tool needs to do and how much you trust it to do the correct style of SQL to avoid performance issues.   Some examples are

1. Queries written to avoid SQL locking
2. No creation of temporary tables to store intermediate results
3. Third party company is trustworthy (will not use your data for their own purposes)