Using a Plugin to add data to an SQL Database

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.

1 answer

1 accepted

1 vote
Davin Studer Community Champion Jan 26, 2014

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.

Thank you Davin! This really helps out.

Davin Studer Community Champion Jan 27, 2014

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

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

Davin Studer Community Champion Jan 28, 2014

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

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Hipchat

Moving from Hipchat to Stride? Here’s what you’ll love

Heya, Hipchat friends! We’re so happy you’re checking out   Stride. Whether you know it or not, you have been instrumental in making Stride come to life. Every feature, design, and functionality...

81 views 3 6
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you