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

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,


1 answer

1 accepted

3 votes
Answer accepted
Nic Brough 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.

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.


Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

[Survey] Development tools and DevOps - share your thoughts!

Hey Community! I work at Atlassian in product marketing and we are conducting a survey to better understand how people feel about their development tool chain and DevOps. We would love if you could...

120 views 1 2
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