Get/create user-specific credentials to access external datasource in user-macro

I'm using AJAX in user-macro's to display data from an external database on confluence pages. Now I'd like to show user-specific data from that external database, preferably without the confluence-user having to enter a username and password.

I don't have much experience with velocity or java, so I'm not sure which way to go. I'm thinking about getting the confluence-username in velocity, encrypt it in velocity, and use it that to authenticate with the external database. But what type of encryption is possible in velocity?

Or maybe there is another user-specific variable available in the velocity contexts, so I can use that along with the username to authenticate?

Or should I go with a completely different approach?

1 answer

Consider using the Confluence SQL Plugin it uses application server datasources. Use the Confluence Cache Plugin for performance reasons.

I'm not sure if I explained it clear enough, but the SQL plugin wouldn't solve my problem, looking at this issue: https://bobswift.atlassian.net/browse/SQL-11 . That and my datasource only works with AJAX/JSONP.

The Confluence Cache Plugin looks promising. I was also thinking about using your Script Plugin to use Beanshell to encrypt the username. Too bad the plugins are not yet compatible with Confluence 4.2.4.

Ok. All these plugins are compatible with 4.x including 4.2. Marketplace should be automatically updating the point release compatibility for plugins, but isn't at the moment. I correct when someone mentions it.

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 Marketplace Apps

Tips on how to choose the best estimation method for your planning

Planning and grooming sessions all come with their own sets of rules. Team members meet to estimate stories or other work items, all according to an agreed-upon process. And with every session comes ...

55 views 0 11
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