Opening New Doors
Last month Microsoft wrapped up its acquisition of Aliso Viejo, Calif.-based DatAllegro for an undisclosed sum. While Microsoft's SQL Server database is already used by some customers as the foundation for data warehouse systems and smaller "data marts," Microsoft executives said the DatAllegro acquisition, announced in late July, would elevate Microsoft's standing in the data warehouse market.
"This acquisition extends Microsoft's leadership in business intelligence and data warehousing and provides a great opportunity to accelerate our data warehouse road map and leapfrog key competitors," said Fausto Ibarra, Microsoft director of product management for SQL Server, in an e-mail interview.
For Microsoft solution providers, the DatAllegro acquisition at the very least means a higher profile for Microsoft in the data warehousing market against competitors IBM Corp. and Oracle Corp., said Scott Stein, chief operating officer of Solver Inc., a Microsoft Gold partner in Los Angeles that develops performance management solutions using SQL Server, PerformancePoint Server and other Microsoft products.
"We focus on the enterprise space," Stein said. "The big win for us is the perception in the marketplace that Microsoft can now play in the multiterabyte data warehouse market."
Most data warehouses today are large, complex systems, often built by big companies for storing and analyzing terabytes—even petabytes—of data. At their core, most data warehouses use database software, data management tools and other technology from a handful of vendors including IBM, Oracle and Teradata Corp.
But a hot market is developing around data warehouse appliances—preassembled packages of hardware, software and data storage developed by such companies as Dataupia Corp., Cambridge, Mass., DatAllegro and Netezza Corp., Marlborough, Mass. (Last month Teradata, Miamisburg, Ohio, announced the second generation of its own data warehouse appliance.) These "data warehouses in a box," with their lower price tags and faster implementation times, appeal as much to midsize companies as they do to large corporations.
Given the growing popularity of data warehouse appliances, Sandeep Walia wasn't surprised that Microsoft went out and acquired one. What did surprise Walia, CEO of Cerritos, Calif.-based Ignify Inc., a Microsoft Gold partner, was that Microsoft chose a relatively low-profile vendor with a relatively high-end system. "DatAllegro is very much an enterprise product [and] it has almost no name recognition in the business intelligence market."
"We chose DatAllegro because we believe in the technology and feel it is a perfect match with the data warehousing and scalability investments Microsoft has already made in SQL Server," Ibarra said in his e-mail.
The DatAllegro technology "allows SQL Server data warehouses to grow from less than 5 gigabytes to hundreds of terabytes," Microsoft said in a FAQ posted on its Web site when the acquisition was announced.
The DatAllegro appliance is currently based on the Ingres open-source database, incorporates a massively parallel processing architecture and runs on a range of hardware including Dell and Bull servers and EMC data storage systems.
Microsoft has yet to provide a detailed road map for its DatAllegro plans. More information was expected to come out at the Microsoft Business Intelligence Conference at the company's Redmond, Wash., headquarters. But company executives have made it clear Microsoft intends to move the DatAllegro technology to the Windows Server and SQL Server platforms. In the statement announcing the completed acquisition, Microsoft said it would assemble a solution based on the DatAllegro technology that would push SQL Server "to scale into hundreds of terabytes of data."
The statement also offered a hint of a timetable for the new system, saying Microsoft expects to provide partners and customers with community technology previews of the data warehouse appliance within the next 12 months. Full product availability is slated for the first half of calendar 2010.
Next: Data Warehouse Of Excellence Microsoft also will retain most of the DatAllegro team in Aliso Viejo as a data warehouse "center of excellence."
Less clear is whether Microsoft will sell data warehouse appliances with bundled hardware and software components, as does Netezza, or develop a software-only package and leave the hardware to its partners.
"We would develop solutions on top of the platform," Solver's Stein said of the DatAllegro technology. Solver, which works with SQL Server and PerformancePoint, assembles systems for complex financial planning, analysis and performance management tasks. That requires pulling together operational and historical data from multiple financial, sales and supply chain systems. Stein said the DatAllegro acquisition should expand Solver's opportunities in that realm.
Ignify works with Microsoft's Dynamics ERP and CRM applications, SharePoint Server and PerformancePoint Server to build e-commerce and data archiving systems. The DatAllegro acquisition "offers us, as a company, the opportunity to get into enterprise business intelligence," Walia said.
While the Ignify CEO said he hasn't thoroughly analyzed how his company could work with DATAllegro, he said Ignify might use the technology to help feed data from Dynamics applications into data archiving systems.
Said Nigel Geary, founder and CEO of PrecisionPoint Software Corp., a Microsoft Gold ISV partner in Waltham, Mass.: "We have been discussing with Dell and HP the idea of providing an 'appliance' bundle of PrecisionPoint Business Warehouse, SQL Server and a preconfigured standard hardware server tuned for data warehouse processing." PrecisionPoint bundles SQL Server with its Business Warehouse solution for automating the building and maintaining of a data warehouse system.
"We are also planning to provide our product as a SaaS offering," Geary said in an e-mail. "With Microsoft offering DatAllegro/SQL Server, we can scale up our Business Warehouse solution to much bigger applications, such as the retail and hospitality sectors, who are big users of Microsoft Dynamics."
While at first glance Microsoft's DatAllegro acquisition would appear to put the software giant in competition with partners such as PrecisionPoint, Geary said that's not the case. Business Warehouse, he said, is "complementary" to the SQL Server/DatAllegro system. "In fact, this move would allow PrecisionPoint to compete with proprietary data warehouse hardware vendors like Netezza and bring our solution to the more lucrative enterprise market."
DatAllegro's technology will be especially useful for retailers that handle high-transaction volumes and need to do near-realtime data analysis, said Lee Blackstone, president and CEO of Alpharetta, Ga.-based Blackstone and Cullen Inc., a Microsoft channel partner and database specialist. "This is a positive move, and one that will allow us to compete more on the level with competitors such as Teradata," said Blackstone.
"The last frontier is the very large scale [data warehouse], and whoever gets there with a product first will succeed," said George Brown, CEO of Database Solutions Inc., a Cherry Hill, N.J.-based systems integrator and Microsoft partner.