Use webform module, passing variables, external database, other modules...

Any hints on what modules (and general approach) I could use to solve this issue:

1) user will enter input (for instance a personal id)
2) input variable will then be key for a sql query in an external Oracle database
3) result from external db query should be presented "inside" my drupal site
4) it might be nice to present the query result in "different" places on page

For 1) I have started testing with webform module, but struggeling somewhat with passing variables to page
where sql query is initiated.. Otherwise some search box or form could be used, but it would be nice to have
the logging facility in place as in webform
For 4) it might be useful to use views module maybe?

Between step 1 and 4 there are a lot that needs to work. I have read hundreds of posts without finding a good
description of this kind of workflow (pulling input, passing variables to other internal pages, querying external
database, presenting result etc).

I have most of the steps working as stand-alone "jobs". But I am not sure how much work I should put in to get
it all working together if this is not the best approach after all...

Appreciate any thoughts on this topic.

/Mike