Fivetran supports both Jira On-Premise and Jira Cloud. How we connect to Jira depends on which Jira installation you have. Select the setup guide for your Jira installation:
Prerequisiteslink
To connect your Jira account to Fivetran, you need:
- Your Jira host name
- Your port
- A connecting user with the following permissions*:
- Administer Projects or Browse Projects to view projects, their issues, and related entities like versions, components, and boards. Learn more in Jira’s managing project permissions documentation. If you use issue security schemes, the user must have a sufficient security level. Learn how to set security levels in Jira’s configure issue security schemes documentation.
- Administer Projects to view project roles and their actors.
- Browse users and groups global permission to view users and groups. Learn more in Jira’s managing global permissions documentation.
- Administrators or Service Desk Team project role to have an access to Jira Service Management (formerly Jira Service Desk). Learn more in Jira’s Service Management permissions documentation.
- Administer Jira global permission to view permission and issue security schemes and related entities, as well as to register webhooks for capturing deleted entities like issues and projects. Learn more in Jira’s managing global permissions documentation.
- For Jira On-Premise - your username and password
- For Jira Cloud - create an application link (see Jira docs) with the following details:
- Application URL: https://fivetran.com
- Consumer key: Use the consumer key specified in the Jira Setup Form
- Public key: Use the public key mentioned in the Jira Setup Form
IMPORTANT: Only use an HTTPS URL with TLS version 1.2 or above.
* If you are missing any permissions, Fivetran does not sync the corresponding entities. Learn how permissions work in Jira’s permissions documentation.
Jira On-Premise Setup Instructionslink
-
In the connector setup form, enter the Destination schema name of your choice.
-
Enter the name of your Jira Host.
-
Enter your Port number.
-
Set the On Premise toggle to ON.
-
Provide your username and password.
-
Choose the issue sync mode: From all projects or From selected projects.
-
If you choose From selected projects, select the projects whose associated issues you’d like to sync.
-
Click Save & Test. Fivetran will take it from here and sync your data from your Jira account.
Jira Cloud Setup Instructionslink
Begin Fivetran configurationlink
-
In the connector setup form, enter the Destination schema name of your choice.
-
Enter the name of your Jira Host.
-
Enter your Port number.
-
Specify the Consumer Key or leave the default one, “OauthKey”, if it is not used by another external application in your Jira installation.
-
Find the public key and make a note of it. You will need it to configure Jira to connect with Fivetran.
Create Atlassian application linklink
-
Log in to your Atlassian profile.
-
Go to Jira Settings, then select Products.
-
Go to Integrations, then select Application Links.
-
Enter
https://fivetran.com
in the link bar. -
Click Create new link.
Configure application link for Fivetranlink
-
You will receive a warning that “No response was received from the URL you entered.” This warning is expected, as noted in Jira’s documentation. Disregard this warning and click Continue.
-
In the Link Applications window, enter “Fivetran” as the Application Name.
-
For Application Type, select Generic Application.
-
Fill in the rest of the fields as shown below. These other fields do not matter for the purposes of setting up our Jira connection. Fivetran only needs to retrieve data, so we can set up a one-way (incoming) link from the client to Jira.
-
Select the Create incoming link checkbox.
-
Click Continue.
-
In the next Link Applications window, enter the Consumer Key you’ve specified in the Setup Form (default “OauthKey”).
-
Enter “Fivetran” as the Consumer Name.
-
Enter the public key you found in Step 1.
-
Click Continue. If setting up the Application Link was a success, you’ll be taken to a page with this notification:
Finish Fivetran configurationlink
-
Return to the tab with your Fivetran dashboard.
-
Click Authorize and allow Fivetran to access your data.
-
Choose the issue sync mode: From all projects or From selected projects.
-
If you choose From selected projects, select the projects whose associated issues you’d like to sync.
-
Click Save & Test. Fivetran will take it from here and sync your data from your Jira account.
Custom field feature requestlink
If you don’t see a custom field you’d like to sync listed in our Jira documentation, reach out to our Support Team.
Note that a new field support requires that you grant us access to your Jira source. Also, it requires a full historical resync.
Related Contentlink
description Connector Overview
account_tree Schema Information
settings API Connector Configuration