Can Issues be created and edited via a SQL Server

James Malgieri

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

Nic Brough -Adaptavist-

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.