User`s guide

About This Book
User’s Guide xi
About This Book
Audience
This guide is for users of Sybase IQ ETL. Sybase IQ ETL provides extract,
transform, and load (ETL) capabilities that you can use to transform data from
data providers to data targets. Sybase IQ ETL supports a variety of
transformation capabilities and enables you to convert, cleanse, merge, and
split data streams. The resulting data stream can then insert, update, or delete
data in a given data target. You view the shape of your data at any step of the
data transformation process by using its unique “Step and See” technology.
How to use this
book
This book contains the following chapters:
• Chapter 1, “Sybase IQ ETL” gives you a brief overview of Sybase IQ
ETL, Sybase IQ ETL Development, Sybase IQ ETL Server, and the
feature set.
• Chapter 2, “Sybase IQ ETL Development Desktop” helps you become
familiar with the design environment for Sybase IQ ETL projects and jobs.
This chapter explains all menus, the sections of the Sybase IQ ETL
Development desktop, toolbars, and general GUI functionality.
• Chapter 3, “Getting Started” helps you get started with Sybase IQ ETL
Development.
• Chapter 4, “Projects and Jobs” guide you through the process of creating,
simulating, and executing projects and jobs. It also provides valuable
insights related to simulation mode. It also shows you how to use
templates to create projects and jobs for special purposes.
• Chapter 5, “Advanced Concepts and Tools” describes the set of built-in
tools that make your design work easier and faster. Familiarize yourself
with Sybase IQ ETL Development tools, such as Content Explorer or the
Query Designer, to speed up the design of your project work.
• Chapter 6, “Components” describes Sybase IQ ETL component concepts
and all the information relevant to every component.
• Appendix A, “Function Reference” describes the functional components
available in Sybase IQ ETL.
• Appendix B, “Sybase ETL Server” describes installation, usage, and
architecture of the Sybase IQ ETL application.