I am wondering if there is any way I can configure my CMP to make use of multiple databases with similar schema. For example, lets say I have this hosted application being used by 3 companies and lets say that i have 3 different databases for the 3 companies. All 3 databases wud contain exactly the same set of tables with different sets of data corresponding to the 3 companies. Based on the url, I would be able to figure out the datasource for that company. But will it be possible for me to persist the data to the right database. In the CMP descriptor, I dont think u can have entries for a single table with multiple databases. Am i right?

I think CMP can't have multiple data source.
U can't specify data source dynamically.