Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking Administration
  3. Authentication
  4. Connection Management
  5. JDBC Client Configuration
  6. ODBC Client Configuration
  7. Access Control
  8. Logs
  9. High Availability
  10. Server Control
  11. Performance Tuning

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 the following text to the penultimate line of text in the file:
    -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 -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!