What External Databases are Supported with DevTest Solutions?

Document ID : KB000094813
Last Modified Date : 04/05/2018
Show Technical Document Details
Introduction:
DevTest Solutions can only be run with certified external databases as noted in our documentation.
Question:
What External Databases are Supported with DevTest Solutions?
Environment:
All supported DevTest releases, platforms and databases.
Answer:
The following external databases are the only ones supported with DevTest solutions:

IBM DB2 9.8, 10.1, and 10.5

The code page of the database must be 1208. In addition, the page size must be at least 8 KB for the DevTest registry and 16 KB for Enterprise Dashboard. Note that IBM DB2 9.8 is supported as a result of being integrated into IBM DB2 10.1.

MySQL 5.5, 5.6, and 5.7

The MySQL database must provide collation and characters set supporting UTF-8; double-byte characters are stored in the ACL and reporting tables. The default code page for the database must be UTF-8; it is not enough only to define your database as UTF-8.

Oracle 11g Release 2 and 12c

The character set must be Unicode set. For the initial creation of the database, the Oracle user must have the CREATE VIEW system privilege. Oracle must be installed with UTF-8 encoding. UTF-8 is the only encoding we have tested and is the only encoding we support.

Microsoft SQL Server 2008 R2, 2012, and 2014

The schema is 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.

If your security policy does not permit this approach, the database administrator can manually create the schema. The DDL files in the LISA_HOME\database directory contain SQL statements that can serve as the basis for manually creating the schema. Provide this information to the database administrator.

 
Additional Information:
To request support for a database not on this list, please submit an Idea on the DevTest Communities website at
https://communities.ca.com/community/ca-devtest-community