---
title: Creating Datasources
slug: reference-guide-3-0-0/creating-datasources
description: Learn how to define and test a database in Single Connect with this comprehensive document. Find detailed instructions on entering the necessary details such as datasource name, connection URL, username, password, and maximum thread count. Additionally, d
docTags: 
createdAt: 2022-08-01T17:37:29.000Z
---

The database to be searched for sensitive data must be defined in Single Connect 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 datasource 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