Use the workbench to connect to a SQL Management repository,
create and manage runtime groups in a repository, and manage pureQuery
information that is stored in the repository runtime group versions.
Before you begin
Before you manage a SQL Management repository in a database,
you use the ManageRepostory utility to create a repository. To create
a repository, see Creating a repository.
Procedure
Use the following steps to create a connection to a repository:
- Open the Common Repositories perspective from . The default Common Repositories
perspective contains a Common Repository Explorer view
and an Eclipse Properties view.
You
can also open the Common Repository Explorer view
from . In Show View,
click .
- From the Common Repository Explorer view,
connect to a database that contains a SQL Management repository, and
create and manage runtime group versions.
To create
a connection to a repository, right-click Common Repository
Connections, then click New.
After a repository connection is defined, the properties
for the repository connection are displayed in the Properties view.
- In the new connection node, expand the SQL Management repository
node to display the runtime groups and group versions contained in
the repository. The selected runtime group properties
are displayed in the Properties view. These properties
include the count of incremental captures that are associated with
the runtime group and the latest timestamp of all the associated captured
SQL data.
You can create runtime groups, manage
runtime group version data, add SQL data to a rutnime group version,
and replace data in a runtime group version.