Previous Topic: How to Load the Form in to the Harvest DatabaseNext Topic: Load and Verify the Form for Windows

Installing and Configuring the Connector for CA Unicenter® Service Desk and CA Software Change Manager for Distributed with Harvest › How to Load the Form in to the Harvest Database › Load and Verify the Form for UNIX

Load and Verify the Form for UNIX

To load the form into the Harvest database on the Harvest-UNIX server

  1. Ensure that the Harvest database is running, and connect to it.
  2. Start the command prompt.
  3. If the Harvest database is running on Oracle, do this step; otherwise skip it.

    Run the SD_CL_CONNECTOR_ORACLE.sql script file by entering the following command:

    sqlplus <harvest db user name>/<harvest db password>@<SID> 
   @<file name>

    Example:

    sqlplus harvest/harvest@orcl @ 
   “/opt/CA/CMI/config/SD_CL_CONNECTOR_ORACLE.sql”
  4. If the Harvest database is running on Ingres, do this step; otherwise skip it.

    Run the SD_CL_CONNECTOR_INGRES.sql script file by entering the following command at the command prompt:

    Sql -u<user> -G<group name> <database name> <'sqlfile'>

    Example:

    If the database user is harvest and the group is harvest, execute the following command:

    Sql -uharvest -Gharvest_group mdb <“/opt/CA/CMI/config/SD_CL_CONNECTOR_INGRES.sql”

To verify that the form was loaded into the Harvest database correctly

  1. Log in to Harvest Administrator, and connect to the Harvest broker for your UNIX server.
  2. Copy the following from the c:\Program Files\CA\CMI\config folder of the connector to the %HARVESTHOME%\FORMS folder of the Harvest client:
  3. Select the Forms tab and verify that the SD-Clarity Connector form appears in the list of available forms.