Accessing the Sybase ETL Demo Repository

Sybase IQ ETL includes a demo repository with predefined projects and jobs designed to familiarize users with the product. The Sybase IQ ETL User’s Guide refers to that demo repository in Chapter 3, “Getting Started”, and Chapter 6, “Components”.

Starting Sybase IQ ETL Development displays the Repository window.

The default login data to access the demo repository is:

• Connection: Repository

• Client: transformer

• Client user:TRANSFORMER

• Password: transformer

These values are preset on initial login. On subsequent logins, you might need to select or enter this information.

1. Enter a new Client user name and a password. (Note: do not change the Client.)

2. Activate the Register new user and the Show all objects option.

3. Click Logon.

4. Confirm your password and click OK.

The default login information to the demo repository is automatically set up during Sybase IQ ETL Development installation. Use the following information to correct or restore the settings.

1. Configure the ODBC User Data Source:

   • Driver: Microsoft Access

   • Name: DEMO_Repository

   • Database: <datadir>\Demodata\IQETLDEMO_REP.MDB

2. Set up the repository connection in the Repository window:

   1. Select Repository from the Connection list and choose one of the following:

      • Edit

      • Add and type a name for the connection

   2. Select dbodbc from the Interface list.

   3. Select DEMO_Repository from the Host list.

   4. Click Save.

<datadir> is either the installation or the user data directory, see Sybase IQ Installation and Configuration Guide for details.

See also “Administering the repository” in Chapter 2 of the Sybase IQ ETL User’s Guide 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 Sybase IQ Installation and Configuration Guide for details.