Provides a robust messaging gateway that allows internal and external
database applications to easily create and send various messages including e-mails,
e-faxes, network popup messages, page and cell phone messages. Any application that can
execute a SQL statement can use DB Mail for sending all those messages.
Uses only standard database communication network protocols, which allow
it to support any Oracle, DB2, Sybase and Microsoft SQL Server database systems running on
Supports asynchronous message processing, which allows database
applications to write messages to a message queue and be immediately freed to serve other
user requests. Applications that use asynchronous operations (where more than a single
operation can execute simultaneously) often have better availability, reliability,
scalability, and usability than applications using only synchronous operations (where
operations execute sequentially).
Ensures quick return on investment and low cost of ownership. Utilizes
widely available common hardware and software components that are inexpensive and
affordable for businesses of all sizes.
Supports efficient scaling out methods for time-consuming fax and voice
message processing types. These methods allow increasing the capacity of an infrastructure
tier to handle load by adding additional servers, increasing the aggregate capacity of the
Supports both regular messages and messages with attachments. Up to 255
files or database blobs can be attached to a single message. Also supports messages with
different content types including but not limited to plain text, HTML, XML.
Provides unified messaging interface for different database systems thus
allowing developers to create true cross-platform applications utilizing identical
Features centralized graphical interface that shortens system setup and
tuning curve and is easy to use.
Provides robust error handling options including options for self-tuning
Provides complete message processing audit trail that keeps track of
messages being sent, in case troubleshooting needs to occur.
Full compatibility with all host Operation Systems on which the
supported Database Management Systems can run, including but not limited to Windows NT,
UNIX, Linux, VMS, OS/390, z/OS.
To get an idea of what DB Mail can do for you, take a look at the
following single SQL statement that can send many thousands emails in plain/text or
text/html format with an image attachment using just one SQL SELECT statement
(customer_email, 'New great product in our store',
'We are happy to offer the product that you have asked for. For
details please see the attached picture.',
'firstname.lastname@example.org', 1, 'text/html', attach_file (NULL, 1, 'product.gif', 'IMAGES') )
WHERE customer_email IS NOT NULL
Similarly you can use DB Mail to send faxes, make phone calls and send
pre-recorded and dynamically synthesized voice messages, send SMS messages, send
interruptible network popup messages and a lot more.