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

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)
• Service Virtualization

Issue/Introduction

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

 

Environment

All supported DevTest releases.

Cause

N/A

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

Create a new folder DEVTEST_HOME/IdentityAccessManager/database/drivers     (note: optional, this is not in the docs, it is what I do.)

Copy file DEVTEST_HOME/lib/dradis/mssql-jdbc-8.2.0.jre8.jar to folder DEVTEST_HOME/IdentityAccessManager/database/drivers.

Update DEVTEST_HOME/IdentityAccessManager/iam.properties file.
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

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   ( mssql-jdbc-8.2.0.jre8.jar) with our installer in DEVTESTGA\lib\shared folder