Can I use Stitchdata with JIRA service desk?

Otto Saksa

I'm trying to understand whether it's possible to use the Stitchdata integration  to extract, transform, and load data from the JIRA service desk to a data warehouse.

So basically, in which table are the tickets and their attributes stored? I read here that the service desk requests are stored in the "issues" table (which is already supported by Stitchdata). Can anyone confirm this? 

Petter Gonçalves

Hello @Otto Saksa

Welcome to the Atlassian Community!

Per your description, it seems you are looking to integrate Stitchdata with Jira Service desk Server application, however, your question is tagged as JSD Cloud. Can you confirm if you are using Jira Server or Cloud?

Please, allow me to clarify some concepts so we can confirm we're on the same page here:

As you can see in the documentation provided, Jira Cloud integration with a third-party application can be done by REST API:

Stitch’s JIRA integration replicates data from a JIRA Cloud instance using the JIRA Cloud REST API v2. Refer to the Schema section for a list of objects available for replication.

In Jira Cloud, there's no access to the application's database, as this is a restricted function.

Now, for Jira Server, you can indeed build an integration directly with the database. In that case, the jiraissue table is where the tickets and their attributes are stored. For more details about this, you can check the documentation below:

To find or view a Jira issue from the database using SQL 

Let us know if you have any questions.