Sybase ETL extracts data from multiple heterogeneous data sources and loads it into one or more data targets using a comprehensive set of transformation functions.
Sybase ETL capabilities include:
Data extraction – provides the ability to extract data from a variety of data sources, such as Sybase ASE, Sybase IQ, Microsoft Access, Oracle, DB2, Microsoft SQL Server, flat files, XML files, and ODBC data sources.
Data transformation – provides the ability to convert, cleanse, merge, and split data streams, which you can then insert, update, or delete data in a data target.
Data loading – provides the ability to load data into a target database via update, insert or delete statements, or in bulk.
You can use the following ETL subcomponents to extract, transform, and load data:
Sybase ETL Server – provides a scalable and distributed grid engine that connects to data sources and extracts and loads data to data targets using transformation flows designed using ETL Development.
Sybase ETL Development – provides a GUI tool for ETL development and deployment for use with ETL Server. These tools provide a complete simulation and debugging environment to speed the development of ETL transformation flows.
ETL Development is available only on Windows, on a separate media.
On the machine where you have installed ETL Server, make sure the database connectivity libraries are available for the source database you are extracting the data from, and the target database where you are loading the data.
Figure 8-5 shows an example architecture, in which data is extracted from heterogeneous data sources, transformed using the Sybase ETL Server, and loaded into a data warehouse.
Figure 8-5: Sybase ETL deployment architecture
