User`s guide

Using templates to create projects and jobs
40 Sybase IQ ETL 4.1
Using templates to create projects and jobs
Templates provide a way to automatically create projects and jobs for special
purposes. Currently, only Migration templates are available. This section
describes how to set up and use a template for migrating tables from one
database to Sybase IQ.
Building a migration template
❖ To build a migration template
1 Right-click the Templates entry in the Navigator section, and select New |
Template from the pop-up menu. The Template Assistant guides you
through the necessary steps to build a fully configured migration template.
To modify an existing template, select Open from the pop-up menu in the
Navigator section.
2 Follow the Template Assistant by first entering the details for the job to be
created. The Name value is used for the template object and, further
qualified, for the generated transformation objects.
The currently available Migration Type is DB to IQ.
3 Provide information about the source database and select the tables to
transfer:
• Database connection properties — The database connection
properties are the same as for the DB components. The Advanced
option lets you set special database options. See “Entering database
connection parameters” on page 71 for more information.
• Table properties — To get the table catalog for the specified database,
select Logon. The available tables are listed in the lower section of the
window. By default, each table is selected for transfer. To exclude
tables you can directly deactivate the Transfer check box or select
multiple tables and choose Exclude from the pop-up menu.
You can view additional information about the tables by clicking
Browse or Count on the pop-up menu. The Count All option displays
the record count for all tables.
4 Enter database connection properties for the destination database.