DI Suite 1.1 includes Sybase ETL, which provides extract, transform, and load (ETL) capabilities to consolidate data or copies of data from multiple heterogeneous data sources into one or more data targets.
The ETL component:
Enables extraction of data from heterogeneous data sources such as flat files, XML documents, Microsoft Excel, and heterogeneous databases such as Oracle, MS SQL, DB2, Sybase ASE, Sybase IQ, and MS Access.
Supports a variety of transformation capabilities and enables you to convert, cleanse, merge, and split data streams, which you can then insert, update, or delete data in a data target. Data transformation capabilities are provided through customizable transformation components and extended JavaScript functions.
Loads data to target databases or warehouses through native and ODBC connections. In addition, bulk loading capabilities are provided for enhanced performance.
Provides a scalable grid architecture that enables parallel transformation processing across operating system boundaries and machines.
Sybase ETL includes these components:
ETL Server – a scalable and distributed grid engine, which connects to data sources, and extracts and loads data to data targets using transformation flows designed using ETL Development.
ETL Development – graphical user interface (GUI) tools 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.
For more information about ETL, see:
Sybase Data Integration Suite 1.1 Overview Guide – introduces DI Suite and provides information on how to use the various components for your data integration needs.
Sybase Data Integration Suite 1.1 Installation Guide – provides instructions to install the ETL component.
Sybase ETL product manuals on the SyBooks™ CD – explains how to use the Sybase ETL subcomponents for your ETL projects.
