Restricted access

January 5, 2010

Data Integration: Open Source to Become a Mainstream?

Filed under: Data Integration, Open Source — Tags: — Olga Belokurskaya @ 8:09 am

According to multiple predictions and publications, 2010 is going to become quite an interesting year for open source data integration.

Here, as you may remember, Gartner has proclaimed open source solutions “good enough” for data integration (extract, transform, and load, to be exact), and a bit later has mentioned (at last!) open source data integration and BI vendors in its Magic Quadrant, thus admitting that open source solutions can be mature enough to meet their functionality requirements.

Though sometimes there are still talks about the need to have skilled developers at hand, for the sake of support and maintenance, it seems that open source data integration tools move closer to becoming a mainstream, and not just a cheap alternative (with limited possibilities) to proprietary data integration solutions.

Proprietary BI and Data integration vendors seem to admit this fact, as, according to Gartner, some of them have introduced free “starter editions” of their solutions.

All this brings us hopes that times, when open source data integration tools were regarded just offerings for small and mid-sized businesses, are passing, and open source offerings will gain the right to be deployed in large enterprises alongside commercial proprietary BI solutions.

December 29, 2009

On Approaches to Data Integration with the Cloud

Filed under: Data Integration — Tags: , , — Olga Belokurskaya @ 2:25 am

The idea of cloud computing has become really popular; the increase of the cloud adoption in 2010 has been predicted by data integration experts. There’s no surprise, as cloud computing is positioned as a way of simplifying technology, so that wider audience could adopt it.

The need to synchronize data from applications that an enterprise has in the cloud with on-premise apps is bringing us to cloud integration (or data integration with the cloud).

Today there are different approaches to data integration with the cloud available, as well as different solutions to perform cloud integration. This variety is mostly comes out of the immaturity of the market, and, I suppose, with the development of the cloud, there will be defined right approaches to data integration. Among the most common approaches is customizing the same data integration tool that an enterprise uses to integrate in-house applications, so it could be used for the cloud applications, as well; moving a data integration tool to the cloud, which helps avoid expenses connected to hardware installation. One more way is on-demand data integration.

So, there is a variety of choices, and to make a decision on what approach to utilize for cloud data integration a company should understand their needs, as well as consider available budget and resources, etc.

November 18, 2009

Data Integration Vendors Called to Become More Visible

Filed under: Data Integration, ETL — Tags: — Olga Belokurskaya @ 8:50 am

What makes me turn to ETL topic again, is a very interesting piece by Rick Sherman, a business intelligence expert. Rick, actually, is pointing the fact, that today’s ETL market is limited by a small number of providers. But that’s not because there’s nobody apart from those companies, but because many data integration vendors are simply invisible to potential buyers.

I agree, I often read in the web complaints about large expensive data integration offerings, with wide functionality that a company looking for a data integration solution simply can’t afford. Moreover, very often such companies don’t need all that functionalities; their needs are not likely to go out of ETL boundaries. However, choose a data integration tool to answer their needs and budget is a challenge.

At the same time many vendors providing data integration and ETL tools which are something, as Rick says “between the mega-products and the bundled tools in terms of functionality and total cost of ownership,” are known to quite a small audience.

What’s the way out? Make some more effort and do not limit search by several best-known vendors. This is as for ETL buyers.  At the same time Rick called data integration vendors to come out of shadow and become more recognizable.