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

Back Next

Create an Installer Package

You can use an installer authoring tool, such as Microsoft Installer (MSI), to create the installer for SQLWorkbench.

Create an installer with options for fresh install and upgrade.

The following code contains sample commands for install and upgrade options:

msiexec /i <installer directory> TARGETDIR=<client directory> /quiet

for a fresh install. A fresh install creates the files but does not replace the files if they exist.

For example:

msiexec /i InfaInstaller.msi TARGETDIR=C:\DDMClient /quiet

msiexec /fa <installer directory> TARGETDIR=<client directory> /quiet

for an upgrade or repair. An upgrade or repair deletes old files and copies the files from the installer.

For example:

msiexec /fa InfaInstaller.msi TARGETDIR=C:\DDMClient /quiet

Create an installer that performs the following tasks during a fresh install:

Copies the

GenericJDBC.jar

file to the target directory:

<TARGETDIR>\JDBC\GenericJDBC.jar

is the SQLWorkbench install directory.

The following image shows the original SQLWorkbench folder structure:

Creates the following files in the specified location:

<TARGETDIR>\SQLWorkbench64_ddm.exe

<TARGETDIR>\SQLWorkbench64_ddm.ini

During an upgrade, the installer overwrites and updates the files.