I have a customer who has a DW implemented on Oracle and Oracle Express. I'm on the lookout for a tool that would mine/query the warehouse for predefined exceptions and push/notify the data/exception to the decision-makers as opposed to having the decision makers performing the querying/mining of the data for exceptions. Could you please suggest a methodology/tools for the above-mentioned requirement?


Les Barbusinski’s Answer: You’re asking about alerts. An alert notifies a subscribing user (via e-mail, a wireless device or a Web site) that a specific metric has exceeded a predefined threshold value. In your environment, you have two options: 1) use Oracle Express Objects to develop one or more agents that generate alerts, or 2) purchase a relational BI tool (such as Brio’s Portal, Microstrategy’s Narrowcaster, Business Objects’ Broadcast Agent or Informatica’s Analytics Server) to generate alerts directly from your Oracle database (i.e., bypassing Oracle Express entirely). Option 1 requires a significant development effort, but is relatively inexpensive (if you already have Oracle Express in house). Conversely, Option 2 is much easier to implement, but much more expensive.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access