database connection

[Pepijn van der Krogt]

Hi

we are interested in Jira but we need to connect do another ERP by database connection (mySQL) , basically to import project and user data

is this possible?

[Radu Dumitriu]

I hope I understood correctly your problem.

Check this to see if it covers your needs: http://confluence.atlassian.com/display/JIRA043/JIRA+RPC+Services</p<>>

On the other hand sorry to praise myself, but you can also try this one: https://plugins.atlassian.com/plugin/details/43318 . It has a nice sql() routine and remote integration (you can call remote scripts on JIRA). Extra routines may be developed (the routines are pluggable). We used it in some heavy integration projects ...

There are also other plugins to help you integrate JIRA with your ERP, so pick and choose the ones you need.

[Pepijn van der Krogt]

thanks Martin,

I mis explained

we would need the creation of Jira projects from another app (our ERP) so being able to connect permanently

regards

[Martin Cooper]

Hi Pepijin,

Ahh I see yes a very different requirement, Its possible to create projects via the api, whether this can be embedded directly into your ERP system will depend on that system. But on the face of it is feasible but the devil will be in the detail.

Api docs here:

http://docs.atlassian.com/software/jira/docs/api/latest/

[Martin Cooper]

Anything is possible...given enough time and money... :)

Jira has a number of importers for bringing data across from other applications, if yours is not explicity listed then the csv based import is the fall back option.

Official docs here:

http://www.atlassian.com/software/jira/tour/data-importer.jsp

http://confluence.atlassian.com/display/JIRA043/Migrating+from+Other+Issue+Trackers

There is not a direct MySQL to MySQL convertor, and whilst one could be written, I would recommend the csv importer in the first instance, if you can extract your source data in this format. If this is something that you do not wish to do in house, Clearvision could assist. We are an Atlassian Premier Partner and specialise in migration solutions, contact details are on my profile.