DB Mail 2.5

• 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 any platform.

• 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 entire system.

• 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 messaging functions.

• 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 and self-healing.

• 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

SELECT send_mail (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.',
     'sales@company.com', 1, 'text/html', attach_file (NULL, 1, 'product.gif', 'IMAGES') )
FROM customer
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.