Sybase ETL

本记录摘自《Sybase ETL User Guide》

 

1、Sybase ETL的作用

Sybase ETL lets you extract data from multiple heterogeneous data sources and load it into one or more data targets using a comprehensive set of transformation functions.

Sybase ETL可以完成一般ETL可以完成的任务，即抽取、转换、装载。

• Data extraction – extract data from various data sources.

• Data transformation – convert, clean, merge, and split data streams.

• Data loading – load data into a target database using update, insert, delete, or bulk copy statements.

 

 

2、Sybase ETL的组件（component）

 Sybase ETL components are used to create projects and jobs.

Project components include:

• Source components – deliver data for a transformation stream. A project typically starts with one or more source components. Source components have no IN-ports and at least one OUT-port.

• Transformation components, Lookup components, and Staging components – apply specific transformations to the data in the transformation stream. These types of components have both IN-ports and OUT-ports.

• Destination components (also called data sinks) – write data to specific targets. destination component have one IN-port and no OUT-ports.

• Loader components – extract and load data from a source database or file into the IQ database, without performing any transformation.

 

各个组件的详细功能和用法参见手册《Sybase ETL User Guide》，【下载地址】。