User`s guide

Contents

Sybase IQ ETL 4.1

Using the pop-up menu to process commands....................... 16

Using the Component Store section .............................................. 16

Customizing preferences ............................................................... 17

CHAPTER 3 Getting Started............................................................................... 21

Starting Sybase IQ ETL Development ........................................... 21

Creating your first project ........................................................ 22

Adding a data provider ............................................................ 22

Adding a data sink................................................................... 23

Adding a data calculator.......................................................... 24

Simulating the project..................................................................... 25

CHAPTER 4 Projects and Jobs.......................................................................... 27

Managing projects.......................................................................... 27

Simulating and executing a project ................................................ 29

Viewing current mappings....................................................... 31

Managing port attributes.......................................................... 32

Viewing a simulation flow ........................................................ 32

Controlling multiple data streams............................................ 35

Managing jobs................................................................................ 36

Job components...................................................................... 36

Executing a job........................................................................ 37

Monitoring the job execution process...................................... 37

Cancelling job execution ......................................................... 38

Creating Jobs .......................................................................... 38

Using templates to create projects and jobs .................................. 40

Building a migration template.................................................. 40

Managing a migration template............................................... 43

CHAPTER 5 Advanced Concepts and Tools .................................................... 45

Content Explorer ............................................................................ 45

Opening Content Explorer....................................................... 46

Using the Design area............................................................. 46

Inspecting log file information......................................................... 49

Managing jobs and scheduled tasks.............................................. 49

Customizing SQL and transformation rules ................................... 51

Using expressions and procedures......................................... 52

Including variables................................................................... 52

Using functions........................................................................ 53

Using Square Bracket Notation............................................... 54

Entering SQL statements ........................................................ 54

Using the JavaScript Procedure Editor and Debugger............ 57