Creating Datasources

the database to be searched for sensitive data must be defined in kron pam with its credentials, to get the schema, table, and column names navigate to administration > datasource manager enter the datasource name, description, connection url, username, password, and max thread count for sensitive data discovery (optional) click the test connection button to test click the save button to save the connection information max thread count for data discovery defines the maximum number of parallel connection threads that can be opened on this database when using the sensitive data discovery feature if it is not defined in the data source definition, the sdd max thread count parameter value defined in the system config manager is valid as the maximum value the sdd max thread count default value is 500 url the url formats for database types should be 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