What is the Boomerang Notification Framework
Boomerang is a collection of notification services for creating applications that generate and send, as well as receiving notifications. Using the Boomerang notification framework, you can quickly create applications to generate and send notifications to customers, suppliers, partners and employees.
Boomerang’s pre-built notification services range from basic IT infrastructure like email (SMTP) and printers to cloud services like Twitter and FaxLogic.
Also included in the Boomerang platform is a simple way to managing solutions and to monitoring activities.
Why Use Boomerang – The Need for Speed
- Get more results for less effort
- Prebuilt Component for both traditional IT infrastructure and cloud services
- Easy and Fast Development
- Consistent and fast SQL user (application) interface
- High Reliability
- Simple yet flexible and Powerful
How Does Boomerang Work?
Boomerang is a bolt-on solution for MS-SQL Server. The application interface of Boomerang is entirely based on SQL Server (MS) meaning that each notification service has a corresponding table object that represents the service in question. For example to send and email out you would insert a record into the OUT_EMAIL table. To send a fax you would insert a record into the OUT_FAX table.
For outbound or outgoing notifications the following steps are involved but varies slightly depending on which notification service that is being used:
- New Event (EVENT_MASTER)
- Select type of Job (OUT_EMAIL, OUT_FAX, OUT_PRINT, OUT_FILE, OUT_TWIT)
- Select Recipients
- Select Additional Content to be Delivered (SQL Services Reporting Services report, File, Stream) – Optional
- Release Event (EVENT_MASTER), Distribution
After completion of the notification process event handlers like after email job (sp_After_Email_Job) are automatically called. These event handlers can used to continue processing the notification event and/or start a new outbound notification. See this page for a complete list of event handlers and event helpers.
Currently these outbound services (Jobs) are included:
- Email Out
- File Out
- Print Out
- Fax Out
- Twitter Out
Inbound or incoming or notifications does not by it self require any application since it is an integrated part of the Boomerang Notification Framework. As with all notification services in Boomerang, inbound notifications are handled in SQL as table and stored procedure objects.
The following self-acting steps are involved:
- New Incoming Notification
- Job Parsed (IN_EMAIL, IN_EMAIL_ATTACHMENTS, IN_EMAIL_RECIPIENTS, IN_FILE, IN_TWITT)
- Event Handler (sp_On_Email_In, sp_On_File_In, sp_On_Twit_In)
The available event handlers like On Email In (sp_On_Email_In) can be used process the incoming notification and/or start a new outbound notification. See this page for a complete list of event handlers and event helpers.
Currently these inbound notification services are included:
- Email In
- File In
- Twitter In (Message Stream)
To support outbound and inbound notifications a number of communication connectors may be connected to Boomerang.
The following communication connectors are included in the Boomerang Notification Framework for inbound and outbound notifications.
- SMTP – In/Out
- Twitter - In/Out
- FaxLogic – Out
- RightFax – Out
- MS-Fax – Out
- Dropbox – Out
- SQL Server Reporting Services – N/A
Microsoft Management Console
Boomerang Notification Framework ship with Microsoft Management Console snap-in. You can use the administration console to configure important service parameters, as well as Boomerang database. You may also manage Boomerang printers and all communication connectors.
Boomerang Notification Services Web Portal
Boomerang Notification Services Web Portal (BNSWP) ships separately to Boomerang Notification Framework and is not needed for any functionality in Boomerang. BNSWP is an open source web based front end that is used for easy management of deployed notification solutions.
Boomerang Notification Services Web Portal provides the following benefits and features:
- Convienent Overview
- Event Tracking
- Solution Documentation
- Administrator Alarms (Errors)
- Modification and re-submit of outbound notifications
Application Scenarios for Boomerang Notification Framework
- A brokerage firm sends stock and fund prices based on customer-defined criteria. The notification contains a link that enables the customer to buy or sell shares.
- A a company sends low-balance and payment due notifications to the customers preferred device, such as email, fax and mail.
- An airline sends information about flight arrivals and delayed departures.
- A real estate agent sends listings that match a client’s criteria for a new home.
Line of Business Applications
- In technical support group all new incoming support tickets (emails) are automatically received logged and responded to with a link to the ticket id and current progress.
- Changes on a corporate website are posted to the company’s twitter account as they are being made.
- Your customer relations management (CRM) system, responding to a customer requiring immediate attention, sends a customer request to the account manager.
- A customer requires that your invoice is sent electronically according to a specific XML standard. When a new invoice is created it is automatically sent to the customers designated email inbox.
- One of your suppliers request that forecast changes to be communicated in a EDI format. Twice a day a EDI file containing forecast changes is compiled and saved to a shared Dropbox account.
- When a new order is received a pick list is printed, order confirmation faxed and a new order notification emailed simultaneously to the stock picker, customer and account manager respectively
Business Intelligence Applications
- Mentions of your brand on Twitter are gathered and stored into a data warehouse for further analysis
- Your partner network submit their sales forecast using your excel template. The email is received, parsed and imported to the partner forecast table in the data warehouse.
- Critical customer satisfaction KPI’s are being contiguously monitored. If any KPI drops below established level a SSRS report detailing the issue is sent to relevant people in the organization.
- When sales in a region is below budget a sales overview report is sent to the regional manager.
- All changes to an employees file is communicated to the employee in question for transparency and accuracy. By replying to the email the employee may update current address.
- You are working on a new product and need to keep informed of product-related research. When a new report is available from the corporate library, you receive an e-mail that contains a link to the report.