Once you have defined all your fields to extract you can configure the database to update.
Click the Update Databases tab.
Check the Update A Database if you want Email2DB to execute a SQL Insert or Update statements against the database of your choice. The tables and field names used in the SQL statements are specified on the 'Insert Into Database Field' tab on each individual field.
You must specify a Connection String that Email2DB will use to open the data source. Click the Build button to build the connection string using any of the data source providers that are installed on your PC. Click the Test button to verify that Email2DB can login to the data source.
Select the SQL Dialect from the drop down box depending on your database type. If the database is not listed select 'Generic'.
Normally the SQL statements are maintained automatically by Email2DB as you define each field. You can override this and maintain the SQL yourself. Check the Use Modified SQL Statement to do this. You can then use @fieldname specifiers in the SQL statement.
The UPDATE and SELECT statements will only be created if you have defined one or more of your fields as 'Key Fields'. Email2DB will then first check if a record exists with the key field values by issuing a SELECT * From... statement. It will then issue the Update statement if a record is found or the INSERT statement otherwise.
Note: Don't use the Modified SQL Statement option unless you have to. It is much better to let Email2DB maintain the SQL for you, since Email2DB can then add or update records in the database directly.
This option will be available if you are using SQL Server for the Email2DB Message Store. See: Configuring The Email2DB Message Store Database.
When this option is selected, Email2DB will use its own database. Tables will be created automatically. Fields will be created for each Email2DB field you have created.