User`s guide

Contents
User’s Guide iii
About This Book........................................................................................................................... ix
CHAPTER 1 Sybase IQ ETL................................................................................. 1
Sybase IQ ETL architecture ............................................................. 1
Sybase IQ ETL Development.................................................... 1
Sybase ETL Server ................................................................... 2
Projects and jobs.............................................................................. 2
Component concepts ....................................................................... 2
Stepping a component record-by-record................................... 2
Component variables and ports ................................................ 3
Adaptable port structure and mapping ...................................... 3
Running a project ...................................................................... 3
Customizing a project....................................................................... 3
Understanding repositories .............................................................. 4
Converting datatypes and data formats ........................................... 5
SQL .................................................................................................. 5
Tools ................................................................................................ 6
Unicode support ............................................................................... 6
Expressions...................................................................................... 6
Internal database ............................................................................. 6
CHAPTER 2 Sybase IQ ETL Development Desktop .......................................... 9
Desktop layout ................................................................................. 9
Using the Navigator........................................................................ 10
Administering the repository.................................................... 11
Navigating and browsing the repositories ............................... 12
Administering projects and jobs .............................................. 12
Administering user accounts ................................................... 13
Using the Properties section .......................................................... 14
Applying component variables ................................................ 14
Using the Design section ............................................................... 15
Adding components................................................................. 16
Deleting components from the Design section........................ 16