A Sybase ETL repository is a collection of tables that save and maintain all data related to projects, jobs, and session parameters. You can use Sybase IQ, Microsoft SQL Server, Sybase Adaptive Server® Anywhere (ASA), and Microsoft Access databases, as a 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, you must 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 client users.
Select File | Open Repository. Alternatively, right-click Repositories in the Navigator 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.
In order 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 in the Client User field. The name must be alphanumeric, can contain up to 255 characters, and cannot start with a number.
Enter a password.
Select the Register New User option.
If the client user is entitled to see all existing projects within the client, select the Show All Objects option.
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 to open the Repository Logon window.
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.
