I posted a shorter version of this message over at Rubyforge.

We are currently trying to integrate our Rails app with SFDC for use with multiple organizations and have come up with three possible solutions:

1) Using ActiveSalesForce

2) Building our own data-sync tool with a SOAP handler which captures outbound messages and then grabs data in from SFDC and updates our local MySQL.
 
3) Using Relational Junction with multiple DBs on our server and using a beforefilter :database_hijack to tell our app which DB to connect to for each connection

My question is whether there is any current functionality in ActiveSalesForce which allows not only for multiple connections to a local DB and Salesforce.com but also multiple accounts/organizations in Salesforce.

Is this something other people have dealt with and, if so, what did they do?