A Sybase ETL repository is a collection of tables that saves and maintains all data related to projects, jobs, and session parameters. You can use Sybase SQL Anywhere databases as the Sybase ETL repository.
Do not manually manipulate data in repository tables;
doing so can make the repository unusable, and you may also lose
data. Sybase cannot guarantee the functionality of a repository
after it has been manually manipulated.
To access projects or jobs, log on to the respective repository. To open a repository, you must assign at least one client and one client user. A client can have multiple users.
Select File | Open Repository. Or, in the Navigator, right-click Repositories and select Open Repository.
Select a repository from the Connection list and click Logon.
Closing a repository connection
In the Navigator, right-click the repository name and select Close Connection.
Click Yes to confirm that you want to close the connection and all open projects and jobs.
Closing a repository ends all user sessions currently connected to the repository.
Right-click the repository name in the Navigator and select Close Client.
Click Yes to confirm that you want to close the client and all open projects and jobs.
Select File | Open Repository to open the Repository Logon window.
Click Add.
Enter the parameters for your new repository connection and click Save.
To access the new repository, you must create at least one client and one client user definition.
Creating a client and a client user
In the Repository Logon window, enter a client name in the Client field.
Enter a Client User name. The name must be alphanumeric, can contain up to 255 characters, and cannot start with a number.
Enter a password.
Select Register New User.
If the client user is entitled to see all existing projects within the client, select Show All Objects.
Click Logon.
Reenter the password and click OK.
You can also create a user from the Use Accounts window.
See “Creating a user”.
Select File | Open Repository.
Select the repository you want to modify and click Edit.
Make changes and click Save.
Select the repository from the Connection list and click Remove.
Click Yes to confirm the removal.
