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?
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:
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:
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:
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:
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.
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...
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