How do i implement a multi-database connection? i had a current Code igniter complete application and it works fine. i am planning to re develop it in joomla using j-cook .below are my database structure in my codeigniter system .. is anyone can help me how to structure my code igniter database in j-cook?

In this db the codeigniter was installed and all its system

Main DB or code igniter db or like joomla main db

Database server : localhost
User : username
Pass:password
Db: name : dbaname

1 or DB1
In this db, one of my component was saved, where all the needed query fields are installed here..

Database server : localhost
User : username
Pass:password
Db: name : dbnamenew

Note! in DB1 there are lots of tables created and data, where i fetch them by client id, and batch class from DB1, i created these setup for traffic issues, i am looking for a better way of this where i can still implement the functions while keeping it fast and smart way of component development as one.


2 or DB2
In this db, my lists of clients details was saved

Database server : localhost
batch id : batch id from db 1 above
User : username
Pass:password
DB name : auto select by id


Note! in DB2 there are lots of clients specific database connections by db name, username, password and path, where i fetch them by client id, and batch class from DB1, i created these setup for traffic issues, i am looking for a better way of this where i can still implement the functions while keeping it fast and smart way of component development as one.

Questions

1. Can i do it in j-cook as one component? while implementing 3 database connections? How
2. For Main DB its a joomla installation
3. For DB 1 is the general database query provider for any component to be develop
4. For DB 2 is the lists of different client databases sorted by client id, start date, ending date and batch id
5. Is it possible to make it as a one component in j-cook pro? but hidden its all connected to those databases? and possibly more than that databases?

Please help me how to make it done in order for me to re write my fully functional codeigniter component structures stated in the databases line up above....

Your brilliant help will lead me to a more joomla component development..