In-Memory BI Upgrades Point to Mainstream User AdoptionIn-Memory BI Upgrades Point to Mainstream User Adoption

New integrations, new scalability options and new data visualization options promise to bring TIBCO Spotfire 3.0 to a broader base of potential business intelligence consumers. Announced and released May 18, the 3.0 launch marks the latest in a series of major upgrades since Spotfire's acquisition by TIBCO nearly two years ago. And like last week's SAP BusinessObjects Explorer release, the upgrade represents the maturation of a once-nichey in-memory product into a mainstream BI offering.

In contrast to conventional BI tools, which query data on disk, in-memory products load data into random access memory (RAM) so users can quickly query and interact with information without extensive IT performance tuning and data preparation. Spotfire was introduced in the late 1990s as a visual data exploration tool used almost entirely by pharmaceutical and life sciences researchers. As has been the case for other in-memory products, Spotfire's power and breadth of appeal have increased with the advent of multi-core, multi-threaded and 64-bit server technologies. Since its acquisition by TIBCO in May 2007, Spotfire has been enhanced with operational and predictive analytics, real-time data integrations and data mining capabilities.

The TIBCO Spotfire 3.0 upgrades announced today include prebuilt data integrations to SAP BW, SAP R/3, Salesforce.com, Siebel eBusiness Applications and Oracle E-Business Suite, in addition to a new Web services integration option. These connectors not only make it easier to integrate popular data sources, they also open up new data access and analysis options.

"Until recently we've been limited to accessing data from relational data sources and file-based locations," admits TIBCO Spotfire product marketing manager Tim Wormus. "With 3.0 we're expanding to full enterprise connectivity, and you can also model the data so you can connect multiple sources to build a federated data warehouse or analytics layer." With Spotfire's caching support, Wormus says you can pull data from production systems and let users query against the caching layer rather than mission-critical production systems.

Designed to support larger, enterprisewide deployments, the scalability features in the 3.0 release include load balancing and failover support as well as new deployment management and administrative controls. The Web-based configuration controls ease remote administration while the deployment management features simplify migration from development, test and production servers.

New analytics and visualizations introduced in TIBCO Spotfire 3.0 include treemaps, new scatterplots and error bars within bar and line charts that let you see the data behind the visualization. An added visualization toolkit is said to make it easier to build custom visualizations. "This extends our lead in our core competency of visually interactive, real-time analytics," Wormus says.

The TIBCO Spotfire 3.0 release comes less than a week after SAP announced SAP BusinessObjects Explorer, a new product that blends the Internet-search-like Polestar query interface with the in-memory analysis capabilities of SAP's Business Warehouse Accelerator (BWA) appliance. Introduced in 2006 as the Business Intelligence Accelerator, the BWA appliance is another in-memory product headed for mainstream use. The accelerated version of Explorer introduced last week is limited to accessing data in SAP BW, but a "second-wave" upgrade set to be introduced late this year or early next year is expected to access myriad data sources.

QlikTech QlikView and IBM Cognos TM1 (formerly Applix TM1) are two other venerable in-memory products. Several leading BI vendors have either recently added (MicroStrategy) or plan to add (Microsoft) in-memory analysis capabilities. Leading in-memory products and benefits were recently covered in "Insight at the Speed of Thought: Taking Advantage of In-Memory Analytics," an in-depth report available as a free download (registration required) at the Intelligent Enterprise "Next-Era BI Tech Center."