Client Tools: Repository Manager
What
is the Informatica Repository Manager?
The Informatica Repository
Manager is a client tool that manages the repository objects.
Who
uses the Informatica Repository Manager?
Informatica Repository Manager is used by
system administrators and developers, alike.
Repository Manager Terminology
Repository objects – Any object found in the repository.
Folder – A collection of
repository objects that are related by source or target.
Sources – Objects that contain source table definitions. Objects can be relational tables, views, XML, flat files, etc…
Targets – Objects that contain target table definitions.
Transformations
– Reusable objects used to apply logic within mappings.
Mapplets
–
Reusable objects that contain a set of transformations that can be used in
multiple mappings.
Mappings
– A source to target logic. Mappings do not store data.
Tasks
–
Used in the Workflow Manager to help design workflows.
Repository Manager Terminology Client Tools:
Repository
Manager Sessions – A special type of task used in the
Workflow Manager to define mapping connection information.
Workflows –
A collection of sessions and tasks.
Configurations –
A predefined set of parameters that are applied to sessions.
Export/Import XML – A way to migrate objects between folders and repositories.
Drag and Drop – A way to migrate objects between folders and
repositories.
Functions of the Informatica Repository Manager
1.To configure connections
domains and add repositories
2.To view the Informatica
repository objects and dependencies
3.To create new folder
structures
4.To manage folder structures and security
5.To migrate Repository
objects 6.To Check Out/In Repository objects
To
configure domains connections and add repositories:
1.Click on the “Repository” tab. Choose
“Configure Domains…”
2.Click on the icon to add
a new domain. Enter the domain name, gateway host, gateway port. Click “OK.”
3.In the list of repositories, highlight the
repositories you would like to add.
To
view the Informatica Repository objects and dependencies:
1.Double click on the icon to open the repository.
2.Click on a folder to
open and view the contents.
3.Right click on an object
and choose “View Dependencies…”
4.Check objects to
compare. Click “OK.”
5.Objects listed are the dependent objects
within the folder.
To
create new folder structures:
1.Highlight repository to create the new
folder.
To manage folder structures and security:
1.Highlight the folder that you would like to change the permissions on.
2.Click “Folder” tab. Choose “Edit…” from the drop down menu.
3.Click on the
“Permissions” tab. You can change the permissions of any user here by clicking
on “Add…” and modifying the user’s properties.
To migrate Repository objects:
1.Select and highlight object to be exported.
2.Click on the “Repository” tab and choose
“Export objects...” from the drop down menu.
3.Highlight the folder in
the left-hand navigator where you would like your imported objects to go.
4.Click on “Repository”
and choose “Import objects…”
5.Locate your exported
XML.
6.Highlight the objects to
import and click on the button. Click “Next.”
7.Choose destination
folder by clicking on current destination folder. Highlight desired folder and
click “OK.”
8.Resolve conflicts, if
necessary.
9.Click “Import.”
To
Check Out/In Repository Objects:
1.In the “Repository Navigator,” highlight the
object you want to modify.
2.Click on the
“Versioning” tab and select “Check Out…”
3.Enter check-out
comments. Click “OK.”
4.To Check In a repository
object, high light the object you want to Check In.
5.Enter Check In comments. Click “OK.”
Create
“Custom” folders for out-of-the-box object modifications:
It is best practice to
create ‘Custom_’ folders when customizing out-of-the-box mappings and
workflows. This will allow you and other developers to easily identify
customizations made to the out-of-the-box objects.
Migrating objects to the
‘Custom_’ folders will require the migration off all dependent objects,
including workflows and sessions. This may result in the migration of dozens of
objects.
1.Log in to Repository Manager
• Start – All Programs – Informatica Power
Center – Client – Repository Manager
• Username: Administrator
• Password: Administrator
• Title: Custom_BICG_602
3.
Add BICG-adm to the user list under folder permissions. Validate access to ALL
permissions.
4.
Add OTHER-dev to the user list under the folder permissions. Validate that the
user has access to NO permissions.
(When
there are multiple projects working on the same repository, this gives us the
ability to control who has access to the specific folders. It also allows us to
create “read only” users for the production repository.)
5. Using the export/import method, migrate HZ_PARTIES table from the SDE_ORA11510_Adaptor Sources folder to Custom_BICG_602.
Comments
Post a Comment