Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Can I use Stitchdata with JIRA service desk?

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? 

1 answer

1 accepted

0 votes
Answer accepted

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.

Hi @Petter Gonçalves, many thanks for your response and the warm welcome! 

To clarify, we're using JIRA Cloud and the idea is to use Stitchdata to pull data from JIRA Service Desk to track ticket resolution times. 

According to their documentation only certain tables are supported. So basically I'm trying to validate whether the integration covers service desk tickets or not. Do you have any insight on that? 

Hello @Otto Saksa

Thank you for the details provided.

Analyzing the mentioned Stitchdata documentation more carefully, I must confess that it has some incorrect or at least ambiguous information about Jira Cloud application. Allow me to explain it:

We don't have a table literally called "Issues" in Jira Cloud and, even if we had, the database is not accessible on Cloud to do a direct integration as mentioned in the doc below:

Compare Jira Cloud and Jira Server 

That being said, I must confess that I'm not sure why that database information would be relevant for the integration in Cloud.

All the data related to Jira can only be integrated externally by using Jira REST API, coming in a JSON format as described in the following links:

Access to the database from Jira on the cloud 

Jira Service Desk Cloud REST APIs 

Jira Software Cloud REST API 

For more details about how Stitch receive and sync and handler that information, I suggest contacting the Support team from Stitchdata.

Let us know if you have any other questions related to Jira we can help you with.

Hi @Petter Gonçalves, thanks a lot for expanding upon your previous answer and looking into this in more depth! 

Your overview was very helpful, and I'll reach out to Stitchdata for more information. 

Thanks again!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Jira Service Management

Why upgrade to Jira Service Management Premium?

We often have questions from folks using Jira Service Management about the benefits to using Premium. Check out this video to learn how you can unlock even more value in our Premium plan.  &nb...

165 views 0 4
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you