Re: [xwiki-users] Query external MSSQL DB in a wiki page

I wrote:

I have managed the following with an external PostgreSQL server: Retrieve and display queried data in a page with Groovy; Write a Java component to perform query, call and display with Groovy or Velocity; Generate JSON data of query results with Groovy, call and display from LiveTable.

Happy to share but not near my computer till later today, so let me know which of the above is closest to what you want to do and I'll post something when I can.

I've put some examples into the following wiki page: http://platform.xwiki.org/xwiki/bin/view/DevGuide/ExternalDBAccess I hope that's the correct approach to sharing this kind of stuff - please advise if not.