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

Document ID : KB000116886
Last Modified Date : 03/10/2018
Show Technical Document Details
Introduction:
How to Configure DevTest to Use SQL Server Database  for ED, Registry and IAM 

 
Environment:
DevTest 10.3 and up
Instructions:
Enterprise Dashboard, Registry and IAM  requires its own unique database. To Configure DevTest to use SQL SERVER , follow the below instructions. 


1. 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


2. 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



3. Configure the IAM Database

Create the Schema for IAM,  and run the installer.  It will prompt you to enter the details for IAM database. 

If you have already installed IAM  using embedded database, you can use the utility for updating the database that Identity and Access Manager uses. You can use this utility to change the database that is used or to change the password for the database.

To update the Identity and Access Manager utility:
Launch the DatasourceUpdater executable in the Install Directory/IdentityAccessManager/bin folder.
Follow the prompts to enter the details for your IAM database.


** 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   ( sqljdbc4-4.0.jar) with our installer in DEVTESTGA\lib\shared folder

 
Additional Information:
https://docops.ca.com/devtest-solutions/10-4/en/installing/preinstallation/system-requirements#SystemRequirements-DatabaseRequirements
https://docops.ca.com/devtest-solutions/10-4/en/administering/database-administration/external-enterprise-dashboard-database-configuration