Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking Administration
  3. Authentication
  4. Security
  5. Connection Management
  6. JDBC Client Configuration
  7. ODBC Client Configuration
  8. Configuration for MicroStrategy
  9. Access Control
  10. Logs
  11. High Availability
  12. Server Control
  13. Performance Tuning
  14. Troubleshooting
  15. Appendix A: Database Keywords

Administrator Guide

Administrator Guide

SQuirreL Configuration

SQuirreL Configuration

Complete the following steps to configure the SQuirreL SQL client:
  1. Copy the GenericJDBC.jar file. You can find the file in the following location:
    <Dynamic Data Masking installation>\Wrappers\jdbc\GenericJDBC.jar
  2. Save the GenericJDBC.jar file in the following location:
    <SQuirreL installation>\lib
  3. Find the squirrel-sql.bat file. You can find the file in the SQuirreL installation directory.
  4. Save a backup of the squirrel-sql.bat file.
  5. Open the squirrel-sql.bat file in a text editor. To append the -javaagent argument to the Java command line, add one of the following options to the penultimate line of text in the file:
    • If you want to enable logging on the client machine, enter the following text:
      -DDDM_GENJDBC_LOG = <config file location and name> -javaagent:.\lib\GenericJDBC.jar=host:<ddm_host>,port:<ddm_generic_service_port>
    • If you do not want to enable logging on the client machine, enter the following text:
      -javaagent:.\lib\GenericJDBC.jar= host:<ddm_host>,port:<ddm_generic_service_port>
    The line that you modified is similar to the following text:
    "%LOCAL_JAVA%" -verbose -Xmx256m -Dsun.java2d.noddraw=true -DDDM_GENJDBC_LOG = <config file location and name> -javaagent:.\lib\GenericJDBC.jar= host:<ddm_host>,port:<ddm_generic_service_port> -cp %SQUIRREL_CP% -splash:"%SQUIRREL_SQL_HOME%/icons/splash.jpg" net.sourceforge.squirrel_sql.client.Main %TMP_PARMS%
  6. Save squirrel-sql.bat.

0 COMMENTS

We’d like to hear from you!