Repository creation - the centralized database for Informatica

Our first step is to create a repository. As mentioned earlier in the book, the repository is the centralized database of Informatica, which is used to store metadata generated in the client tools.

To create the first repository, follow the process mentioned in the preceding section. Refer to the following screenshot.

1. Click on the Services and Nodes option. You will be presented with various services. You will see the domain name and the node name on the left side of the screen, which we created in the earlier section:

1. Navigate to Domain under Domain Navigator | Actions | New | PowerCenter Repository Service...:

1. This will open a pop-up window, which will allow you to provide details for creating the repository, as shown in the following points. Insert the details:
   • Repository name: Add the name of the repository. You can specify any name as per your wish. We are using REPO for our reference in this book.
   • Description: Write a description of the repository. This is an optional field.
   • Location: Specify the domain name we created earlier. The domain name we created earlier will appear by default, as we currently have only one domain.
   • License: Select the license key from the drop-down list. This is the default key, as we have only one key.
   • Node: Specify the node name from the drop-down list. This is the default key, as we have only one key.

The details are shown in the following screenshot:

1. Click on Next.
2. A new screen will appear. Provide the repository database details as follows:
   • Select your repository database from the drop-down list. We are using Oracle as our user (Oracle/SQL Server).
   • Specify the repository database username that we created earlier to connect to the database. We are using SYSTEM as our database user.
   • Specify the repository database user password. We are using oracle as our password.
   • Specify the database connection string. We are using orcl as our connection string.
   • The code page is required to read the data in different formats. We will be using MS Windows Latin 1 (ANSI) as the default code page to read the data in English font. You can later specify multiple code pages to read the data in different fonts.
   • Tablespace Name is an optional field and can be left blank.
   • Choose No content exists under the specified connection string. Create new content.
   • Check Create as Global Repository (May not be reverted to local).
   • Check Enable Version control (A versioned repository cannot be unversioned).

The details are shown in the following screenshot:

1. Click on Finish.

The process will take a few minutes to finish. Once done, you will see the REPO (repository) created under Domain Navigator, as shown in the following screenshot:

1. As you can see, the repository service is running in Exclusive mode. We need to change that to Normal before we proceed further. This can be done in the following way:
   1. Click on the Edit option in Repository Properties. A pop-up window will appear, which will allow you to select the following properties:
   • • Operating Mode: Select Normal from the drop-down list
     • Security Audit Trail: This should be set to No as default, as shown in the following screenshot:

1. 1. Click on OK.

1. This will change the repository mode to Normal.

With this, we have successfully configured the repository under the domain. Next, we will configure the integration service.