Configuring the Associated PowerCenter Integration Service
You can configure or remove the PowerCenter Integration Service that Metadata Manager uses to load metadata into the Metadata Manager warehouse. If you remove the PowerCenter Integration Service, configure another PowerCenter Integration Service to enable the Metadata Manager Service.
To edit the associated PowerCenter Integration Service properties, select the Metadata Manager Service in the Navigator, select the Associated Services view, and click Edit. To apply changes, restart the Metadata Manager Service.
The following table describes the associated PowerCenter Integration Service properties:
Property | Description |
|---|
Associated Integration Service | Name of the PowerCenter Integration Service that you want to use with Metadata Manager. |
Repository User Name | Name of the PowerCenter repository user that has the required privileges. Not available for a domain with Kerberos authentication. |
Repository Password | Password for the PowerCenter repository user. Not available for a domain with Kerberos authentication. |
Security Domain | Name of the security domain to which the PowerCenter repository user belongs. |
Privileges for the Associated PowerCenter Integration Service User
The PowerCenter repository user for the associated PowerCenter Integration Service must be able to perform the following tasks:
- •Restore the PowerCenter repository.
- •Import and export PowerCenter repository objects.
- •Create, edit, and delete connection objects in the PowerCenter repository.
- •Create folders in the PowerCenter repository.
- •Load metadata into the Metadata Manager warehouse.
To perform these tasks, the user must have the required privileges and permissions for the domain, PowerCenter Repository Service, and Metadata Manager Service.
The following table lists the required privileges and permissions that the PowerCenter repository user for the associated PowerCenter Integration Service must have:
Service | Privileges | Permissions |
|---|
Domain | - - Access Informatica Administrator
- - Manage Services
| Permission on PowerCenter Repository Service |
PowerCenter Repository Service | - - Access Repository Manager
- - Create Folders
- - Create, Edit, and Delete Design Objects
- - Create, Edit, and Delete Sources and Targets
- - Create, Edit, and Delete Run-time Objects
- - Manage Run-time Object Execution
- - Create Connections
| - - Read, Write, and Execute on all connection objects created by the Metadata Manager Service
- - Read, Write, and Execute on the Metadata Load folder and all folders created to extract profiling data from the Metadata Manager source
|
Metadata Manager Service | Load Resource | - |
In the PowerCenter repository, the user who creates a folder or connection object is the owner of the object. The object owner or a user assigned the Administrator role for the PowerCenter Repository Service can delete repository folders and connection objects. If you change the associated PowerCenter Integration Service user, you must assign this user as the owner of the following repository objects in the PowerCenter Client:
- •All connection objects created by the Metadata Manager Service
- •The Metadata Load folder and all profiling folders created by the Metadata Manager Service