Install VSQL Client Driver

Does not apply in a SaaS environment.

The Logger host requires the VSQL client to perform the data migration procedure. If client is not present yet, follow these steps to install the VSQL Client driver.

1. Download the TAR version of the driver.

   This feature requires, at a minimum, version 11.1 of the ArcSight Database
   Tip: Micro Focus recommends to use the same version for database server and TAR driver. Refer to the Technical Requirements for Arcsight Platform for details on the supported version.

2. To extract the TAR from the directory, run the following command:

   tar xvfz vertica-client-[version] [OS].tar.gz -C /

3. From your home directory, add the PATH:

   cd ~

4. Open the file:

   vi .bashrc

5. On the PATH variable located at the /opt/vertica/bin file, add the vsql path:

   export PATH-$ANT_HOME/bin:$JAVA_HOME/bin:$PATH:$P4_HOME/bin:/opt/vertica/bin
   

   If the PATH variable is not found, create it:

   PATH=$PATH:/opt/vertica/bin

6. Save the changes:

   :wq                

7. Press Enter.

8. Refresh the .bashrc file:

   source .bashrc

9. To verify VSQL has been installed, run the following command:

   vsql --version