Managing a Repository Domain
A repository domain is a group of linked PowerCenter repositories that consists of one global repository and one or more local repositories. You group repositories in a repository domain to share data and metadata between repositories. When working in a repository domain, you can perform the following tasks:
- •Promote metadata from a local repository to a global repository, making it accessible to all local repositories in the repository domain.
- •Copy objects from or create shortcuts to metadata in the global repository.
- •Copy objects from the local repository to the global repository.
Prerequisites for a PowerCenter Repository Domain
Before building a repository domain, verify that you have the following required elements:
- •A licensed copy of Informatica to create the global repository.
- •A license for each local repository you want to create.
- •A database created and configured for each repository.
- •A PowerCenter Repository Service created and configured to manage each repository.
A PowerCenter Repository Service accesses the repository faster if the PowerCenter Repository Service process runs on the machine where the repository database resides.
- •Network connections between the PowerCenter Repository Services and PowerCenter Integration Services.
- •Compatible repository code pages.
To register a local repository, the code page of the global repository must be a subset of each local repository code page in the repository domain. To copy objects from the local repository to the global repository, the code pages of the local and global repository must be compatible.
Building a PowerCenter Repository Domain
Use the following steps as a guideline to connect separate PowerCenter repositories into a repository domain:
- 1. Create a repository and configure it as a global repository. You can specify that a repository is the global repository when you create the PowerCenter Repository Service. Alternatively, you can promote an existing local repository to a global repository.
- 2. Register local repositories with the global repository. After a local repository is registered, you can connect to the global repository from the local repository and you can connect to the local repository from the global repository.
- 3. Create user accounts for users performing cross-repository work. A user who needs to connect to multiple repositories must have privileges for each PowerCenter Repository Service.
When the global and local repositories exist in different Informatica domains, the user must have an identical user name, password, and security domain in each Informatica domain. Although the user name, password, and security domain must be the same, the user can be a member of different user groups and can have a different set of privileges for each PowerCenter Repository Service.
- 4. Configure the user account used to access the repository associated with the PowerCenter Integration Service. To run a session that uses a global shortcut, the PowerCenter Integration Service must access the repository in which the mapping is saved and the global repository with the shortcut information. You enable this behavior by configuring the user account used to access the repository associated with the PowerCenter Integration Service. This user account must have privileges for the following services:
- - The local PowerCenter Repository Service associated with the PowerCenter Integration Service
- - The global PowerCenter Repository Service in the domain
Promoting a Local Repository to a Global Repository
You can promote an existing repository to a global repository. After you promote a repository to a global repository, you cannot change it to a local or standalone repository. After you promote a repository, you can register local repositories to create a repository domain.
When registering local repositories with a global repository, the global and local repository code pages must be compatible. Before promoting a repository to a global repository, make sure the repository code page is compatible with each local repository you plan to register.
To promote a repository to a global repository, you need to change the operating mode of the PowerCenter Repository Service to exclusive. If users are connected to the repository, have them disconnect before you run the repository in exclusive mode.
1. In the Administrator tool, click the Manage tab > Services and Nodes view.
2. In the Domain Navigator, select the PowerCenter Repository Service for the repository you want to promote.
3. If the PowerCenter Repository Service is running in normal mode, change the operating mode to exclusive.
4. If the PowerCenter Repository Service is not enabled, click Enable.
5. In the repository properties section for the service, click Edit.
6. Select Global Repository, and click OK.
The Repository Authentication dialog box appears.
7. Enter your user name, password, and security domain.
The Security Domain field appears when the Informatica Domain contains an LDAP security domain.
8. Click OK.
After you promote a local repository, the value of the GlobalRepository property is true in the general properties for the PowerCenter Repository Service.
Registering a Local Repository
You can register local repositories with a global repository to create a repository domain.When you register a local repository, the code pages of the local and global repositories must be compatible. You can copy objects from the local repository to the global repository and create shortcuts. You can also copy objects from the global repository to the local repository.
If you unregister a repository from the global repository and register it again, the PowerCenter Repository Service re-establishes global shortcuts. For example, if you create a copy of the global repository and delete the original, you can register all local repositories with the copy of the global repository. The PowerCenter Repository Service reestablishes all global shortcuts unless you delete objects from the copied repository.
A separate PowerCenter Repository Service manages each repository. For example, if a repository domain has three local repositories and one global repository, it must have four PowerCenter Repository Services. The PowerCenter Repository Services and repository databases do not need to run on the same machine. However, you improve performance for repository transactions if the PowerCenter Repository Service process runs on the same machine where the repository database resides.
You can move a registered local or global repository to a different PowerCenter Repository Service in the repository domain or to a different Informatica domain.
1. In the Administrator tool, click the Manage tab > Services and Nodes view.
2. In the Domain Navigator, select the PowerCenter Repository Service associated with the local repository.
3. If the PowerCenter Repository Service is running in normal mode, change the operating mode to exclusive.
4. If the PowerCenter Repository Service is not enabled, click Enable.
5. To register a local repository, on the Manage tab Actions menu, click Repository Domain > Register Local Repository. Continue to the next step. To unregister a local repository, on the Manage tab Actions menu, click Repository Domain > Unregister Local Repository. Skip to step 11. 6. Select the Informatica domain of the PowerCenter Repository Service for the global repository.
If the PowerCenter Repository Service is in a domain that does not appear in the list of Informatica domains, click Manage Domain List to update the list.
The Manage List of Domains dialog box appears.
7. To add a domain to the list, enter the following information:
Field | Description |
|---|
Domain Name | Name of a Informatica Domain that you want to link to. |
Host Name | Machine hosting the master gateway node for the linked domain. The machine hosting the master gateway for the local Informatica Domain must have a network connection to this machine. |
Host Port | Gateway port number for the linked domain. |
8. Click Add to add more than one domain to the list, and repeat step 7 for each domain. To edit the connection information for a linked domain, go to the section for the domain you want to update and click Edit.
To remove a linked domain from the list, go to the section for the domain you want to remove and click Delete.
9. Click Done to save the list of domains.
10. Select the PowerCenter Repository Service for the global repository.
11. Enter the user name, password, and security domain for the user who manages the global PowerCenter Repository Service.
The Security Domain field appears when the Informatica Domain contains an LDAP security domain.
12. Enter the user name, password, and security domain for the user who manages the local PowerCenter Repository Service.
13. Click OK.
Viewing Registered Local and Global Repositories
For a global repository, you can view a list of all the registered local repositories. Likewise, if a local repository is registered with a global repository, you can view the name of the global repository and the Informatica domain where it resides.
A PowerCenter Repository Service manages a single repository. The name of a repository is the same as the name of the PowerCenter Repository Service that manages it.
1. In the Administrator tool, click the Manage tab > Services and Nodes view.
2. In the Domain Navigator, select the PowerCenter Repository Service that manages the local or global repository.
3. On the Manage tab Actions menu, click Repository Domain > View Registered Repositories.
For a global repository, a list of local repositories appears.
For a local repository, the name of the global repository appears.
Note: The Administrator tool displays a message if a local repository is not registered with a global repository or if a global repository has no registered local repositories.
Moving Local and Global Repositories
If you need to move a local or global repository to another Informatica domain, complete the following steps:
- 1. Unregister the local repositories. For each local repository, follow the procedure to unregister a local repository from a global repository. To move a global repository to another Informatica domain, unregister all local repositories associated with the global repository.
- 2. Create the PowerCenter Repository Services using existing content. For each repository in the target domain, follow the procedure to create a PowerCenter Repository Service using the existing repository content in the source Informatica domain.
Verify that users and groups with privileges for the source PowerCenter Repository Service exist in the target domain. The Service Manager periodically synchronizes the list of users and groups in the repository with the users and groups in the domain configuration database. During synchronization, users and groups that do not exist in the target domain are deleted from the repository.
You can use infacmd to export users and groups from the source domain and import them into the target domain.
- 3. Register the local repositories. For each local repository in the target Informatica domain, follow the procedure to register a local repository with a global repository.