---
title: 3.4.2    Dynamic Data Masking
slug: singleconnect-2-16/342-dynamic-data-masking
description: Learn how to configure dynamic data masking in your database using Single Connect with this step-by-step document. From creating a datasource and setting system configuration parameters to understanding the URL formats for different database types, this g
docTags: 
createdAt: 2020-07-17T14:07:28.000Z
---



For dynamic data masking, the database must be defined on Single Connect with credentials to get schema, table and column names.

**Creating Datasource**

1\.   Log in to the Single Connect GUI
2\.   Navigate to Administration > Datasource Manager
3\.   Enter the Datasource name, description, connection URL, username and password
4\.   Click on the Test Connection button to test and the Save button to save the connection information

::Image[]{src="https://api.archbee.com/api/presign/g9cApVza9NIhSh0pjZYtA/rClLvVg4hn-rJC_rxxsql_image.png" size="84" caption="Creating Datasource" position="center" showCaption="true"}



The following system configuration parameter should be set for the driver option;

1\.   Log in to the Single Connect Web GUI
2\.   Navigate to the Administration > System Config Man.
*3.   *Set the “***aioc.available.jdbc.drivers***” parameter with requested database types separating by with a “,”
      comma

| **Parameter Name**              | **Parameter Value**                                                                                                                                                                                                                  |
| ------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **aioc.available.jdbc.drivers** | oracle.jdbc.driver.OracleDriver, org.postgresql.Driver,<br />com.microsoft.sqlserver.jdbc.SQLServerDriver, com.mysql.jdbc.Driver, org.apache.cassandra.cql.jdbc.CassandraDriver, com.teradata.jdbc.TeraDriver, org.postgresql.Driver |

****

URL formats for database types:

•   ***MYSQL***

<u>jdbc\:mysql://ipaddress\:port/dbname</u>

<u>Ex: jdbc\:mysql://10.20.30.40:3306/testdb</u>

<u></u>

•   ***CASSANDRA***

<u>jdbc\:cassandra://ipaddress\:port/dbname</u>

<u>Ex: jdbc\:cassandra://10.20.30.40:9160/testdb</u>

<u></u>

•   ***ORACLE***

<u>jdbc\:oracle\:thin:@//ipaddress\:port/dbname</u>

<u>Ex: jdbc\:oracle\:thin:@//10.20.30.40:1521/testdb</u>

<u></u>

•   ***MSSQL***

<u>jdbc\:sqlserver:// ipaddress\:port;databaseName=dbname</u>

<u>Ex: jdbc\:sqlserver://10.20.30.40:1433;databaseName=testdb</u>

<u></u>

•   ***TERADATA***

<u>jdbc\:teradata://10.20.30.40/database=testdb</u>

<u></u>

•   ***POSTGRESQL***

<u>jdbc\:postgresql://10.20.20.40:5432/xdb</u>

<u></u>

**Creating a Masking Method**

1\.   Log in to the Single Connect GUI
2\.   Navigate to Policy Control > SQL Proxy Policy
3\.   Open the "Masking Method" tab
4\.   Enter the masking name, description, column type and masking pattern
5\.   Save

::Image[]{src="https://api.archbee.com/api/presign/g9cApVza9NIhSh0pjZYtA/lHttW4aZW9SOXJwfHe50E_image.png" size="84" caption="Masking Method" position="center" showCaption="true"}



**Creating a Masking Policy**

1\.   Log in to the Single Connect GUI
2\.   Navigate to Policy Control > SQL Proxy Policy
3\.   Open the "Masking Policy" tab
4\.   Enter masking name, description, database name, schema, table, column and masking method
5\.   Save

::Image[]{src="https://api.archbee.com/api/presign/g9cApVza9NIhSh0pjZYtA/NIYh9QCYUm9SWUSo0H1gT_image.png" size="84" caption="Masking Policy" position="center" showCaption="true"}

**

**Creating a Policy Group**

1\.   Log in to the Single Connect GUI
2\.   Navigate to Policy Control > Session Policy
3\.   Open the “Policy Group” tab
4\.   Enter Policy Group name and select the policy/policies and masking rule(s)
5\.   Select the operation mode and action type
6\.   Save

::Image[]{src="https://api.archbee.com/api/presign/g9cApVza9NIhSh0pjZYtA/rnLRFodAaUzUaw_V5DS-e_image.png" size="84" caption="Policy Group" position="center" showCaption="true"}



**Creating a Policy Realm**

1\.   Log in to the Single Connect GUI
2\.   Navigate to Policy Control > Session Policy
3\.   Open the Policy Realm tab
4\.   Enter the Policy Realm name and select the Policy Group and Device Realm.
5\.   Save

::Image[]{src="https://api.archbee.com/api/presign/g9cApVza9NIhSh0pjZYtA/7ekJvPE4T9Yk_eKc6Zkl0_image.png" size="84" caption="Defining Policy Realm" position="center" showCaption="true"}



**