Published in Archives
Dave Meyer

Published January 21, 2013 in Archives

Marketplace Monday: Connect Databases with nFeed for Jira

Getting all your data repositories in sync is a painful process. You might find yourself manually copying data from other sources on to Jira issues. If filling up field after field with the same information has become a nightmare, nFeed for Jira by Valiantys is a fantastic solution to display information directly from your database!

nFeed, developed by the French team Valiantys, is much more than a simple database connector for Jira; cascading selections, web service integration, and more dramatically increase the possibilities for using Jira as part of the IT stack. information systems. Companies using Jira need referential integrity for their data, and nFeed makes it possible.

Getting all your data repositories in sync is a painful process. You might find yourself manually copying data from other sources on to Jira issues. If filling up field after field with the same information has become a nightmare, nFeed for Jira by Valiantys is a fantastic solution to display information directly from your database! nFeed, developed by the French team Valiantys, is much more than a simple database connector for Jira; cascading selections, web service integration, and more dramatically increase the possibilities for using Jira as part of the IT stack. information systems. Companies using Jira need referential integrity for their data, and nFeed makes it possible. Import data from external databases Let’s say you have a long list of clients and related metadata stored in a CRM database. You’d like to have this information displayed in Jira issues, but typing clients' names in a custom field on each issue wastes time and search can be compromised by simple misspellings. With nFeed, you can create fields based on SQL queries that will allow users to pick the data up from your database. For example, they can choose a name from a list of clients or begin typing the name of a client and have suggestions displayed. Thanks to field dependencies, you can have some other related fields automatically filled when entering the client’s name, like their phone number or the software they use. All kinds of databases can be connected to Jira with nFeed, including PostgresQL, MSSQL, Oracle, DB2. Adapt your field to the type of information with searchable user-friendly field types: Select list Autocomplete textboxes Multiple-levels cascading fields Query results picker Valiantys has published a case study on how nFeed is used to integrated CRM data with Jira here. Extend Jira features by accessing the Jira database nFeed can also import data from the existing Jira database, giving it access to projects, components, users, issues, etc. This brings new possibilities to Jira since conditional requests can be performed on these values. For example, see the screenshot below of a 3-level cascading field, enabling users to select an issue depending on the category and the component: See this detailed use case to learn about how nFeed was used a Help Desk context. Import data from web services and remote files Imagine you want to fill some Jira issue fields with information from a table, you can set fields that query this data to return the format you want. You can reach this table if it is located on a remote file or a REST web service. Authentication can be managed automatically by nFeed for secured pages. Supported formats include JSON, CSV, and XML. What’s next for nFeed? Here's what Valiantys is planning for nFeed: Cascading fields on X levels for one field (currently limited to 3 levels) Ability to query an LDAP data source to display information about users An “all ears” support team Any ideas about how to improve nFeed? Need any help to using the plugin? Contact the Valiantys support team to submit your ideas and share them with other nFeed users. NEW in the Marketplace Track your agile team's daily scrum with Active Scrum for Jira by HGH Group Import your existing SVN codebase to Stash with Source Code Importer for Atlassian Stash by AppFusions Add annotations and captions to images directly from Confluence with Sketch for Confluence by Hotovo sro

Import data from external databases

Let’s say you have a long list of clients and related metadata stored in a CRM database. You’d like to have this information displayed in Jira issues, but typing clients’ names in a custom field on each issue wastes time and search can be compromised by simple misspellings. With nFeed, you can create fields based on SQL queries that will allow users to pick the data up from your database.

For example, they can choose a name from a list of clients or begin typing the name of a client and have suggestions displayed. Thanks to field dependencies, you can have some other related fields automatically filled when entering the client’s name, like their phone number or the software they use.

All kinds of databases can be connected to Jira with nFeed, including PostgresQL, MSSQL, Oracle, DB2.

Adapt your field to the type of information with searchable user-friendly field types:

  •  Select list
  •  Autocomplete textboxes
  •  Multiple-levels cascading fields
  •  Query results picker

Valiantys has published a case study on how nFeed is used to integrated CRM data with Jira here.

Extend Jira features by accessing the Jira database

nFeed can also import data from the existing Jira database, giving it access to projects, components, users, issues, etc. This brings new possibilities to Jira since conditional requests can be performed on these values. For example, see the screenshot below of a 3-level cascading field, enabling users to select an issue depending on the category and the component:

valiantys nfeed cascading drop down select

See this detailed use case to learn about how nFeed was used a Help Desk context.

Import data from web services and remote files

Imagine you want to fill some Jira issue fields with information from a table, you can set fields that query this data to return the format you want. You can reach this table if it is located on a remote file or a REST web service. Authentication can be managed automatically by nFeed for secured pages.

Supported formats include JSON, CSV, and XML.

What’s next for nFeed?

Here’s what Valiantys is planning for nFeed:

  •  Cascading fields on X levels for one field (currently limited to 3 levels)
  •  Ability to query an LDAP data source to display information about users

An “all ears” support team

Any ideas about how to improve nFeed? Need any help to using the plugin? Contact the Valiantys support team to submit your ideas and share them with other nFeed users.

NEW in the Marketplace

Marketplace Monday: Connect Databases with nFeed for Jira