Refering to a extern database

Question

Hey everyone,

i wanted to ask if there is a way i , to refer in a page  to a data on a different database with a link?? or is there any patch or tool for this??

i know that u can link data from ur pc or network to a page! but how do i refer to a database where for example constructionplans are ???

greetings david

David Soldan · Answer

Thanks for your answer!

But i meant something else.

For example: the company i work for got different  Sql Databases. The question now is if it is possible to get Information/Files from this databases with some sort of tool/plugin, to show them on some pages so you don't have to update every attachment (manuals(for products which are paged in the wiki), processes etc.). I know now that there is a SQL- Plugin for Confluence, but i have to get into it .

Greetings David

Jim Birch · Answer

Your question is a little vague but if you are talking about displaying html information from a different webserver you could create a User Macro to do this. The macro below would display a page on the company product database using page macro like {showproduct:1049} To create the macro, go to Admin | User Macros | create a new Macro Name: (eg) showproduct Title: Display product page page No Macro Body Output HTML Template:

Open this external product page.

You can vary this to suit your needs. Allowing any arbitrary web address could be a security risk so it is better to only allow the macro user to specify the page id not the full url.