The Business Intelligence Blog

From InfoWeek’s blogpost by John Foley -

Open source software company SnapLogic has introduced a version of its data integration framework that’s tuned for Amazon (NSDQ: AMZN).com’s Elastic Compute Cloud, or EC2, Web service. It gives developers and IT departments the option of doing their data integration work in Amazon’s cloud rather than on their own servers.

Two-year-old SnapLogic’s framework consists of a design tool, metadata repository, server, and connector modules for Apache, Oracle (NSDQ: ORCL), Salesforce (NYSE: CRM), and other data sources. In May, the company released SnapLogic 2.0 as a VMware appliance. The framework is available free under the General Public License (v2) or via two subscription license options with various levels of support. InformationWeek profiled SnapLogic as our Startup Of The Week on May 31.

Pay-as-you-go in the Data Warehousing and Business Intelligence space is getting some more traction as Vertica moves its technology to Amzon’s Elastic Compute Cloud infrastructure computing infra-structure.

Vertica’s database organizes data by columns, as opposed to rows. The company and others that make columnar databases, such as Sybase and ParAccel, contend the approach is faster and better for BI-related queries because only the desired columns — such as a customer’s name or location — can be read without having to parse through an entire table, saving bandwidth.

The company also sells the database for on-premises use and in appliance form.

It sees a market for the on-demand offering due to a number of scenarios. For example, a company might want to conduct a BI project that will only last a fixed period of time, such as revising its pricing based on competitive and market data, said Andy Ellicott, senior director of marketing.

Hedge funds, which test their trading algorithms against large sets of historical stock market data, are another potential use case, because while such entities manage vast amounts of money, they seek to maintain the lowest possible overhead, which a cloud-based approach can provide, he said.