nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira Cloud ODBC connection

CS_rxftdl

Hello,

we are using Jira software (cloud free) and want to connect our local SAS server to the jira database per ODBC.

We didnt find any documentation or information on how to configure the connection.

Our local SAS system is using a Windows Server 2019.

So we are able to configure an System DSN in the ODBC Data Source Administrator but dont know which driver and which connection settings we should use.

Can you help?

Best regards

Jan

Accepted answers

All comments

KAGITHALA BABU ANVESH_z1zl10

Hello @CS

DB connectivity is not required for Atlassian cloud products.

This will be taken care by Atlassian only.

Thanks,

Kagithala Babu Anvesh

CS_rxftdl

thanks for your fast response.

Maybe its not required, but is it possible?

We read that you can do it:

https://www.cdata.com/kb/tech/jira-odbc-sas.rst

Regards

Jan

KAGITHALA BABU ANVESH_z1zl10

sorry, I don't have any idea about this.

Nic Brough -Adaptavist-

No, you do not get access to the database on Cloud.

What are you trying to achieve here? There's going to be a better way to do it than database access even if you did have it, and we can talk to you about that.

CS_rxftdl

we use a local software called SAS and we want to create reports and visualize data directly from the jira database per ODBC.

Actually we found a way to do that:

This driver seems to be able to do that:

https://www.cdata.com/drivers/jira/odbc/

But it is third party. We would prefer some integrated method per ODBC.

Regards

Nic Brough -Adaptavist-

But that "driver" connects to a database, so it's useless, as you can't get to the database.

You need to convert your thinking to doing the reporting and visualisation inside Jira, or by using something that understands how data comes out when you use the REST API ("something" includes "things you write yourself to query Jira over the REST API"). Or you could hang on a while, until the Jira Data Lake comes out of beta, and try to use that in a reporting tool.

Lauma Cīrule

Hi @CS !

If you would be interested in a third-party app for reporting, you can check out eazyBI.

With eazyBI, you can import the data from Jira with just a few clicks (it understands the Jira data model) and do standard reporting or go deeper with extensive Jira data analysis. Check out some example reports in our demo account: https://eazybi.com/accounts/1000/dashboards/5942-project-overview.

Let me know if you would be interested and there is anything else I can assist you with regarding eazyBI!
Lauma / support@eazybi.com

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud