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.
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 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.
For more information about ETL, view the product manuals on the SyBooks CD for Sybase ETL. For more information about how you can use the ETL component for data integration, see “Example 5: Consolidating business data for trend analysis”.
