We have one CiviCRM installion which works with a Domain Access site. We don't use the Multisite feature of CiviCRM.
I juft tryed to aneble view intigration for CiviCRm whoch is done by adding some code to the settings.php file. Because CiviCRM has it's own Database.

$databases['default']['default']['prefix']= array(
        
  'civicrm_acl'                              => '`dafmr_crm`.',
  'civicrm_acl_cache'                        => '`dafmr_crm`.',
  'civicrm_acl_contact_cache'                => '`dafmr_crm`.',
  'civicrm_acl_entity_role'                  => '`dafmr_crm`.',
  'civicrm_action_log'                       => '`dafmr_crm`.',
  'civicrm_action_mapping'                   => '`dafmr_crm`.',
  'civicrm_action_schedule'                  => '`dafmr_crm`.',
  'civicrm_activity'                         => '`dafmr_crm`.',
  'civicrm_activity_assignment'              => '`dafmr_crm`.',
  'civicrm_activity_target'                  => '`dafmr_crm`.',
  'civicrm_address'                          => '`dafmr_crm`.',
  'civicrm_address_format'                   => '`dafmr_crm`.',
  'civicrm_batch'                            => '`dafmr_crm`.',
  'civicrm_cache'                            => '`dafmr_crm`.',
  'civicrm_campaign'                         => '`dafmr_crm`.',
  'civicrm_campaign_group'                   => '`dafmr_crm`.',
  'civicrm_case'                             => '`dafmr_crm`.',
  'civicrm_case_activity'                    => '`dafmr_crm`.',
  'civicrm_case_contact'                     => '`dafmr_crm`.',
  'civicrm_component'                        => '`dafmr_crm`.',
  'civicrm_contact'                          => '`dafmr_crm`.',
  'civicrm_contact_type'                     => '`dafmr_crm`.',
  'civicrm_contribution'                     => '`dafmr_crm`.',
  'civicrm_contribution_page'                => '`dafmr_crm`.',
  'civicrm_contribution_product'             => '`dafmr_crm`.',
  'civicrm_contribution_recur'               => '`dafmr_crm`.',
  'civicrm_contribution_soft'                => '`dafmr_crm`.',
  'civicrm_contribution_type'                => '`dafmr_crm`.',
  'civicrm_contribution_widget'              => '`dafmr_crm`.',
  'civicrm_country'                          => '`dafmr_crm`.',
  'civicrm_county'                           => '`dafmr_crm`.',
  'civicrm_currency'                         => '`dafmr_crm`.',
  'civicrm_custom_field'                     => '`dafmr_crm`.',
  'civicrm_custom_group'                     => '`dafmr_crm`.',
  'civicrm_dashboard'                        => '`dafmr_crm`.',
  'civicrm_dashboard_contact'                => '`dafmr_crm`.',
  'civicrm_dedupe_exception'                 => '`dafmr_crm`.',
  'civicrm_dedupe_rule'                      => '`dafmr_crm`.',
  'civicrm_dedupe_rule_group'                => '`dafmr_crm`.',
  'civicrm_discount'                         => '`dafmr_crm`.',
  'civicrm_domain'                           => '`dafmr_crm`.',
  'civicrm_email'                            => '`dafmr_crm`.',
  'civicrm_entity_batch'                     => '`dafmr_crm`.',
  'civicrm_entity_file'                      => '`dafmr_crm`.',
  'civicrm_entity_financial_trxn'            => '`dafmr_crm`.',
  'civicrm_entity_tag'                       => '`dafmr_crm`.',
  'civicrm_event'                            => '`dafmr_crm`.',
  'civicrm_event_carts'                      => '`dafmr_crm`.',
  'civicrm_events_in_carts'                  => '`dafmr_crm`.',
  'civicrm_file'                             => '`dafmr_crm`.',
  'civicrm_financial_account'                => '`dafmr_crm`.',
  'civicrm_financial_trxn'                   => '`dafmr_crm`.',
  'civicrm_grant'                            => '`dafmr_crm`.',
  'civicrm_group'                            => '`dafmr_crm`.',
  'civicrm_group_contact'                    => '`dafmr_crm`.',
  'civicrm_group_contact_cache'              => '`dafmr_crm`.',
  'civicrm_group_nesting'                    => '`dafmr_crm`.',
  'civicrm_group_organization'               => '`dafmr_crm`.',
  'civicrm_im'                               => '`dafmr_crm`.',
  'civicrm_job'                              => '`dafmr_crm`.',
  'civicrm_job_log'                          => '`dafmr_crm`.',
  'civicrm_line_item'                        => '`dafmr_crm`.',
  'civicrm_loc_block'                        => '`dafmr_crm`.',
  'civicrm_location_type'                    => '`dafmr_crm`.',
  'civicrm_log'                              => '`dafmr_crm`.',
  'civicrm_mail_settings'                    => '`dafmr_crm`.',
  'civicrm_mailing'                          => '`dafmr_crm`.',
  'civicrm_mailing_bounce_pattern'           => '`dafmr_crm`.',
  'civicrm_mailing_bounce_type'              => '`dafmr_crm`.',
  'civicrm_mailing_component'                => '`dafmr_crm`.',
  'civicrm_mailing_event_bounce'             => '`dafmr_crm`.',
  'civicrm_mailing_event_confirm'            => '`dafmr_crm`.',
  'civicrm_mailing_event_delivered'          => '`dafmr_crm`.',
  'civicrm_mailing_event_forward'            => '`dafmr_crm`.',
  'civicrm_mailing_event_opened'             => '`dafmr_crm`.',
  'civicrm_mailing_event_queue'              => '`dafmr_crm`.',
  'civicrm_mailing_event_reply'              => '`dafmr_crm`.',
  'civicrm_mailing_event_subscribe'          => '`dafmr_crm`.',
  'civicrm_mailing_event_trackable_url_open' => '`dafmr_crm`.',
  'civicrm_mailing_event_unsubscribe'        => '`dafmr_crm`.',
  'civicrm_mailing_group'                    => '`dafmr_crm`.',
  'civicrm_mailing_job'                      => '`dafmr_crm`.',
  'civicrm_mailing_recipients'               => '`dafmr_crm`.',
  'civicrm_mailing_spool'                    => '`dafmr_crm`.',
  'civicrm_mailing_trackable_url'            => '`dafmr_crm`.',
  'civicrm_mapping'                          => '`dafmr_crm`.',
  'civicrm_mapping_field'                    => '`dafmr_crm`.',
  'civicrm_membership'                       => '`dafmr_crm`.',
  'civicrm_membership_block'                 => '`dafmr_crm`.',
  'civicrm_membership_log'                   => '`dafmr_crm`.',
  'civicrm_membership_payment'               => '`dafmr_crm`.',
  'civicrm_membership_status'                => '`dafmr_crm`.',
  'civicrm_membership_type'                  => '`dafmr_crm`.',
  'civicrm_menu'                             => '`dafmr_crm`.',
  'civicrm_navigation'                       => '`dafmr_crm`.',
  'civicrm_note'                             => '`dafmr_crm`.',
  'civicrm_openid'                           => '`dafmr_crm`.',
  'civicrm_option_group'                     => '`dafmr_crm`.',
  'civicrm_option_value'                     => '`dafmr_crm`.',
  'civicrm_participant'                      => '`dafmr_crm`.',
  'civicrm_participant_payment'              => '`dafmr_crm`.',
  'civicrm_participant_status_type'          => '`dafmr_crm`.',
  'civicrm_payment_processor'                => '`dafmr_crm`.',
  'civicrm_payment_processor_type'           => '`dafmr_crm`.',
  'civicrm_pcp'                              => '`dafmr_crm`.',
  'civicrm_pcp_block'                        => '`dafmr_crm`.',
  'civicrm_persistent'                       => '`dafmr_crm`.',
  'civicrm_phone'                            => '`dafmr_crm`.',
  'civicrm_pledge'                           => '`dafmr_crm`.',
  'civicrm_pledge_block'                     => '`dafmr_crm`.',
  'civicrm_pledge_payment'                   => '`dafmr_crm`.',
  'civicrm_preferences_date'                 => '`dafmr_crm`.',
  'civicrm_premiums'                         => '`dafmr_crm`.',
  'civicrm_premiums_product'                 => '`dafmr_crm`.',
  'civicrm_prevnext_cache'                   => '`dafmr_crm`.',
  'civicrm_price_field'                      => '`dafmr_crm`.',
  'civicrm_price_field_value'                => '`dafmr_crm`.',
  'civicrm_price_set'                        => '`dafmr_crm`.',
  'civicrm_price_set_entity'                 => '`dafmr_crm`.',
  'civicrm_product'                          => '`dafmr_crm`.',
  'civicrm_project'                          => '`dafmr_crm`.',
  'civicrm_relationship'                     => '`dafmr_crm`.',
  'civicrm_relationship_type'                => '`dafmr_crm`.',
  'civicrm_report_instance'                  => '`dafmr_crm`.',
  'civicrm_saved_search'                     => '`dafmr_crm`.',
  'civicrm_setting'                          => '`dafmr_crm`.',
  'civicrm_state_province'                   => '`dafmr_crm`.',
  'civicrm_subscription_history'             => '`dafmr_crm`.',
  'civicrm_survey'                           => '`dafmr_crm`.',
  'civicrm_tag'                              => '`dafmr_crm`.',
  'civicrm_task'                             => '`dafmr_crm`.',
  'civicrm_task_status'                      => '`dafmr_crm`.',
  'civicrm_tell_friend'                      => '`dafmr_crm`.',
  'civicrm_timezone'                         => '`dafmr_crm`.',
  'civicrm_uf_field'                         => '`dafmr_crm`.',
  'civicrm_uf_group'                         => '`dafmr_crm`.',
  'civicrm_uf_join'                          => '`dafmr_crm`.',
  'civicrm_uf_match'                         => '`dafmr_crm`.',
  'civicrm_value_ausweisdaten_1'             => '`dafmr_crm`.',
  'civicrm_value_communication_details'      => '`dafmr_crm`.',
  'civicrm_value_constituent_info'           => '`dafmr_crm`.',
  'civicrm_value_contact_info'               => '`dafmr_crm`.',
  'civicrm_value_demographics'               => '`dafmr_crm`.',
  'civicrm_value_elected_official_info_22'   => '`dafmr_crm`.',
  'civicrm_value_event_details'              => '`dafmr_crm`.',
  'civicrm_value_funder_info_21'             => '`dafmr_crm`.',
  'civicrm_value_grant_info'                 => '`dafmr_crm`.',
  'civicrm_value_grassroots_info'            => '`dafmr_crm`.',
  'civicrm_value_media_info_20'              => '`dafmr_crm`.',
  'civicrm_value_media_outlet_info_19'       => '`dafmr_crm`.',
  'civicrm_value_organizational_details'     => '`dafmr_crm`.',
  'civicrm_value_participant_info'           => '`dafmr_crm`.',
  'civicrm_value_proposal_info'              => '`dafmr_crm`.',
  'civicrm_value_voter_info'                 => '`dafmr_crm`.',
  'civicrm_value_weitere_angaben_2'          => '`dafmr_crm`.',
  'civicrm_view_case_activity_recent'        => '`dafmr_crm`.',
  'civicrm_view_case_activity_upcoming'      => '`dafmr_crm`.',
  'civicrm_website'                          => '`dafmr_crm`.',
  'civicrm_worldregion'                      => '`dafmr_crm`.',
);

Views intigrations works ok with CiviCRM so far, but i get this Notice as soon as i added this code into settings.php.
Notice: Undefined index: default in domain_get_primary_table() (line 266 of /srv/htdocs/sites/all/modules/domain/domain.bootstrap.inc).

So my question is, what is the right way to do this with DA?

Comments

agentrickard’s picture

I think you need to add this item to the array:

'default' => '',
andros’s picture

Thx agentrickard. The notice is gone.

andros’s picture

Status: Active » Fixed
agentrickard’s picture

Status: Fixed » Closed (works as designed)

FYI. From settings.php code documentation:

 * To provide prefixes for specific tables, set 'prefix' as an array.
 * The array's keys are the table names and the values are the prefixes.
 * The 'default' element is mandatory and holds the prefix for any tables
 * not specified elsewhere in the array.