A Sybase IQ ETL repository is a collection of tables that save and maintain all data related to projects, jobs, and session parameters. Sybase IQ and Microsoft Access can be used to store an Sybase IQ ETL repository.
Do not manually manipulate data in the repository tables.
Sybase cannot guarantee the functionality of a repository after
it has been manually manipulated. It can also make the repository
unusable and your work might be lost.
To access projects or jobs you must log in 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.
To open a repository, right-click the Repository root element. The Repository dialog box opens. Select a repository from the list, or click Add to create a new connection.
Closing a repository ends all user sessions currently connected to the repository. To close a repository connection, right-click the repository name and select Close Connection.
To close a user session, right-click the session and select Close Client.
You can use the Repository Logon dialog box to add a repository. The Repository Logon dialog box opens automatically when you start the Sybase IQ ETL Development desktop. During a session you can open the Repository Logon dialog box by selecting Open Repository from the File Menu or by right-clicking the root of the Navigation tree.
From the Repository Logon dialog box, click Add.
Enter the parameters for your new connection. A message box asks whether to create repository tables.
Click Yes. After the repository tables are created, save the results.
Before a new repository can be accessed, it requires at least one client and one client user definition.
To create a client and client user
Enter a client name.
Enter a client user name.
Enter a password.
Select the Register New check box.
If the client user is entitled to see all existing projects within the client, select the Show All Objects check box.
Click Logon and confirm the password.
