---
title: Creating Datasources
slug: singleconnect-reference-guide-3-1-0/creating-datasources
description: Learn how to define datasources and configure masking rules in this comprehensive document. Discover how to easily set up datasources in the Datasource Manager and ensure compatibility with different database types by setting the "aioc.available.jdbc.driv
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