Integrate tableau tool with jira cloud

Question

We are migrating from Jira on prem to cloud.problem is that - we are using tableau as reporting tool on top of postgre sql which is getting synched from jira onprem DB. Once we migrate to cloud,how much synch up this postgre DB with jira cloud? Anyone worked on aimilar situation or can help how this be handled

Robin Kon · Answer

Jira Cloud doesn’t give direct DB access like the on-prem version, so syncing PostgreSQL the same way won’t work post-migration. You’ll likely need to switch to pulling data via the REST API. This article covers a few solid options for connecting Jira Cloud to Tableau without direct DB access - https://blog.skyvia.com/how-to-connect-tableu-and-jira/

Anna Odrynska - Alpha Serve · Answer

Hi @Raja rajeswari Gurram 1995

Welcome to the Atlassian Community!

I am not a migration expert, though I will share my thoughts here - may be they'll be somehow helpful to you.

From what I understand, with on-premise Jira you use your DB to pull data into Tableau. After migration to Cloud, you'll probably not have a DB to pull data from.

You may take a look at the Atlassian Data Lake (if you expect to have Premium Jira Cloud). Here are some information regarding this: https://www.atlassian.com/blog/announcements/atlassian-analytics

As an alternative, as you'll anyway have to configure the datasets from scratch after the migration, you can consider using the app to fetch data from Jira Cloud to Tableau. You can take a look at our Tableau Connector for Jira: https://marketplace.atlassian.com/apps/1221376/tableau-connector-for-jira?hosting=cloud&tab=overview

Good luck with migration! ;-)

Anna