Creating and Deleting Repository Content
You can create and delete contents for the following repositories used by Metadata Manager:
- •Metadata Manager repository. Create the Metadata Manager warehouse tables and import models for metadata sources into the Metadata Manager repository.
- •PowerCenter repository. Restore a repository backup file packaged with PowerCenter to the PowerCenter repository database. The repository backup file includes the metadata objects used by Metadata Manager to load metadata into the Metadata Manager warehouse. When you restore the repository, the Service Manager creates a folder named Metadata Load in the PowerCenter repository. The Metadata Load folder contains the metadata objects, including sources, targets, sessions, and workflows.
The tasks you complete depend on whether the Metadata Manager repository contains contents or if the PowerCenter repository contains the PowerCenter objects for Metadata Manager.
The following table describes the tasks you must complete for each repository:
Repository | Condition | Action |
|---|
Metadata Manager repository | Does not have content. | Create the Metadata Manager repository. |
Metadata Manager repository | Has content. | No action. |
PowerCenter repository | Does not have content. | Restore the PowerCenter repository if the PowerCenter Repository Service runs in exclusive mode. |
PowerCenter repository | Has content. | No action if the PowerCenter repository has the objects required for Metadata Manager in the Metadata Load folder. The Service Manager imports the required objects from an XML file when you enable the service. |
Creating the Metadata Manager Repository
When you create the Metadata Manager repository, you create the Metadata Manager warehouse tables and import models for metadata sources.
1. In the Administrator tool, click the Manage tab > Services and Nodes view.
2. In the Domain Navigator, select the Metadata Manager Service for which the Metadata Manager repository has no content.
3. Click Actions > Repository Contents > Create.
4. Optionally, choose to restore the PowerCenter repository. You can restore the repository if the PowerCenter Repository Service runs in exclusive mode and the repository does not contain contents.
5. Click OK.
The activity log displays the results of the create contents operation.
Restoring the PowerCenter Repository
Restore the repository backup file for the PowerCenter repository to create the objects used by Metadata Manager in the PowerCenter repository database.
1. In the Administrator tool, click the Manage tab > Services and Nodes view.
2. In the Domain Navigator, select the Metadata Manager Service for which the PowerCenter repository has no contents.
3. Click Actions > Restore PowerCenter Repository.
4. Optionally, choose to restart the PowerCenter Repository Service in normal mode.
5. Click OK.
The activity log displays the results of the restore repository operation.
Deleting the Metadata Manager Repository
Delete Metadata Manager repository content when you want to delete all metadata and repository database tables from the repository. Delete the repository content if the metadata is obsolete. If the repository contains information that you want to save, back up the repository with the database client or mmRepoCmd before you delete it.
1. In the Administrator tool, click the Manage tab > Services and Nodes view.
2. In the Domain Navigator, select the Metadata Manager Service for which you want to delete Metadata Manager repository content.
3. Click Actions > Repository Contents > Delete.
4. Enter the user name and password for the database account.
5. Click OK.
The activity log displays the results of the delete contents operation.