User`s guide

CHAPTER 2 Sybase IQ ETL Development Desktop
User’s Guide 11
Administering the repository
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.
Note 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.
Opening a repository
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
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.
Closing a client user
session
To close a user session, right-click the session and select Close Client.
Adding a repository
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.
❖ To add a repository
1 From the Repository Logon dialog box, click Add.
2 Enter the parameters for your new connection. A message box asks
whether to create repository tables.
3 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
1 Enter a client name.