Configuring Authentication

The Simba Jira ODBC Connector can use either basic user name and password authentication, the OAuth 1.0 or OAuth 2.0 protocol for authentication and authorization.

Configuring Basic Authentication

To use basic authentication, set the authentication method to Basic.

To configure basic authentication:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Method drop-down list, select Basic.
  3. In the User field, type your Jira user name.
  4. In the Password field, type the password associated with your Jira user name.
  5. To save your settings and close the DSN Setup dialog box, click OK.

Configuring Authentication Using OAuth 1.0

Before you can connect to Jira using OAuth 1.0, you must first register a new consumer in Jira by creating an application link. For detailed instructions on creating an application link, see "Using AppLinks to link to other applications" in the Jira documentation: https://confluence.atlassian.com/adminjiraserver070/using-applinks-to-link-to-other-applications-776637107.html.

For detailed instructions, see the following:

Configuring Authentication With an Access Token Tuple

If you already have a valid access token tuple (access token and access token secret), specify it in your DSN so that the connector can use it to authenticate the connection.

The access token tuple is valid for a limited time only. If it expires, you must request a new access token tuple.

To configure authentication with an access token tuple:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Method drop-down list, select OAuth_1.0.
  3. In the Access Token field, type or paste your access token.
  4. In the Access Token Secret field, type or paste your access token secret.
  5. To save your settings and close the DSN Setup dialog box, click OK.

Configuring Authentication With Your Jira Credentials

You can authenticate your connection by providing information about your Jira so that the connector retrieves and uses the corresponding access token.

To configure authentication with your Jira credentials:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Method drop-down list, select OAuth_1.0.
  3. In the Consumer Key field, type the consumer key associated with your Jira application.
  4. In the Private Key field, type the private key from the .pem file that was generated for your Jira application. You must include all the text from the .pem file, including the lines that indicate the start and end of the private key.
  5. Click Get Access Token. An access token and access token secret are automatically generated and inserted into the appropriate fields in the DSN Setup dialog box.
  6. To save your settings and close the DSN dialog box, click OK.

Configuring Authentication Using OAuth 2.0

Tu use the OAuth 2.0 protocol, set the authentication method to OAuth_2.0 and provide an access token or your Jira credentials.

For detailed instructions, see the following:

Configuring Authentication With an Access Token

If you already have a valid access token, specify it in your DSN so that the connector can use it to authenticate the connection.

To configure authentication with an access token:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Method drop-down list, select OAuth_2.0.
  3. In the Access Token field, type or paste your access token.
  4. To save your settings and close the DSN Setup dialog box, click OK.

Configuring Authentication With Your Jira Credentials

You can configure the connector to retrieve and use an access token based on your Jira credentials.

Important: Make sure that the default web browser on your machine is not set to Internet Explorer. The OAuth 2.0 authentication flow that the connector uses to retrieve access tokens is not supported on Internet Explorer.

To configure authentication with your Jira credentials:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Method drop-down list, select OAuth_2.0.
  3. In the Client ID field, type the client ID associated with your Jira application.
  4. In the Client Secret field, type the client secret associated with your Jira application.
  5. In the Scope field, type a space-separated list of OAuth scopes for the access token.

    For example:

    write:jira-work read:jira-user manage:jira-configuration

    For a list of the scopes that the connector supports, see "Determining the required scopes for an API operation" in https://developer.atlassian.com/cloud/jira/platform/oauth-2-authorization-code-grants-3lo-for-apps/.

  6. In the Redirect URI field, type the redirect URL of your Jira application that must be the same as the Callback URL configured for Authorization code grants for your application in app management. For more information about callback URL, see "Enabling OAuth 2.0 (3LO)" in https://developer.atlassian.com/cloud/jira/platform/oauth-2-authorization-code-grants-3lo-for-apps/.
  7. Click Get Access Token.
  8. A web browser opens. In the web browser, log in to your Jira account with your Jira user name and password, and click Allow to allow the connector to access your Jira data store.
  9. In the DSN setup dialog box, confirm that the Access Token field is populated. Then, close the browser window.
  10. To save your settings and close the DSN Setup dialog box, click OK.