Configuring DevTest to Use SQL Server for IAM, Enterprise Dashboard and Registry.

Products

• Service Virtualization

Issue/Introduction

How to Configure DevTest to Use SQL Server Database for ED, Registry and IAM 

 

Environment

All supported DevTest releases.

Resolution

Enterprise Dashboard, Registry and IAM requires their own unique database.

To Configure DevTest to use SQL SERVER , follow the below instructions. 

1. Configure the IAM Database

iam.db.vendor=mssql
iam.db.url=jdbc:sqlserver://[HOSTNAME]:1433;databaseName=[DatabaseName]
iam.db.user=[USER]
iam.db.password=[PASSWORD]
iam.db.jdbc.driver.class=com.microsoft.sqlserver.jdbc.SQLServerDriver
iam.db.jdbc.driver.path=${IAM_HOME}/database/drivers/mssql-jdbc-8.2.0.jre8.jar

Starting with DevTest 10.8.0, iam.db.jdbc.driver.class and iam.db.jdbc.driver.path no longer are specified.

2. Update dradis.properties for Enterprise Dashboard to point to SQL server. 

dradis.db.internal.enabled=false

dradis.db.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver 
dradis.db.url=jdbc:sqlserver://dbhost:1433;databaseName=DATABASENAME_ED
dradis.db.user=sqlUser
dradis.db.password=sqlPass


3. Update site.properties for Registry Start all DevTest components.

lisadb.internal.enabled=false

lisadb.pool.common.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver
lisadb.pool.common.url=jdbc:sqlserver://SERVER:PORT;databaseName=DATABASENAME_REG
lisadb.pool.common.user=database_username
lisadb.pool.common.password=database_password






** The Tables are automatically created in the external database when the registry starts for the first time. Before the schema is created, ensure that the DevTest user has DBA privileges. After the schema is created, you can remove the DBA privileges from the user.

** We ship  the sql jdbc driver with our installer in DEVTEST_HOME\lib\shared folder