Extract, Transform & Load

Behind the scenes in computer ‘engine rooms', businesses' functions become electronic processes. A frequent need is to move selected electronically-held data from one place to another, making changes to it at some point along the way. The industry has long-used a loose description for this process: ‘extract, transform and load' - or ETL for short. ETL has a low profile, but your organisation like everyone else's will be using it. Whenever information (data) is taken from one file or database into another and a change in format (transformation) takes place, that is ETL. For instance, ETL is employed when merging disparate databases or loading a data warehouse from another source. Yet there are no ETL ‘standards' at present while new technologies such as service-oriented architecture (SOA) and enterprise service buses (ESBs) have propelled ETL to new levels of complexity. So pressure keeps mounting on those faced with ETL tasks trying to figure out how best to achieve the business needs.

Nor does that paint the whole ETL picture. Once achieved as a sequential task (‘batch run'), ETL now frequently updates data in real-time, thanks to a combination of new data legislation and other business imperatives demanding higher levels of data accuracy at all times. Each personal details change to a contact database may also immediately update a data warehouse being used in real-time, the information format having been ‘transformed' on the way. This complexity and variety of needs is forcing business who could once get away with writing their own one-off ETL programs to investigate the multi-function ETL software market - only to discover ETL software ranging from under $100 to over $1m with many (but never all) the bells and whistles. Almost all products offer an important unique feature with some addressing a specific industry's need. If you are tasked with finding the right ETL software, a barrier to selecting the best match for the organisation's short- and long-term ETL needs is not even being able to see the wood for the trees. Yet it is a business imperative to do so.

Clearly, the time is ripe for an informed update on the fast-changing ETL market, which is precisely what Philip Howard, Bloor's Research Director for Technology, has set out to do in his new report.

In Extract, Transform & Load Philip provides a brief history and ‘state-of-the nation' for ETL, explaining how we reached where we are today. His update on the burgeoning and ever more competitive ETL marketplace will guide you through the complexities and possibilities of ETL. On the way he reviews over 40 different software products, showing which fits best in what circumstances. With this as your reference, you will have the tools you need to understand the ETL state of play and to narrow down your search for the ETL software most likely to suit to your organisation's unique needs - and budget.

Marketing Automation

"Half my advertising is wasted, I just don't know which half" so said department store innovator and marketing pioneer John Wanamaker nearly a century ago.  Now in the 21st Century business application vendors are turning their attention to the Marketing Department and attempting to provide automation and metrics to the $600Billion that Global 2000 companies will spend.

Marketing Automation isn't new, CRM systems have provided basic campaign management for some time in addition to customer database management.  Newer and more specialised systems attempt to provide more detailed campaign process management and measurement.

For the IT manager this may mean another prime line of business application being installed and the report shows what systems are available and which vendors are providing them.  The report can help you advise your marketing department of what the choices are.

For the marketer the report shows what areas of marketing are covered, from target selection, through campaign definition, media selection and response measurement.  With marketing budget forever under scrutiny and always the first to get cut this report may show you how you can justify your most effective methods and maximise your cost and return per lead.

MAFocus – new vertical industry intelligence service

Bloor MAFocus - new vertical industry intelligence service Market Access Focus - MAFocus - has been designed by Bloor to provide key vertical industry understanding to IT and services vendors about what is driving their technology needs and ...

Master Data Management

The age of Master Data management has arrived. So says Harriet Fryman in the introduction to her report which you can download here. In fact Master Data Management by other names has been a hot topic for business managers for some years. ...

Bloor Accessibility Practice

People with disabilities want to be independent; they want to do things for themselves by themselves. This is a fundamental issue of human dignity, which is enshrined and enacted in good corporate responsibility and legislation and also enabled ...

New Approach – New Information

  • February 2, 2006
  • News
Bloor has been undergoing a quiet revolution. We've looked hard at what we've been offering and listened long to your comments. As a result we have a number of structural changes and additions which we're going to be making this year in our cov...
Load More