---
title: Creating Datasources
slug: singleconnect-reference-guide-3-2-0/creating-datasources
description: Learn how to define and configure datasources for masking rules with ease using the Datasource Manager. This comprehensive document guides you through the process, from entering the datasource information to testing the connection. Discover the crucial sy
docTags: 
createdAt: 2022-08-01T16:43:24.000Z
---

Datasources to which masking rules apply must be defined from the Datasource Manager:

1. Navigate to **Administration** > **Datasource Manager**.
2. Enter the Datasource name, description, connection URL, username and password.
3. Click the **Test Connection** button to test, and the **Save** button to save the connection information.

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

The following system configuration parameter should be set for the driver option.

1. Navigate to the **Administration** >** System Config Man**.
2. 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