Sybase® ETL 4.2 for DI Suite includes a demo repository with predefined projects and jobs designed to familiarize users with the product. The Sybase ETL User’s Guide for DI Suite refers to that demo repository in Chapter 3, “Getting Started”, and Chapter 6, “Components”.
Starting Sybase ETL Development automatically connects you into the demo repository.
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.
Setting up a new user account on the demo repository
Sybase ETL logs you into the repository when the application launches. When you want to add new repository users, select Repository in the left pane of the Development, and then choose Open Repository. The login panel appears and you can enter the following information:
Enter a new Client user name and a password. (Note: do not change the Client.)
Activate the Register new user and the Show all objects option.
Click Logon.
Confirm your password and click OK.
If you enter a different Client or do not activate Show
all objects you will not get access to the predefined transformation
objects.
The default login information to the demo repository is automatically set up during Sybase ETL Development installation. Use the following information to correct or restore the settings.
Restoring repository data sources
The Sybase ETL 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\ETLDEMO_REP.MDB
Set up the repository connection in the Repository window:
Select Repository from the Connection list and choose one of the following:
Edit
Add and type a name for the connection
Select dbodbc from the Interface list.
Select DEMO_Repository from the Host list.
Click Save.
<datadir> is either the installation or the user data directory, see Sybase Data Integration Suite Installation Guide for details.
See also “Administering the repository” in Chapter 2 of the Sybase ETL User’s Guide for DI Suite 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 Data Integration Suite Installation Guide for details.
