can I export data from sql to Jira ?

[HALİL KORKMAZ]

I have mission about showing some data to Gantt char that mean is Timeline. But my data in the MSSQL database. How can I export data from SQL database to Jira? If there is more than one way please tell me. It can be witih API or Apps. I saw that SQL connector for Jira. But It exports data from JIRA to SQL. I couldn't see two way data export instractions. If there is please tell me.  

[Thomas Opiolka - codefortynine]

Hi @HALİL KORKMAZ ,

In case you dynamically need this data from the MSSQL database you can also use the App External Data for Jira Fields, that lets you connect to a MSSQL database and fetch data to Jira native custom fields via dependant fields configurations.

This approach is more dynamic than a one-time import. However, with some adjustments, the dependent fields can be triggered in bulk to perform actions similar to an import.

I should disclose that I am involved with the vendor of this app.

I hope this helps.

Thomasi

[Aron Gombas _Midori_]

Elements Connect can read data from SQL database to Jira custom fields.

You should be able to read the "start date", "end date" and the usual task oriented field values to standard Date Picker type fields. Having the data there, you could use the built-in Roadmap functionality to display the view you are looking for.

(You can probably do this without any programming!)

[Fazila Ashraf]

Hi @HALİL KORKMAZ 

Welcome to community!

Can you export the MSSQL data in csv format?

Then you can use csv importer https://support.atlassian.com/jira-software-cloud/docs/create-issues-using-the-csv-importer/ to load that data into jira.