You are here: silicon.com > Resources > White Papers > Data Management > Data Tools > Data Acquisition - ETL

Data Acquisition - ETL White Papers

A Flexible Data Integration Architecture Using WebSphere DataStage and WebSphere Federation Server: Introducing the T-ETL Architecture

Tags:
data acquisition - etl

Overview WebSphere DataStage is an inherently flexible data consolidation tool that can natively support ETL, ELT, and TEL topologies. This paper shows how the combination of WebSphere DataStage and WebSphere Federation Server can extend the alphabet soup by effectively supporting Transform-Extract-Transform-Load (T-ETL) data consolidation topologies. Within a T-ETL topology, WebSphere DataStage and WebSphere Federation Server complement each other in such a manner that significant performance benefits and CPU savings can be achieved relative to using WebSphere DataStage alone. In this scenario, WebSphere Federation Server is able to perform processing close to the input sources so that less data is presented to the extraction stage, and less transformation needs to be done by WebSphere DataStage.

Further White Paper Details
Publisher	IBM	File Format	HTML
Date Published	March 2007
Format	White Papers
Topics	Voice - Data Integration, Data Acquisition - ETL

Did you find this white paper useful? 1 out of 4 users found this white paper useful

The Bloor Perspective: the Red Hat rumours, Informix's passion for Ardent, and XML stumbles towards standardisation

Best known of these is the DataStage ETL (Extract Transform Load) product used to build and maintain data-warehouse contents from a wide variety of transactional data sources. The market seems to like the idea of Red Hat acquiring Corel - even if...

Channel:
Comment & Analysis

Start-up of the month: Aleri - from classical music to banking analytics

AIB said time savings on its monthly consolidation reports that used to take 12 hours to process are proof the software works. The team managed that feat and is now a healthy 150 members strong, all from starting up on a $17m mixture of Hambrook's...

Channel:
Comment & Analysis

Analysis: E-procurement back on the agenda

Beth Barling, analyst at AMR Research said that huge savings can be achieved purely by simplifying processes and consolidating suppliers, but the software makes it easier and allows firms to identify other opportunities for savings and improvement.

Channel:
IT Director

Building the business case for collaboration

While ROI can be achieved from project-based collaboration solutions, says Mike Davis from the Butler Group, long term success is achieved by embedding collaborative capabilities into the organisation.

IBM/ITNet gets the nod for £100m Bradford IT deal

It is claiming best value has not been demonstrated and that projected savings will not be achieved. The Bradford-i project is designed to transform how we deliver customer service and to increase efficiency through a combination of investment in...

Channel:
Law & Policy

Go real-time with your data

Sunopsis, recently acquired by Oracle, uses the E-LT (extract - load and transform) approach, which does not require an ETL server. This process is commonly referred to as extraction, transformation and load (ETL), and can take anywhere from a few...

Telecom 2.0: Mind over matter

ntl:Telewest Business believes that the role of the telco is evolving. Gone are the days when it was enough to simply focus on circuits and minutes, customers now need a far higher degree of interaction and look for suppliers who will talk business solutions with them.

Publisher:
ntl:Telewest Business

IBM Information Server Change Data Capture

In today's fast-paced world, access to real-time data has never been more important. To be successful, organizations need to be able to report and analyze corporate data quickly and easily, regardless of what applications created the data, what platform they're running on, or what database they're stored in.

Publisher:
IBM

An examination of server consolidation: the trends that can drive efficiencies and help businesses gain a competitive edge

This white paper provides a starting point for organizations contemplating server consolidation. It includes an overview of server consolidation concepts and techniques and provides guidance on methodologies. It also looks at the potential cost savings associated with server consolidation and offers information on how organizations can sustain the advantage they have gained by consolidating their servers.

Publisher:
IBM

Also on silicon.com

Site Navigation:

Data Acquisition - ETL White Papers

A Flexible Data Integration Architecture Using WebSphere DataStage and WebSphere Federation Server: Introducing the T-ETL Architecture

Quick Sitemap Links:

About Us

Search

Blogs

Verticals

Advertising Features

CNET Networks in Europe

CNET Networks in the United States

CNET Networks in Asia Pacific