Using a Plugin to add data to an SQL Database

[Thomas Hardin]

Is there a plugin that is avaiable that will allow me to enter data into an SQL database? I want to be able to create simple forms where users can enter data and reference when needed.

For example, if I have a product with multiple requirements, which are inventoried in an SQL Database, with metadata:

• Category - A
• Section - B
• Sub Section - 2
• Requirement - X = Y when Z is present

I want my users to access a Confluence page, where they can view requirements by using a form where they enter specific data (dynamic query of sorts) and then if needed, they can submit feature requests to add or change them.

[Davin Studer · Accepted solution]

There are a few options available to you. You could use Bob Swift's SQL plugin plus the Run plugin. Or you could use Play SQL Spreadsheets. Another option would be to create your own web service that can enter the data. The you create a form on a Confluence page and submit that data to the web service via ajax. You could use the html macro to add the form and requisite javascript to the Confluence page. You would probablu have to keep in mind to work around CORS(cross origin scripting). You can get around that with JSONP or setting up http headers to allow CORS. If you don't have the programming knowledge to do it yourself I would reccomend the plugins above.

[Thomas Hardin]

Thank you Davin! This really helps out.

[Davin Studer]

Feel free to mark the answer if it meets your needs.

[Thomas Hardin]

I think I did already, but I'm new to this. so, if i haven't, tell me how.

[Davin Studer]

Below the up and down arrows on an answer there is a check mark. Clicking on that marks the question as answered.

[Martin]

Hello Thomas and David

I want to know if these answer actually helps you?  and if it did, can it also be applied in JIRA server or are there any plugins similar for JIRA??