---
title: Creating Datasources
slug: kronpam-reference-guide-legacy-ui-3-4-0/zJCa-creating-datasources
description: Learn how to define a database in Kron PAM for sensitive data search with this detailed document. Follow step-by-step instructions on navigating the Datasource Manager, entering vital information like datasource name, connection URL, username, and passwor
docTags: 
createdAt: 2022-08-01T17:37:29.000Z
---

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.

1. Navigate to** Administration** > **Datasource Manager**.
2. Enter the Datasource name, description, connection URL, username, password, and **Max. Thread Count for Sensitive Data Discovery.** (optional)
3. Click the **Test Connection** button to test.
4. Click the **Save** button to save the connection information.

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/fPQAHiXbnCO_PfkoazyWv_image.png "Creating a Datasource")

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