Jira
This page describes how to use Census with Jira
Last updated
Was this helpful?
This page describes how to use Census with Jira
Last updated
Was this helpful?
In this guide, we will show you how to connect Jira to Census and create your first sync.
Have your Census account ready. If you need one, now.
Have your Jira account ready.
Have the proper credentials to access to your data source. See our docs for each supported data source for further information:
Click the New Destination button
Select Jira in the list, and click Connect
You will be redirected to a page to log in to Jira to authorize access to your account. Once you sign in, you'll see a page like the image below, confirming you want to authorize Census.
You'll then be prompted to select a Jira account to connect - choose the appropriate account in the dropdown and click Connect.
Here you can write a SQL query to select the data you want to see in Jira, or you can use a model from a dbt project or a Looker Look. Your data will require the following at minimum to populate a new Jira task:
Id
Task Type
Summary
Once you have created your model, click Save.
In the "What data do you want to sync?" section.
For the Connection, select the data warehouse you've already connected (See Prerequisites).
For the Source, select the model you created in step 2.
Next up is the "Where do you want to sync data to?" section.
Pick the Jira connection you created in step 1.
For Object, select Issue within the correct Jira project in your connection.
For the "How do you want to update the destination?" section, Add is the only option at this time.
For the "How are source records identified?" section, there are two options:
Unique ID column: The column that uniquely identifies each record. Census uses this to identify new records that need to be synced.
Timestamp: Using a timestamp to detect new data is more efficient for large or frequently changing data sets.
The Unique ID is always required; select the field from your model you want to map to that the identifier.
Finally, select the fields you want to update in the Mapper in the "Which properties should be updated?" section. Here simply map the field from your Jira instance to the column from your model.
Click the Next button to see the final preview, which will have a recap of what will happen when you start the sync.
Jira's primary object is an Issue, which we support in Census.
Object Name
Supported?
Sync Keys
Behaviors
Issue
✅
Unique ID
Add
Once you are in Census, navigate to
Navigate to the
Now head to the and click the Add Sync button
Learn more about all of our sync behaviors in our documentation.
if you want Census to support more Jira objects and/or behaviors
If run into a dead end, start a conversation with us via the chat.