Sybase ETL Development

Verfiy that ETL Development has been successfully installed.

StepsStarting Sybase ETL Development

  1. In Windows, select Start | Programs | Sybase | Sybase ETL Development 4.8 | Sybase ETL Development.

    The Welcome window displays. To prevent this window from displaying every time the application starts, unselect Show on Startup, and click Close.

  2. The repository login window appears, showing these default values:

    • Connection – Repository

    • Client – transformer

    • Client user name – TRANSFORMER

    • Password – transformer

      These values are automatically set the first time you log in. On subsequent logins, you might need to select or enter this information.

  3. Click Logon. If you can successfully log in to ETL Development, the installation is successful.

    NoteThe installer creates an initial set of data sources. If these repository data sources are lost for any reason, ETL Development cannot open until you restore them following the procedures below.

StepsRestoring the initial set of ODBC data sources of the demo repository

  1. Configure the ODBC user data source:

    1. Select Start | Settings | Control Panel | Administrative Tools | Data Sources (ODBC).

    2. Click Add.

    3. Select Microsoft Access Driver from the list. Click Finish.

    4. In the Data Source Name field, enter DEMO_Repository.

    5. Click Select and browse to the Demodata folder of the installation directory.

    6. Select the ETLDEMO_REP.MDB database and click OK.

  2. Set up the repository connection:

    1. Select File | Open Repository to open the Repository window.

    2. Select Repository from the Connection list and select Edit.

    3. Select ODBC from the Interface list.

    4. Select DEMO_Repository from the Host list.

    5. Click Save.

  3. Configure the additional ODBC user data sources required by the projects in the demo repository:

    • 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 for these user data sources are also located in the Demodata folder of the installation directory.