Build Data Flows from SQL Server to Jira Service Management through SSIS

SQL Server databases are commonly used to store enterprise records. It is often necessary to move this data to other locations. The CData SSIS Task for Jira Service Management allows you to easily transfer Jira Service Management data. In this article you will export data from SQL Server to Jira Service Management.

Add Source and Destination Components

To get started, add a new ADO.NET Source control and a new Jira Service Management Destination control to the data flow task.

Configure the ADO.NET Source

Follow the steps below to specify properties required to connect to the SQL Server instance.

1. Open the ADO.NET Source and add a new connection. Enter your server and database information here.
2. In the Data access mode menu, select "Table or view" and select the table or view to export into Jira Service Management.
3. Close the ADO NET Source wizard and connect it to the destination component.

Create a New Connection Manager for Jira Service Management

Follow the steps below to set required connection properties in the Connection Manager.

1. Create a new connection manager: In the Connection Manager window, right-click and then click New Connection. The Add SSIS Connection Manager dialog is displayed.
2. Select CData JiraServiceDesk Connection Manager in the menu.
3. Configure the connection properties.

   You can establish a connection to any Jira Service Desk Cloud account or Server instance.

   Connecting with a Cloud Account

   To connect to a Cloud account, you'll first need to retrieve an APIToken. To generate one, log in to your Atlassian account and navigate to API tokens > Create API token. The generated token will be displayed.

   Supply the following to connect to data:

   • User: Set this to the username of the authenticating user.
   • APIToken: Set this to the API token found previously.

   Connecting with a Service Account

   To authenticate with a service account, supply the following connection properties:

   • User: Set this to the username of the authenticating user.
   • Password: Set this to the password of the authenticating user.
   • URL: Set this to the URL associated with your JIRA Service Desk endpoint. For example, https://yoursitename.atlassian.net.

   Note: Password has been deprecated for connecting to a Cloud Account and is now used only to connect to a Server Instance.

   Accessing Custom Fields

   By default, the connector only surfaces system fields. To access the custom fields for Issues, set IncludeCustomFields.

Configure the Jira Service Management Destination

In the destination component Connection Manager, define mappings from the SQL Server source table into the Jira Service Management destination table and the action you want to perform on the Jira Service Management data. In this article, you will insert Requests entities to Jira Service Management.

1. Double-click the Jira Service Management destination to open the destination component editor.
2. In the Connection Managers tab, select the connection manager previously created.
3. In the Use a Table, menu, select Requests. In the Action menu, select Insert. 👁 The destination table and action to be performed.
   
4. On the Column Mappings tab, configure the mappings from the input columns to the destination columns. 👁 The mappings from the SQL Server source to the SSIS destination component.
   

Run the Project

You can now run the project. After the SSIS Task has finished executing, data from your SQL table will be exported to the chosen table.