I'm trying to find out if I can do the following:

Essentially, there is database A that we do not want to replicate, but we are transforming some of the data from into new values in database B. Only the transformed data will be stored in database B, but I want to be able to do this in the same hibernate object. For instance, I'd like to have an object that has a Collection of TransformedData objects, but that collection points to a different database and table structure. Is there any way to do this?

Thanks!