Drupal Views Integration with Drupal + CiviCRM databases on different hosts

Question

A few weeks ago, we did a mainly successful migration of a Drupal/CiviCRM site from one hosting provicer to another one. Now, we realized, that some Drupal Views do not work anymore!

Configuring a Drupal Views CiviCRM Integration is well described in this document: https://docs.civicrm.org/sysadmin/en/latest/integration/drupal/views/

And of course, we already put in the statements from civicrm/admin/setting/uf?reset=1

However, our new hosting provider puts the databases on different hosts (and is not able to move them to the same host)! However, the instruction in the above link says: "These instructions assume CiviCRM and Drupal are on separate databases located on the same physical host."

Any idea what I should put into the settings.php to get that to work?

(a workaround might be, migrating Drupal and CiviCRM into the same database - but that is something I would like to avoid...)

Answer 1

You could try CiviCRM Entity in combination with the EFQ Views module. The entity field query views module uses an alternative query backend. Since CiviCRM Entity uses the api to load entities, it doesn't depend on the SQL being in a particular place. Disclaimer, I haven't tried this for your particular use case, and the field and filter handlers will be rough around the edges, but it won't take long to experiment.

Answer 2

It seems, that views integration will never work, if the Drupal and CiviCRM databases are located on different hosts.

If you encounter the same problem, and your hosting provider also were not able to move the two databases to the same host, maybe the following hack might help: When I create 2 new databases immediately one after the other, my hoster will most probably put them on the same host - and everything works well again. That helped for me...