Jira Cloud ODBC connection

[CS]

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

[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]

Hi

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

[CS]

@Nic Brough -Adaptavist- 

It seems the mentioned ODBC driver is connection to Jira Cloud per API-Token and serves the data through classic ODBC.

Seems like they just build an interface for applications which can only connect per ODBC

Thanks at all for the help

[Nic Brough -Adaptavist-]

Seems remarkably pointless, when you could just connect directly to the REST API.

[KAGITHALA BABU ANVESH]

Hello @CS

DB connectivity is not required for Atlassian cloud products.

This will be taken care by Atlassian only.

Thanks,

Kagithala Babu Anvesh

[CS]

Hi

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]

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