I've got some ideas about building a system in RoR, but it will require connection to 3 separate databases (it's a front end to three existing systems). What's the best way to do this in RoR? So far I've only been able to connect to a single database by specifying it in the database configuration file. I've Googled and found some stuff about connecting to more than one, but it seemed quite messy and unwieldy and just plain not very Rails like!
I bump into this today http://www.robbyonrails.com/articles/2007/10/05/multiple-database-connections-in-ruby-on-rails check it out