DevTest DDL - What databases are the tables stored?

book

Article ID: 15658

calendar_today

Updated On:

Products

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

Issue/Introduction

 

DevTest DDL - What databases are the tables stored in?

Cause

 

N/A

Environment

 

All supported releases, platforms and databases of DevTest.

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

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