JIRA Plugin: SQL Feed
Written by Ivo Verlaek Monday, 11 April 2011 09:29
| Next > |
|---|
|
|
SQLFeed is a JIRA plugin developed by Valiantys which enables you to import values from any SQL Database. You can query any internal or external database and display the results in Multi-level cascading select fields in your JIRA screens.
This plugin dramatically increases the integration possibilities of your JIRA within your global Information System. You can query your CMDB (Configuration Management DataBase) to display technical information on JIRA, your Service Catalogue, in a service desk context, your CRM (Customer Relationship Management) – as SugarCRM – to display commercial information in your issues…
With the appropriate JDBC driver, you will be able to import values from a PostgreSQL, MySQL, Oracle, DB2, Microsoft SQL Server… You can define dependencies between the two Custom Fields ("SQL Combo Box", "SQL Cascading Select") and create infinite cascading selections.
Features
SQLFeed brings you three brand new Custom Fields SQL ComboBox, SQL Cascading Select and SQL Query Picker.
- SQL Cascading Select brings you natively three levels of selection.
- SQL Combo Box and the hierachy function allow you to create endless multi-cascading selections.
- SQL Query Picker to select data in huge recordset.
- Values can be selected from any database on your network
- Parent dependencies from other JIRA Custom Fields can be defined
- The display of selected values in the SQL Cascading Select and SQL Combo Box Custom Fields can be defined
- The administration interface facilitates the configuration of your query (no more JIRA stop & start)
- All the Custom Fields are searchable.
- Embedded control statements Velocity in your query
To access the full documentation, download the plugin or request an evaluation license please click here .
Use Cases
Here are four very classical use cases of SQLFeed :
- Select a client name stored in an external CRM database
- Select a supervisor or preferred assignee for a specific group in a JIRA issue
- Select a Knowkedge ticket in the JIRA project KM based on two criteria the software name and the component
- Select a Project with its component and its version in JIRA HelpDesk Ticket
Licenses terms and categories
New licenses
| Licenses SQLFeed for | Prices |
|---|---|
| JIRA 3.13 | $600 |
| JIRA 4.X | $600 |
Our software license entitles you to :
- Deploy a single instance of the product as a plugin to a single instance of JIRA in a production environment on 1 server
- Perpetual use
- Software maintenance for 12 months - including all updates and on-line support (Renewing maintenance is entirely optional)
| Maintenance SQLFeed for | Prices |
|---|---|
| JIRA 3.13 | $300 |
| JIRA 4.X | $300 |
Our maintenance entitles you to :
- Includes 1 year of product updates and support
- Software maintenance period will commence from the expiration date of the previous maintenance period, regardless of when the maintenance renewal is purchased. If you intend to renew, we recommend renewing at least 30 days before expiration.
Community
SQLFeed is free for use by official non-profit organisations and charities (proof of non-profit status is required). There are certain organisations whose purpose is to make the world a better place, and we believe in helping them achieve that.
Community licenses are designed for organisations which are:
- non-profit,
- non-government,
- non-academic,
- non-commercial,
- non-political
- secular
To apply for a Community License, send us an email specifying the following information:
- The registered name of your organization
- Your organization's URL
- a short description of your organization
Open Source
VALIANTYS supports and believes in the Open Source movement. SQLFeed is free for any Open Source project to use.
There are a few requirements for an Open Source license, the main ones being:
- Established code base
- Publicly available project website
- Using an approved open source license
- Your JIRA instance will be publicly accessible
- Project Name
- Project URL - Your project must have a public URL
- Project Description - Please outline the goals of your project and its intended users.
- JIRA Instance URL.
- Open Source License(s) used - Licenses must be on the list of licenses approved by the Open Source Initiative at http://opensource.org/licenses/alphabetical
- Where can we download your source code?
