An organization that uses Dynamic Data Masking creates generic JDBC connections and uses the SQLWorkbench client to access the database.

Because multiple users access the database, multiple machines require driver installation, maintenance, and regular updates to the latest drivers to access the database. Additionally, new users and machines are added in periodically and require the same updates.

The organization creates an installer to automate the process of configuring client machines.

Configuration of an SQLWorkbench client includes the following changes:

Copy the Informatica JDBC JAR file to the client machine.
Create an
SQLWorkbench64_ddm.ini
file with the required entries.
Create an
SQLWorkbench64_ddm.exe
file to use to access the database through Dynamic Data Masking.

To deploy the installer to all client machines, the organization uses Microsoft Endpoint Configuration Manager which is used to deploy regular security updates.