3.4.2 Dynamic Data Masking

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 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, 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 jdbc\ mysql //ipaddress\ port/dbname ex jdbc\ mysql //10 20 30 40 3306/testdb • cassandra jdbc\ cassandra //ipaddress\ port/dbname ex jdbc\ cassandra //10 20 30 40 9160/testdb • oracle jdbc\ oracle\ thin @//ipaddress\ port/dbname ex jdbc\ oracle\ thin @//10 20 30 40 1521/testdb • mssql jdbc\ sqlserver // ipaddress\ port;databasename=dbname ex jdbc\ sqlserver //10 20 30 40 1433;databasename=testdb • teradata jdbc\ teradata //10 20 30 40/database=testdb • postgresql jdbc\ postgresql //10 20 20 40 5432/xdb 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 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 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 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