Install HPE ALM Service

The HPE ALM Service is part of the CA Test Data Manager installation. If you have installed a stand-alone instance of  (without CA Test Data Manager) and want to connect to HP Quality Center through the Service, you have to install the HPE ALM Service manually. This section takes you step by step through the installation and configuration process for installations with a MS SQL database. 
ard22
The HPE ALM Service is part of the CA Test Data Manager installation. If you have installed a stand-alone instance of 
Agile Requirements Designer
 (without CA Test Data Manager) and want to connect to HP Quality Center through the Service, you have to install the HPE ALM Service manually. This section takes you step by step through the installation and configuration process for installations with a MS SQL database. 
We recommend that you connect to your HPE ALM instance using the REST API. It's the simpler method and does not require any configuration or installation. The REST API does not support importing BPTs. If you require to import BPTs, connect through the GT HPE ALM Service, as described in this installation article.
Install and Configure the Service
  1. Install the Microsoft SQL Express to create an instance.
    1. Within a database in the server, run the provided scripts 
      SQLserverGT_web_log.sql
       and 
      gtrep_insert_web_log.sql
       to add a table and a procedure to the database. You can find the scripts in the 
      <installation_path>\Scripts\SQLServer
       directory.
    2. Ensure that that TCP/IP is enabled for this server:
      1. Open 
        SQL Server Configuration Manager, SQL Server Network Configuration, Protocols
         for your server name.
      2. Right-click on 
        TCP/IP
         and select 
        Enable
         (you might be required to restart the computer).
  2. Enable the group policy settings:
    1. Type 
      gpedit.msc
       in the command prompt and press Enter.
    2. In the policy editor navigate to this node: 
      Computer Configuration
      Administrative Templates,
       
      System
      User Profiles
      .
    3. Under the User Profiles pane on the right, set the policy 
      Do not forcefully unload the user’s registry at user logoff
       to 
      Enabled
      .
  3. Add a firewall exception:
    1. Go to the 
      Start
       menu, type 
      wf.msc
       in the search field and press the Enter key.
    2. Click 
      Inbound Rules, New Rule
       and select 
      Port
      .
    3. Enter the port which the ALM service will use (typically, 8095) in 
      Specific local ports
       and click 
      Next
      .
    4. Select the 
      Allow the connection
       option and click 
      Next
      .
    5. In the Profile dialog, select all options.
    6. Provide name and description for the rule (for example, "Opened port 8095 for Grid-Tools ALM") and click 
      Finish
      .
  4. Download ALM client registration.
    Running Internet Explorer in administrator mode, go to the URL of the ALM you are connecting to (for example, http://alm.yourcompany.com:8080/qcbin/) and click 
    Tools
    HPE ALM Connectivity
    Download
    .
  5. Install the HPE ALM service by running the 
    setup_GTALMService.exe
     file.
  6. Go to 
    C:\Grid-Tools\GTHPALMService\GTHPALMService_ConfigEditor
    , open the 
    ALMserviceConfigEditor.exe
     and configure the first tab:
    1. ALM URL
      : the same one as earlier (for example, http://alm.yourcompany.com:8080/qcbin/)
    2. Service address
      : http://localhost:8095/ (replace the * with localhost)
    3. ALM Version
      : ALM 12 Patch
    4. Click 
      Verify
       to test whether you have access.
  7. Edit the Connection String tab:
    1. Data Base
      : SQL server
    2. Data Source
      : Enter the name of the instance that you created.
    3. User Id
      : Enter username of login to server. If you are using integrated security, enter 'admin'.
    4. Password
      : Enter the corresponding password. If you are using integrated security, enter 'admin'.
    5. Initial Catalog
      : Enter the name of the database where you installed the tables from before.
    6. Click 
      Verify
       and 
      Save
      . If using you are integrated security, this will not connect yet.
  8. Edit Log configuration
    Specify exactly the same settings as on the 
    Connection String
     tab.
  9. If you are using Windows integrated security, edit the config file:
    1. Close the ALMserviceConfigEditor.
    2. Open 
      GTHPALMServiceConsole.exe.config
       located in 
      C:\Grid-Tools\GTHPALMService\
      .
    3. Find 
      add name="connStr" connectionString=
      .
    4. Replace any user ID and password with 
      Integrated Security=True
      Example:
      connectionString="Data Source=SMITH01;Integrated Security=True;Initial Catalog=HP_ALM_TEST;Network Library=dbmssocn;"
       
    5. Find 
      connectionString value=.
       There should be two locations, one for Oracle servers, one for Microsoft SQL. Edit the SQL one.
    6. Replace the userID and password fields with 
      IntegratedSecurity=True
      .
    7. Save
       and 
      Close
      .
      The service is installed and configured.
  10. Start the Service
    1. Open the ALMserviceConfigEditor.
    2. Verify all the tabs. The log tabs have empty username and passwords if you are using Windows integrated security.
    3. Go to the Status tab and click 
      Create Task
      .
    4. Enter the username and password details for the machine you are working on.
    5. Click 
      Start Service
      .
    The service starts running. 
Now you are ready to connect, map attributes, and start using the integration. For more information, see Integrate With HPE ALM (GT HPE ALM Service).