Database Exporter for Jira Cloud, allows you to export Jira Cloud data into your own database. The data is kept up to date with periodic refreshes. This allows for easy integration of Jira data with other systems, reporting tools, archival, migration or any other business purpose which requires easy access to Jira cloud data.
From the app page click Try it free button to start the installation wizard
After the installation is complete, Database Exporter menu item appears under Jira > Jira Settings > Apps > Database Exporter
Go to Jira > Jira Settings > Apps > Database Exporter . The app will ask for database connection details into which the data can be exported. The database needs to be accessible over the internet. After entering the database connection details, click "Next"
IP to whitelist is 126.96.36.199.
SSL mode is automatically used if the database supports SSL.
The data will start exporting to the database within 15 minutes and will be refreshed every 30 minutes. The refresh can also be triggered on demand.
Any database client can be used to connect to the database and verify the data. Two popular database clients for PostgreSQL are