Accessing data after migration to cloud

Scott Pippin January 20, 2021

We currently access the database directly to run our own reports.  Once we migrate to the cloud how do we gain access to the data to run our own reports?

2 answers

1 vote
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 20, 2021

You don't.

You will need to throw away all your reporting and move to proper methods to do it (SQL is the worst possible way to try to report on Jira, hence the "not proper").  This means using the reports or apps built on Cloud to do it.

Atlassian have (yesterday) opened the floor for early access to the Data Lake though, which is intended to improve the access by proper reporting tools (not relying on home-rolled terrible SQL).  https://community.atlassian.com/t5/Jira-Software-articles/Introducing-Atlassian-Data-Lake-for-Jira-Software-Early-Access/ba-p/1584438 for a bit more on that.

1 vote
Bastian Stehmann
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 20, 2021

HI @Scott Pippin ,

You don't have any access to the database after migration to cloud.

You'll need to check if there are apps  that can provide the reports/data or if you can get the data via REST API.

Suggest an answer

Log in or Sign up to answer