I wish to connect my drupal powered site to another database, in which i have certain data. I wish to have a page on my site with filters which the users select and then displays the data relevant to the filters they selected.
How would I be able to do this? Creating a special node type adding data to it, saving it to an external database and then applying filters to it somehow using taxconomy? Using the feeds module and applying filters to them, somehow?
I would really appreciate any approaches to this idea.