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

Oracle SQL Developer Configuration

Oracle SQL Developer Configuration

Complete the following steps to configure the Oracle SQL Developer 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:
    <SQL Developer installation>\sqldeveloper\lib
  3. Find the sqldeveloper.conf file. You can find the file in the in the following location:
    <SQL Developer installation>\sqldeveloper\bin
  4. Save a backup of the sqldeveloper.conf file.
  5. Open the sqldeveloper.conf file in a text editor. To append the -javaagent argument to the Java command line, add one of the following options to the file:
    • If you want to enable logging on the client machine, enter the following text:
      AddVMOption -DDDM_GENJDBC_LOG = <config file location and name> AddVMOption -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:
      Add VM Option -javaagent:..\lib\GenericJDBC.jar= host:<ddm_host>,port:<ddm_generic_service_port>
  6. Save sqldeveloper.conf.
  7. Use sqldeveloper.exe to launch Oracle SQL Developer.

0 COMMENTS

We’d like to hear from you!