Jira
This page describes how to use Census with Jira

โ€ŒIn this guide, we will show you how to connect Jira to Census and create your first sync.

  • Once you are in Census, navigate to Connectionsโ€‹
  • Click the Add Service 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.

Navigate to the Models page in Censusโ€‹
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.

Now head to the Sync page and click the Add Sync button
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.
Choose your connection and source (your model from 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 Ticket within the correct Jira project in your connection.
Select which object you want to sync to
For the "How do you want to update the destination?" section, Append 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?
Identifiers
Ticket
โœ…
Unique ID

Learn more about all of our sync behaviors on our Core Concepts page.
Behaviors
Supported?
Objects
Append
โœ…
Ticket
โ€‹Contact us if you want Census to support more Sync behaviors for Jira.
If run into a dead end, start a conversation with us via the in-app chat.
Copy link
On this page
๐Ÿƒโ€โ™€๏ธ Getting Started
Prerequisites
1. Connect to Jira
2. Create your Model
3. Create your Sync
๐Ÿ—„๏ธ Supported Objects
๐Ÿ”„ Supported Sync Behaviors