It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Can Issues be created and edited via a SQL Server

James Malgieri May 02, 2019

A customer has thousands of records in a SQL db and wants to create new JIRA issues and import data directly in the custom issue fields via scripts.

I have always imported data into JIRA via CSV files.

Is it possible, or practical, to create new Issues and populate fields from a SQL database as new data is added to the SQL database?

Apart from CSV file imports, how do users usually get huge amounts of data into JIRA?

Thanks For your Help,

Jim

1 answer

1 accepted

3 votes
Answer accepted
Nic Brough [Adaptavist] Community Leader May 02, 2019

Hard to say what the numbers are, but I know people are using these a lot:

  • CSV
  • Project imports second, usually aided by the apps that can bring in project configuration from other Jira systems
  • External scripts that post data via REST
  • Imports from other systems that Jira has importers for

No-one in their right mind does it with SQL - reading a database for issues to import is fine, but writing to a Jira database is a nightmare, cross that off the list now.

James Malgieri May 03, 2019

Nic, thank you for confirming "No-one in their right mind does it with SQL . . . writing to a Jira database is a nightmare". 

For the last year I've been doing CSV imports, have also used Project Configurator when needed, only slightly looked at REST and haven't needed to import from other systems, yet.

Thank you for your input.  I'm sure I'll be asking more qustions as I find out more.

Jim

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Jira Software

Early Access: If you use Jenkins and Jira Software Cloud, you need to read this!

The Jira Software Cloud Team has been busy working on a simple, secure, and reliable way to integrate your build and deployment information from Jenkins with Jira Software Cloud. This means you don’t...

255 views 0 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you