Articles in this section

See more

Jira Assets connector

Follow

Overview

The Etlworks Jira Assets connector connects to Assets in Jira Service Management (asset and configuration management) and exposes objects, object types, and schemas as tables and views, so you can browse them in Explorer, read data with SQL, and use them in ETL flows — just like any other connector for Connected Apps.

When to use this connector

Use it to extract asset inventories and their attributes into a database, warehouse, or file — for example, for CMDB reporting, reconciliation against other systems, or archival. For Jira issues and projects, use the Jira connector; for service-desk requests, use the Jira Service Management connector described in the same article.

Create a Connection

Step 1. In the Connections window, click +, and type jira in the search box. Select Jira Assets.

Step 2. Enter the connection parameters:

  • URL (required): the URL associated with your Jira endpoint, for example https://yoursitename.atlassian.net.
  • Authentication type (required, default API token).
  • API Token: an Atlassian API token created for the user.
  • User and Password: the user (email) matching the API token, or basic credentials where applicable.

Step 3. Optionally adjust the common parameters: Auto Commit, Run at Connect, Other Parameters (key=value pairs), JDBC Fetch Size (default 50000), Max Rows to Read (testing only), Max Field Size, Always enclose table/column names in double quotes, All columns are varchars, All columns are nullable, Data Type Overrides, Function to calculate Column Name, Open connection when needed, and Script to run before connect.

Work with Jira Assets data

After the connector is installed and licensed, browse the schema in Explorer, run SQL against it, and use the connection as a source in source-to-destination transformations.

Install and license the connector

This is a premium connector (Etlworks 10.0.14 and newer).

  1. Open a connection of this type (or Settings → Premium connectors) and click Download and install.
  2. Click Start trial to evaluate it.
  3. For production, contact Etlworks support for a license key or runtime key, then click Activate license.

Read more: Managing premium connectors.

Related articles