---
title: Creating Datasources
slug: kronpam-legacy-ui-reference-guide-3-5-0/zqjK-creating-datasources
description: Learn how to define data sources and apply masking rules with this comprehensive document. Follow step-by-step instructions on navigating the Datasource Manager, entering information, and testing and saving connections. Discover essential system configura
docTags: 
createdAt: 2022-08-01T16:43:24.000Z
---

Data sources to which masking rules apply must be defined by 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