Extraction Data Through ADF

Matheus Malonda dos Santos Macaia

I'm using azure data factory to extract and process data from jira to create a project feedback dashboard. I would like to know if there is a way to see or create the schema of the tables that are in the database so that I know where the information I need is.
So that I can extract from project boards
Examples of information I need: "Sprint Name", "Logged time", "Story points", "Issues summary", "issues type", "Project Name", "History Issues", "Key", "Status history".

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

There's a couple of things here.

First, you've flagged the question as Cloud.  You have no access to the database on Cloud, so there's no answer to the question.

However, if you meant to say you are on Server or DC Jira, then, although in theory, you could do this, I would very strongly recommend that you do not.

A Jira database is a data-store, with a lot of the logic done in the application.  It's really not intended to be read externally, and if you do go down this route, you're going to spend weeks creating a mass of SQL that probably isn't going to be right, and certainly won't perform.  The list of data items that you are looking for are all in the database, but you'll be having to join 40-50 tables, down multiple layers, many times, and with some calculations (including manipulating XML read from some of it) to get it for a single issue.

For both Cloud and Server/DC, please, forget SQL extraction.  Use the REST API to get the data you need - you can extract all but "board" from your list for a single issue with a single call with that.