In this last installment of this tutorial we’re going to setup a user account for you to be able to connect to the repository and create your mappings. We’ll also create a Repository Folder. Note that this folder is different from the Domain Folder we created previously to group domain objects like repository service and integration service. This particular folder is the actual Project folder where you put all the mappings, sources, targets, etc. To begin with, let’s login again to the Administration Console. Upon login, click the icon on the upper right corner of the page – this is the Security Page (red box below)

On the upper left corner, click Create User:

On the Create User dialog box, fill in the required details (marked in red asterisk):

On the property page of the user created, there’s an Overview and Privileges tab:

Go to Privileges tab.

Choose Edit again, and we’ll give this user the PowerCenter Developer (to create mappings) and PowerCenter Repository Folder Administrator (to create folders) role:

Click OK.

Create Repository Folder

To create the Project Folder we’ll need to use one of the PowerCenter client tools – Repository Manager. Go to “Start -> Programs -> Informatica PowerCenter 8.6.0 -> Client -> PowerCenter Repository Manager“.

On the menu, “Repository -> Configure Domains“. Initially you might not have a domain listed yet on the dialog box below. To create a domain login settings, click on the button highlighted below:

Fill in your domain settings below:

Click OK. Once your back on the Configure Domain dialog box, make sure that the ETLRepDev repository is checked on the right side.

After clicking OK, you should see now the repository on the left side under Repositories.

Now right click on ETLRepDev, then click Connect. On the dialog box, login using the account we created earlier:

Once connected, go to menu “Folder -> Create“ and fill in the Name of the folder in the dialog box as shown below:

Click OK, and you should see now the folder on the left side. Now go to Informatica PowerCenter Designer, and connect using the same account. You should see the same folder we created here.

And we’re done! From here you can already start importing Sources, Targets and create Mappings!