Talend: Data integration for the masses!

There's no question about it: Business intelligence is the holy grail of most CIOs and IT managers alike. After all, the idea behind BI is great: Pull data from all the nooks and crannies on your enterprise network into one system where it can be cleansed, correlated, and presented to executives for analysis via easy-to-use dashboards.

But, as this publication has reported on more than one occasion, the reality of BI for most enterprises is far murkier, with massive investments in technology for data warehousing, data integration, and analytics, but payoffs that are sparse or hard to calculate. What's needed, experts agree, are better tools for integrating data from legacy systems and disparate data stores.

Traditionally, though, that kind of technology has been the purview of the companies that own the data to begin with: Oracle, IBM, and so on. Making use of it required six-figure licensing agreements and seven-figure consulting services contracts, limiting the advantages of data integration and BI solutions to just the wealthiest companies.

Talend, a two-year-old startup based in Paris, hopes to change all that by tapping into one of the hottest tech trends of the past 10 years: open source.

Talend's OpenStudio is an open source ETL (Extract, Transform, and Load) data integration tool. Three years in the making, OpenStudio was released in beta in the last quarter of 2006. Since then, the free software has been downloaded more than 60,000 times and Talend has signed up more than 1,000 developers to beta test its product, says Yves de Montcheuil, Talend's vice president of marketing.

OpenStudio was a labor of love for Talend CEO Bertrand Diard and co-founder Fabrice Bonan, who worked on the software in their spare time, while holding down senior positions at a large European systems integrator. Both witnessed firsthand the limitations of the systems integration market, de Montcheuil says.

"You had a big spaghetti dish of different systems with lots of data and constraints, such as regulations," de Montcheuil says. At the same time, users and executives were demanding more and faster access to data, but the leading vendors in the space -- companies such as IBM, Oracle, and Informatica -- offered only custom solutions at extremely high prices, with considerable overhead costs for IT.

The advantage of OpenStudio is that it relies on industry standards -- Java, Eclipse Framework, SQL, and Perl -- rather than proprietary engines and code, de Montcheuil says.

"You don't need to learn a new language to support data integration," de Montcheuil says.

Relying on standards also means companies can deploy the code they create on commodity hardware rather than expensive, proprietary hardware platforms, and deploy them throughout the enterprise at no additional cost. That's in stark contrast to technology from established BI vendors, which commonly require separate licenses for each instance of their technology.