User`s guide

User’s Guide 1
CHAPTER 1
Sybase IQ ETL
Sybase IQ ETL architecture
When you install Sybase IQ ETL on Windows, you install Sybase IQ ETL
Development and Sybase ETL Server. You can add multiple ETL Servers
on different operating systems to your installation.
Sybase IQ ETL Development
Sybase IQ ETL Development is divided into two major components:
• Sybase IQ ETL Development desktop — provides the graphical user
interface. Use the desktop to create and design data transformation
projects.
• Sybase IQ ETL Development engine — controls the actual
processing, such as connecting to databases and executing
procedures.
Topic Page
Sybase IQ ETL architecture 1
Projects and jobs 2
Component concepts 2
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