CiviCRM Community Forums (archive)

I have some general questions about Views integration, after which I will plan to update the Civi Documentation which appears a little lacking in clarity at this time.

I have a Drupal database and a CiviCRM database. For the purposes here, drupal db is called 'drupaldb' and civi db is called 'civicrmdb'. I want to use Views integration.

The only way I have been able to successfully get this integration working is to follow this: http://redspire.net/content/civicrm-views-2-integration-remote-civicrm-database

Meaning:
1) Add a new value to the $db_url array in settings.php like $db_url['civicrm'] = 'mysql://user:pass@localhost/civicrmdb';
2) Go into civicrm/drupal/modules/views/civicrm.views.inc and search out every array definition for $data['table_name']['table']['base'] and add "'database' => 'civicrm'," to the array.

My questions:
- Is there no way to achieve this scenario at present without adjusting civicrm/drupal/modules/views/civicrm.views.inc
- If no way exists at present is there a plan for easier integration?
- If no plan exists yet for easier integration, is there a reason that a field for db_url couldn't be added to CMS settings page in Civi? If filled in (and assuming one still manually applied the $db_url addition to settings.php), then couldn't civicrm/drupal/modules/views/civicrm.views.inc easily pull that value and write the database entries (and leave set to 'default' if not filled in)?

Thanks for your comments.

EDIT issue resolved itself. No idea how but it's all fine now. Return to your homes, nothing to see here.