DBI has no problem crossing storage types and/or databases within a single RDBMS, but I'm not sure if it or DBIx::Class can span different instances out of the box. You could create an interface to the different schemas you have using multiple
objects. That does mean you would have to tie them together yourself, but it might not be so bad because you can extend the code dbicdump generated with your own methods.