Sync data from Maria

[Messerli Informatik AG]

Hi

At the moment we are testing jira service desk. the goal is that we can synchronize our crm (all info about our customers) with the jira so that we can assign the tickets to each client. The CRM is based on MariaDB.
Is there an app for Jira to sync MariaDB with Jira?

I thank you for every help

Kind Regards

Nadine

[Michael Kuhl {Appfire}]

Hi Nadine - You could use the Service Desk Command Line Interface (CLI) to read and write to both Jira Service Desk and MariaDB.

With a command as simple as:

--action runFromSql --sql "select client_email, client_id from client_list" --common "-a addUser --userId @client_id@ --userEmail @client_email@"

You could add all of your clients as users.  

Disclaimer:  I'm the product manager for the Bob Swift CLI line of products.

[Messerli Informatik AG]

Hi Michael

Thanks for your quick reply.
I will test this and contact you later.