Accessing external database from partial view macro

Can anyone advise the best way of displaying external data using a partial view macro?

I need to get data from an external database into my Umbraco (v6 MVC) website.
I’ve done something similar with surface controllers which are being fired from a partial view in a template. However I now have a requirement to show data from an external table the view of which will differ depending on which page it’s called from. I think a macro is the way to go as I don’t want to have to create a template for each page and I can use parameters

Thanks!


This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/49750-accessing-external-database-from-partial-view-macro