---
title: Creating Datasources
slug: singleconnect-reference-guide-3-1-0/tSMx-creating-datasources
description: Learn how to set up a secure database in Single Connect with this comprehensive guide. From entering datasource information to testing and saving connection details, this document will walk you through each step. Explore URL examples for various database 
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