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 Windows

Load and Verify the Form for Windows

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

Ensure that the Harvest database is running, and connect to it.
Start the command prompt.
If the Harvest database is running on Oracle, do this step; otherwise skip it.
Run the SD_CL_CONNECTOR_ORACLE.sql script file by executing the following command at the command prompt:
```
sqlplus <harvest db user name>/<harvest db password>@<SID> 
   @<file name>
```
Example:
```
sqlplus harvest/harvest@orcl @ 
   “C:\Program Files\CA\CMI\config\SD_CL_CONNECTOR_ORACLE.sql”
```
If the Harvest database is running on SQL Server and if you are using the default instance of SQL Server, do this step; otherwise skip it.
Run the SD_CL_CONNECTOR_SQLSERVER.sql script file by executing the following command at the command prompt:
```
osql -E -d mdb -i  <file name> -o  output.log
```
Example:
```
osql -E -d mdb -i  
   “C:\Program Files\CA\CMI \config\SD_CL_CONNECTOR_SQLSERVER.sql”
-o output.log
```
To see whether the script executed successfully, check the log file.

Note: The SD_CL_CONNECTOR_SQLSERVER.sql file is located in the %SD_CL_CNCTR_HOME%\config folder.
If the Harvest database is running on SQL Server and if you are using the named instance of SQL Server, do this step; otherwise skip it.
Execute the following command at the command prompt:
```
osql -E -S <instance name> -d mdb -i <file name>  -o output.log
```
Example:
```
osql -E -S  computer55 -d mdb -i
“C:\Program Files\CA\CMI \config\SD_CL_CONNECTOR_SQLSERVER.sql”
   -o output.log
```
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 <“C:\Program Files\CA\CMI \config\ 
   SD_CL_CONNECTOR_INGRES.sql”
```

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

Copy the following from the c:\Program Files\CA\CMI\config folder of the connector to the %HARVESTHOME%\FORMS folder of the Harvest client:
- SD-Clarity Connector.htm
- SD-Clarity Connector.hfd
- castylesr1.css
- cssimages folder
Log in to the Harvest Administrator application.
Select the Forms tab and verify that the SD-Clarity Connector form appears in the list of available forms.