Creating Datasources

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 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