Connect Jira cloud to Denodo

[Jan Rembisch]

I'm  trying to read data from Jira Cloud into Denodo which is our Virtual Datawarehouse. We use the guide provided by Denodo for Denodo 8. 

In essance Denodo will communicate with Jira over OATH 2(3LO). 

One of the steps is to generate an authorization URL:

We use: 

https://auth.atlassian.com/oauth/token as token endpoint and 

https://auth.atlassian.com/authorize as Authorization server

http://127.0.0.1:9090/oauth/2.0/redirectURL.jsp as a redirect URL

According to the documentation the “Redirect URI” has to be filled with the same “Callback URL” that was entered in the Jira configuration.

When I get to the section to generate the authorization URL i get redirected to a site saying "problems logging you in" 



Have any of you had any success with getting Denodo to talk to Jira Cloud?

[Martin Runge]

Hi @Jan Rembisch

Welcome to the Atlassian community!

I would treat that "problems logging you in" screen as a sign the authorization request itself is malformed, not that your login failed. Denodo builds the URL for you, so I would compare what it generates against Atlassian's required 3LO format.

The three things I would check first:

• The URL contains audience=api.atlassian.com. This is required and is the most common cause of that exact error when it is missing.
• redirect_uri matches your Callback URL exactly, including http, the 127.0.0.1 host, port 9090, and the /oauth/2.0/redirectURL.jsp path. Any difference is rejected.
• The URL ends with response_type=code and prompt=consent, and every scope in it was actually added to your app.

Did you follow this Knowledge Base article on the denodo community: https://community.denodo.com/kb/en/view/document/How%20to%20integrate%20Jira%20Software%20as%20a%20Denodo%20data%20source

Cheers, Martin