valiantys-logo
Back

Retrieving end user data from an external database into JIRA with nFeed

Valiantys Software is now Elements, a Valiantys company

We might have changed our name, but we’re the same team behind Elements. The new Elements brand and visual redesign reflect our identity as a software publisher and are a  reminder of the connectivity between our different apps. As part of the rebranding, our products have new names: nFeed is now Elements Connect, Exocet is now Elements Copy & Sync, Elements is now Elements Checklist, and Spreadsheets is now Elements Spreadsheet.

To read more, check out our announcement from March 20, 2019.

 

Working in a company implies juggling many tools on a daily basis: a project management tool, a bug tracking tool, your calendar, a time tracking tool, a CRM, etc.

Different information is stored in all of these tools, but unfortunately they’re separated and often can’t be linked. Some companies tried to find a workaround with Atlassian products by duplicating the data into JIRA. However, it takes a lot of time to create everything and change the configuration every time data changes in one of the tools. This workaround happens to be time-consuming and hard to maintain for project managers and JIRA administrators.

With nFeed, our JIRA add-on, we found a way to link any SQL database to JIRA and synchronise the data.

Linking your external data and JIRA: a headache?

If you’re reading this article, it probably means you already have difficulties in linking your external data with JIRA or that you’ve spent a lot of time recreating data in JIRA.

In order to illustrate my point, I will use an asset management example.

Let’s say my assets are stored in a SCCM database. So to start, I’ve got asset information on one side.

Asset information
Information stored in SCCM

And I want to link my asset to JIRA but I can’t fetch the asset information for this issue.

Asset Vs JIRA
Information in JIRA

Until now, only two solutions could resolve this disconnect in information:

  • Switch between context: your issue in JIRA and information in your external database.
  • Recreate all the information already stored in your external database in JIRA – which means the process is long and hard to maintain.

Don’t panic yet! Valiantys provides a solution called nFeed, which is a JIRA add-on that links your external database to JIRA in an easy and efficient way.

One JIRA add-on, tons of use cases

I listed below a few examples of use cases, but you really can link any data and database with JIRA. You simply have to choose what information you want to display in your issues.

With nFeed, you can for instance:

  • Manage your assets in JIRA
  • Link an old tool to JIRA
  • Inject fields with Confluence data
  • Query a REST API
  • Retrieve data from a user directory

nFeed as a link between JIRA and your external data

Let me explain how nFeed can be configured with an external database.

Step 1: declare your external database

Open the Datasources section of the nFeed configuration page, click on Create a datasource then select Database.

screenshot-greygoose.valiantyscloud.net 2017-02-23 13-26-36
Database configuration

Fill in the required information; the databases supported by nFeed are MySQL, SQL Server, Oracle and Postgresql. Use the Test connection button to validate your configuration.

You’ll find more details on the database configuration in the product documentation.

Step 2: create your custom fields

The next step is to create all your custom fields as nFeed type, depending on how much information you want to add to JIRA.

For my use case I’ve created 3 nFeed fields :

  • Asset ID – An autocomplete where the user can select the ID of an asset
  • Asset Manufacturer – A read-only field, it will display the manufacturer of the asset selected by in Asset ID
  • Asset Model & Asset Model number – Similar to Asset manufacturer, they’ll display information related to the selected asset.

Once they’re created, we can configure them via nFeed “Configure fields” section

Step 3: configure your fields

Let’s configure Asset ID:

screenshot2-greygoose.valiantyscloud.net 2017-02-23 16-01-05

Here we setup the query to execute on our database to retrieve the IDs of the assets stored in our database. This field will be editable with an autocomplete.

That’s it! Now let’s configure the fields which are dependent on the asset ID:

screenshot3-greygoose.valiantyscloud.net 2017-02-23 16-01-43

We use Velocity in the query to add a reference to the Asset ID field, we do that with the $issue.customfield_11502 instruction.

This field will display the model of the asset selected in Asset ID. It is a read-only field: it can’t be edited by the end user.

The configuration of Asset model number and Asset manufacturer is similar to Asset model, we only change the column to retrieve.

 Step 4: Display your fields

Your nFeed fields are like any other field, meaning you can add them to every screen in JIRA – even JIRA Service Desk requests!

For my example, I’ve added them to a JSD request type.

As you can see below, I give the asset ID and all information related to this asset is generated. I can only change the asset ID, as all the other fields are in read-only mode.

 

Create a request from the customer portal
Create a request from the customer portal

 

View a request (customer view)
View a request (customer view)

 

View a request (agent view)
View a request (agent view)

And from now on you can have every external data displayed in your JIRA.

JIRA and your external database seamlessly integrated for more efficiency

Having different tools to manage your company is no longer a problem – with nFeed you have the one tool to link them all. Furthermore, nFeed datasources are not limited to databases, you can also query a REST API, a User Directory or any Atlassian application linked to your JIRA instance!

Stop spending time duplicating your data between your tools and JIRA when you can just synchronise them with nFeed.

Did you already try to link JIRA with a database? Leave a comment below to tell us your experience!

 

Cutted Triangle

Subscribe to Valiantys Newsletter

Registered request ! Subscribing... This is not an email An error occured

In accordance with our privacy policy, we are committed to respecting your personal data.

Contact us

Our Atlassian certified consultants will be happy to answer you.

Join us

We're building the next dream team - Are you in?

Follow us

We use cookies for the operation of our website. This is to improve its use, to personalize your experience, and to compile visitor statistics. By continuing to use this site, you consent to this policy. You can manage the settings and choose whether or not to accept certain cookies whilst browsing. For more information, see our privacy policy. Our privacy policy

Privacy settings

In order to facilitate your navigation and to provide you with the best possible service, we use cookies to improve the site to the needs of our visitors, particularly according to the number of visitors. For more information, please read our privacy policy. Our privacy policy

Recaptcha

Google reCAPTCHA is a system designed to distinguish humans from computers, so that bots are unable to maliciously fill out forms on behalf of a human being.

Analytics

Used to send data to Google Analytics about the visitor's device and behavior. Tracks the visitor across devices and marketing channels. Used by the social sharing platform AddThis to store the user's usage history of the AddThis sharing widget. Registers a unique ID that is used to generate statistical data on how the visitor uses the website.