Administering tasks

The previous recipe is part of the basic administration tasks too, of course. I separated it from the current one as I wanted to put an accent on Data Services architecture details by explaining the main Data Services components in relation to the methods and tools you can use to manipulate them.

How to do it…

Here, we will look at some of the most important administrative tasks.

1. Using Repository Manager:

   As you can probably remember, there are two types of repositories in Data Services: the local repository and central repository. They serve different purposes but can be created in quite a similar way: with the help of the Data Services Repository Manager tool.

   This is a GUI-based tool available on your Windows machine and installed with other client tools.

   As we already have one repository created and configured automatically during the Data Services installation, let's check its version using the Repository Manager tool.

   Launch Repository Manager and enter the following values for the corresponding options:

   

   After entering these details, you have several options:

   Create: This option creates repository objects in the defined database. As we already have a repository in DS_LOCAL_REPO, the application will ask us whether we want to reset the existing repository. Sometimes, this can be useful, but keep in mind that it will cleanse the repository of all objects, and if not careful, all your ETL that resides in the repository can be lost.

   Upgrade: This option upgrades the repository to the version of the Repository Manager tool. It is useful during software upgrades. After installing the new version of IPS and Data Services, you have to upgrade your repository contents as well. This is when you launch the Repository Manager tool (which has already been updated) and upgrade your repository to the current version.

   Get version: This is the safest option of them all. It just returns the string containing the repository version number. In our case, it returned: BODI-320030: The local repository version: <14.2.4.0>.

2. Using Server Manager and CMC to register the new repository:

   After you create the new repository with Repository Manager, you have to register it in IPS and link it to the existing Job Server.

   To register a new repository in IPS, use the following steps:

   1. Launch Central Management Console.
   2. Open the Data Services section from the CMC home page.
   3. Go to Manage | Configure Repository.
   4. Enter database details of your newly created repository and click on Save.
   5. To assign users a required set of privileges, use User Security when right-clicking on the repository in the list. For details, see the Configuring user access recipe.

   To link a new repository to the Job Server, perform these steps:

   1. Launch the Data Services Server Manager tool.
   2. Choose the Job Server tab.
   3. Press on the Configuration Editor… button.
   4. Select Job Server and press the Edit… button.
   5. In the Associated Repositories panel, press the Add… button and fill in database-related information of the new repository in the correspondent fields on the right-hand side.
   6. Use the Close and Restart button in the Data Services Server Management tool to apply the changes done to a Job Server.
3. Using License Manager:
   1. License Manager exists only in a command-line mode.
   2. Use the following syntax to run License Manager:

      LicenseManager [-v | -a <keycode> | -r <keycode> [-l <location>]] 

   3. Use the –v option to view existing license keys, -a to add a new license key, and –r to remove the existing license key from the –l location specified.

This tool is available at C:\EIM\Data Services\bin\.

How it works…

Creating and configuring a new local repository is usually required when you set up an environment for a new ETL developer or want to use an extra repository to migrate your ETL for ETL testing purposes or to test a repository upgrade.

After creating a new local repository, you should always link it to an existing Job Server. This link ensures that Job Server is aware of the repository and can execute jobs from it.

Finally, License Manager can be used to see the license key used in your installations and to add new extra ones if required.

See also

You can practice with your Data Services admin skills by creating a new database and new local Data Services repository. Do not forget that you do not just have to create it, but also register it with IPS services and Data Services Job Server so that you can successfully run jobs from it.

Some other administrative tasks can be found in the following chapters:

• The Starting and stopping services recipe from this chapter
• The Configure ODBC layer point from the How to do it… section of the Creating IPS and Data Services repositories recipe of this chapter