Sybase ETL Small Business Edition 4.2 Users Guide

This section contains updates to the Sybase ETL Small Business Edition Users Guide.

Accessing the Sybase ETL Demo Repository

Sybase ETL Small Business Edition 4.2 includes a demo repository with predefined projects and jobs designed to familiarize users with the product. The Sybase ETL Small Business Edition Users Guide refers to that demo repository in Chapter 3, “Getting Started”, and Chapter 6, “Components”.

Starting Sybase ETL SBE Development automatically connects you into the demo repository.

Restoring repository data sources

The Sybase ETL SBE installer creates an initial set of data sources. If you lose the repository data sources for any reasons, use these instructions to restore them.

Configure the ODBC User Data Source:
- Driver: Microsoft Access
- Name: DEMO_Repository
- Database: datadir\Demodata\IQETLDEMO_REP.MDB

where datadir is either the installation or the user data directory. See the Sybase ETL Small Business Edition 4.2 Installation Guide for Windows for details.

The projects in the demo repository require these additional ODBC User Data Sources:

Driver: Microsoft Access
Name: ETLDEMO_DWH; Database: DEMO_DWH.MDB
Name: ETLDEMO_GER; Database: DEMO_GER.MDB
Name: ETLDEMO_US; Database: DEMO_US.MDB

The database files are located in datadir\Demodata\ where datadir is either the installation or the user data directory. See the Sybase ETL Small Business Edition 4.2 Installation Guide for Windows for details.

Building your own Repository

Sybase ETL SBE ships with a repository containing predefined projects and jobs to demonstrate features and components of the product. This repository is used per default when starting Sybase ETL SBE. Projects and jobs you design will be stored in that repository as well. If you want to separate your own objects from the demos, you need to create and use your own repository by following these steps:

Exit Sybase ETL SBE.
Copy the repository data file Repository_plain.mdb from the Demodata subdirectory of the installation path to a desired location and name it.
Select the new repository data file as the database for the ODBC Data Source DEMO_Repository.
Restart Sybase ETL SBE.

You are now connected to your own repository.

To access the demo projects you need to redirect the ODBC Data Source to the demo repository again. See “Accessing the Sybase ETL Demo Repository”.

Flash Demonstrations

Sybase ETL Small Business Edition provides Flash demonstrations for nearly all components and some general functionality.

There are three ways to view the demos:

Select Demonstration from a component popup menu in the Component Store.
Choose either an Introduction or a Component Demonstration from the Help menu.
View a demonstration directly from the training subdirectory of the installation path.

These demonstrations show general functionality of Sybase ETL products. Some of the features might not be available in your product edition.

DB Lookup Dynamic component documentation

The value of the Key Attribute in the DB Lookup Dynamic component is represented in a predefined variable, which is used as a placeholder in the WHERE clause of the query. The documentation uses the name of this variable in wrong case. The correct name is Lookup and as variable names in the execution environment are case sensitive it needs to be used in exactly that style.

Thus the basic structure of the query for the DB Lookup Dynamic component is:

SELECT value attribute
FROM lookup table
WHERE key attribute = '[Lookup]'