External data connections for custom fields in Jira Cloud

[Allison L Wenner]

I would like to create some custom fields in Jira that connect to external data, preferably MSSQL (on an internal network server) or Sharepoint if connecting to an internal server is not possible.  

What is the best way (app) to go about creating the connections?  I would like the data in the custom fields to be semi live, either have the fields populate at regular intervals (daily, weekly etc) or have a live connection to MSSQL or Sharepoint.  I am, however, concerned about a live connection that may cause performance issues with other SQL jobs, queries, etc and would prefer a connection that would refresh field options regularly.  

What I would like to do is have a user enter an item number and the rest of the form would populate based on the item number match with the data retrieved from MSSQL or Sharepoint.

[Kian Stack Mumo Systems]

I've used a couple of apps for that in the past. Depending on what you want, I think both the Elements Connect and External Data for Jira Fields and really good apps.

[Elyes Gannoun [Elements]]

Hello @Allison L Wenner ,

First, thank you @Kian Stack Mumo Systems for mentioning us, Elements Connect, as a good app :)

We do provide connected fields, that fetch data directly from different data source types (MSSQL or REST APIs).

We have not developed yet a way to refresh the data (we provide live fields on the Data Center of our app) because of performance issues like you mention but it is a subject that we are tackling right now.

We would love to talk to you regarding your use case and see how we can help solve it and shape our app for the future. If you're interested in talking to me, you can reach out directly using my personal calendar.

Let me know if you need further assistance!

Kind regards,
Elyes

[Allison L Wenner]

Does your app connect to Sharepoint?

[Elyes Gannoun [Elements]]

@Allison L Wenner , yes we do provide this type of connection, available by directly connecting to Microsoft's REST API using Client Credentials flow. 

You can follow the official Microsoft documentation and if needed, you can create a ticket on our support platform if any assistance is needed.

[Thomas Opiolka - codefortynine]

Hi @Allison L Wenner ,

To integrate data from MSSQL or SharePoint API into Jira, consider using the External Data for Jira Fields app. The app supports functionalities like field options synchronization, search fields, info panels, and dependent fields that you can use with your data source. 
To get started please check the documentation you can find here.

For further questions along the way, our support team is available to assist you.

It's advisable to also explore other app options for a comprehensive overview.

I hope this helps.

Regards,
Thomas

(P.S.: I am affiliated with the vendor of this app.)