[Gustavo]

Support for multiple databases in your models, also comes with a gii generator template to create models that belongs to other databases

how to use:

class MyModel extends MultiActiveRecord{
   //my methods
  function connectionId(){
  	return 'my_db';
  }
}

and in your config

'components'=>array(
//main db configuration
 	'db'=>array('..'),
 	//connection my_db
 	'my_db'=>array(
      	'class'=>'CDbConnection',
      	'connectionString'=>'mysql:host=localhost;dbName=my_db',
      	'username'=>'mySUsername',
      	'password'=>'myPassword'
 	),
 	//you can define other connections also
),
),

Detailed explanation here: extension link

[Gustavo]

Complete change in the code, check the extension link for more details

[Maurizio Domba]

Moved to "Extensions" as requested

[Gustavo]

Thank you