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: . 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
Community showcase

Scrum Roles Explained: the Do's and the Don'ts

Hello Community,  Today we are going to talk about the three Scrum Roles. There is the Development Team, the Scrum Master and the Product Owner. In my opinion these three are all really impo...

97 views 0 4
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