DevTest DDL - What databases are the tables stored?

Products

• Service Virtualization

Issue/Introduction

 

DevTest DDL - What databases are the tables stored in?

Environment

 

All supported releases, platforms and databases of DevTest.

Cause

 

N/A

Resolution

 

<db_name>.ddl - DDL for tables added to the IAM and Registry databases

<db_name>_cai.ddl - DDL to Java Agent tables added to the Registry database

<db_name>_enterprisedashboard.ddl - DDL for tables added to the Enterprise Dashboard database

 

where <db_name> are the supported databases.

 

Location of DDL:

DEVTEST_HOME/IdentityAccessManager/database/ddl

DEVTEST_HOME/database/ddl

 

NOTE: DB2 not supported for IAM.

Additional Information

 

Supported databases are Oracle**, MySQL**, MS SQL Server, DB2 and PostgreSQL***

** Databases must be created with UTF-8 as to support Unicode

*** as of DevTest 10.6.0