Automating the Configuration of a Generic JDBC Connection for Dynamic Data Masking

Automating the Configuration of a Generic JDBC Connection for Dynamic Data Masking

Create and Package Required Files

Create and Package Required Files

To ensure that the installer can create or update the files, create and package the required files with the installer.
The installer requires the following files:
GenericJDBC.jar
The Dynamic Data Masking installation contains the JAR file that you must save on the client machine. The JAR file contains a Java agent, a transformer that intercepts the method calls of JDBC objects, and proxy classes for JDBC classes.
You can find the .jar file in the following location:
<Dynamic Data Masking installation directory>\Wrappers\jdbc\GenericJDBC.jar
SQLWorkbench64_ddm.exe
Create a copy of the
SQLworkbench64.exe
file and name the file
SQLWorkbench64_ddm.exe
.
SQLWorkbench64_ddm.ini
Create an
SQLWorkbench64_ddm.ini
file with the following content:
working.directory=. classpath.1=sqlworkbench.jar main.class=workbench.WbStarter log.file.and.console=true log.level=warning vmarg.1= -javaagent:..\JDBC\GenericJDBC.jar=host:<host name>,port:<port number> vmarg.2= -DDDM_GENJDBC_LOG=..\JdbcLogConfig.properties
The following image shows the SQLWorkbench folder structure after the installer deploys:
The image shows the SQLWorkbench folder structure with the files and folder added by the installer.
The following image shows the contents of the JDBC folder:
The image shows the contents of the JDBC folder.
To work with a connection in Dynamic Data Masking, use the
SQLWorkbench64_ddm.exe
file to open the client. To work directly with SQLWorkbench, use the
SQLWorkbench64.exe
file to open the client.

0 COMMENTS

We’d like to hear from you!