Reference Guide
...
SQL Proxy
Dynamic Data Masking
Creating Datasources
2min
Datasources to which masking rules apply must be defined from the Datasource Manager:
- Navigate to Administration > Datasource Manager.
- Enter the Datasource name, description, connection URL, username and password.
- Click the Test Connection button to test, and the Save button to save the connection information.
Creating a Datasource
The following system configuration parameter should be set for the driver option.
- Navigate to the Administration > System Config Man.
- Set the “aioc.available.jdbc.drivers” parameter with the requested database types separated 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.apache.hive.jdbc.HiveDriver,org.apache.hive.jdbc.DB2Driver, cdata.jdbc.couchbase.CouchbaseDriver |
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://ipaddress/database=dbname jdbc:teradata://10.20.30.40/database=testdb
- POSTGRESQL jdbc:postgresql://ipaddress:port/dbname jdbc:postgresql://10.20.30.40:5432/testdb
- HIVE jdbc:hive2://ipaddress:port jdbc:hive2://10.20.30.40:10000
- DB2 jdbc:db2://ipaddress:port/dbname jdbc:db2://10.20.30.40:50000/TESTDB
- SAP HANA jdbc:sap://ipaddress:port jdbc:sap://10.20.20.40:30015
- Couchbase couchbase://ipaddress:port/dbname_port=portnum couchbase://10.20.30.40:2587/mybucket?n1ql_port=5353