Webform External

Description

Please note: This project i no longer being maintained. I no longer work with Drupal, so this project won't be updated any longer. If anyone wants to fork it and take over, please feel free. If you do, email me and I'll link this project to yours.

The Webform External module allows users of webform to store the data for specific webforms in an external datasource that is defined in the settings.php file. This was created in response to forms that contained data protected by HIPAA regulations, which requires that HIPAA-defined data be stored separately from other data and be closely monitored.

Requirements

Webform 7.x-3.x

Installation

Install the module as you would any other.

Configuration

Adds an additional menu item when creating new or editing existing Webform
nodes called External DB. Select desired datasource to store webform data
from a dropdown list. List is generated from available datasources in the
settings.php file.

Database configuration should be created as such:

$databases = array (
'default' =>
array (
'default' =>
array (
'database' => 'main_datasource',
'username' => 'drupal',
'password' => 'foo',
'host' => 'localhost',
'port' => '',
'driver' => 'mysql',
'prefix' => '',
),
),
'external_datasource' =>
array(
'default' =>
array (
'database' => 'external_datasource',
'username' => 'drupal',
'password' => 'bar',
'host' => 'localhost',
'port' => '',
'driver' => 'mysql',
'prefix' => '',
),
),
'external_datasource_2' =>
array(
'default' =>
array (
'database' => 'external_datasource_2',
'username' => 'drupal',
'password' => 'bar',
'host' => 'localhost',
'port' => '',
'driver' => 'mysql',
'prefix' => '',
),
),
);

Each additional datasource should be defined as a root level index of the $databases array.

When an external datasource is specified and the config is saved, the module
checks that datasource for the webform_submitted_data table. If the table does
not exist, the module will create it for you.