Email2DB Actions - Update Database
Once you have defined all your fields to extract from the incoming message you can configure Email2DB to update
one or more database tables.
The
Build button is used to create a
Connection String to your database.
Email2DB can update any database type that resides on your system and provides
an ADO (OLE DB) or ODBC interface. All common database types are supported
including (but not limited to): SQL Server (all versions), MySQL, Oracle,
Pervasive, Access, File Maker, DB2, Interbase, PostgreSQL, SQLAnywhere.
Email2DB will automatically create the required SQL commands to update your
database using the fields you have extracted from your incoming message. When
you create an Email2DB extracted field you map it to a Table and Field name
within your database.
Email2DB can add new records to your database and also UPDATE existing records
using fields that you define as 'key' fields.
You can also choose to modify the SQL statements that Email2DB creates. This is
useful if you want to execute custom SQL or run stored procedures.
Database Update