Jira Connector
Documentation
Version: 6
Documentation

Using Jira Connector in SSIS


To use Jira Connector you will have to download & install SSIS PowerPack. There are two versions of SSIS PowerPack to download: TRIAL and FULL:

Download SSIS PowerPack

Download TRIAL VERSION  if you are trying it out (30-days fully functional product).

or

Download FULL VERSION  if you already have purchased the product.


Install SSIS PowerPack

By installing SSIS PowerPack you will install ZappySys SSIS Tasks and Components. Installing SSIS PowerPack is pretty straightforward. Installing a TYPICAL version will install components required for each version of SQL Server.


Video Tutorial - Read Jira data

This video covers following and more so watch carefully. After watching this video follow the steps described in this article.

  • How to download SSIS PowerPack for Jira integration
  • How to configure connection for Jira
  • How to Read data from Jira
  • Features about SSIS API Source
  • Using Jira Connector


How to find installed SSIS Tasks/Components?

After installation, new ZappySys SSIS tasks/components will appear under SSIS toolbox, when using from within Control Flow and Data Flow. Check in both places and verify that new components are present.

  1. Open Visual Studio (i.e. SSDT or SQL Server Data Tools)
  2. Open existing SSIS Project or Create new by clicking on Project > Business Intelligence > Integration Services Project
  3. Once SSIS Package Designer is open, Click on the Control Flow Tab and locate SSIS Toolbox. If toolbox is hidden then right click in the blank designer surface area and click SSIS Toolbox menu item
  4. Check SSIS Toolbox. Any items starting with ZS are ZappySys SSIS PowerPack Tasks
  5. Do the same thing to find Data Flow Components
  6. Click on Data Flow Tab and you will see SSIS Toolbox will refresh. Any items starting with ZS are ZappySys SSIS PowerPack Components
  7. To use them, simply drag and drop ZappySys SSIS PowerPack connectors into the workspace
ssis-toolbox-where-is-control-flow-task-data-flow-components.png

What if SSIS PowerPack connectors are not visible

If connectors are not visible, then try following the steps described in this page: What should I do if I don't see ZappySys SSIS PowerPack connectors in SSIS toolbox in Visual Studio.

Conclusion

Once you have installed SSIS PowerPack you are ready to use Jira Connector. To see how to start using it check the next section -- Read from Jira