Iteration Software Inc. this week unveiled its debut product: reporting software that alerts users within seconds of when a significant business event occurs, such as a rash of US$1 million customer orders or inventory shortfalls. Iteration's Real-time Reporting Suite differs from traditional business intelligence software in that it gathers data from messaging systems that are relaying transactional information between applications. It doesn't rely on a data warehouse or batch reports, which make stored information available for later review. It also uses instant messaging, e-mail and Short Message Service technology. The company's goal is to make users aware of business problems or opportunities as they happen, speeding resolution.
Iteration's software gets its information by tapping into the messaging streams of enterprise application integration (EAI) middleware from vendors such as Tibco, Vitria and webMethods. As an event or transaction occurs in an enterprise system, such as a procurement or inventory application, the EAI middleware puts the information from that event into a message queue and makes it available to other applications - including Iteration Real-time Reporting Suite.
Iteration's software also taps into historical data stored in existing relational data sources, such as Microsoft SQL Server, Oracle and IBM DB2, and legacy data sources such as flat files. It then combines all the information and presents it to business users in various report formats.
The idea of merging real-time datastreams with historical information stored in relational databases is important, says David Folger, vice president at Meta Group. "Integrating the historical data and the real-time data with the same analytic applications is a key to making it work," he says.
Instead of storing the information it collects in a relational database, Real-time Reporting Suite pulls the source data into a persistent, memory-based cache that can process up to 11,000 records per second, the company says. New messages streamed into the data cache add to or update existing information. Monitoring features can detect changes in data, system events or transactions.
Reports delivered to a user's screen are updated automatically as the underlying data changes; the user doesn't have to send a new query or manually refresh the report to see the latest information, the company says. The software also lets reports be analyzed and annotated by multiple users collaboratively.
Iteration Real-time Reporting Suite costs $25,000. Typical enterprise deployments average up to $250,000.
Iteration is CEO Ken Gardner's fifth start-up. Before founding Iteration in February 2002, Gardner co-founded business intelligence software maker Sagent Technology in June 1995. His other company also includes database reporting tool-maker ReportSmith, which was purchased by Borland in 1994.
Iteration is a young, unproven company and it isn't alone in pursuing real-time reporting - every business intelligence software maker is interested in getting closer and closer to real-time data availability, Meta Group's Folger says. "Data warehouses used to be updated every month and every week, then every day and every hour. Now there's other tricks to update them even quicker," he says.
But so far, Iteration's tactic of using messaging streams for direct data access and instant messaging for alerts is unique. "Iteration takes a different approach to getting real-time data than the other business intelligence vendors typically have," Folger says. -- Network World (US)
Join the CIO New Zealand group on LinkedIn. The group is open to CIOs, IT Directors, COOs, CTOs and senior IT managers.