@Vitalii Honchar Atlassian uses Postgesql by default though I did not get what do you mean by
I have connect my Jira cloud project to postgresql database
And you cannot access the Database directly thoug you can have access to the Atlassian Cloud REST API's
You can use them to fetch data from your Cloud instance: https://docs.atlassian.com/jira/REST/latest/
I don't think there is any other way than REST API else you will need to contact Atlassian Cloud Support for this and also have a look at https://community.atlassian.com/t5/Jira-Core-questions/How-can-I-access-JIRA-database-to-fetch-data-which-is-on-cloud/qaq-p/448840
The other way is to configure a web hook for the projects that you want and then write a simple web hook listener to get the data and write to PSQL.
We do this for getting Data from Cloud JIRA instance to use for our Tableau based BI system.
You can do an ETL for the required fields and also dump the JSON as is to a JSON type field in PSQL so that you can pick any field you want for BI since PSQL have support for JSON querying.
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