...
- Click Configure Database Settings and select Create DTP database schema in the window that appears.
- Click Next.
- Select a database type: MySQL, Oracle, or PostgreSQL.
- Enter the database URL and user credentials, then click Test Connection to confirm that it is correct.
- Click Create Schema.
Integration with Azure Key Vault
| Info |
|---|
DTP does not ship with the JAR files necessary to fully integrate with Azure Key Vault. To integrate with Azure Key Vault, contact Parasoft support to obtain the JAR files necessary to enable the integration. Copy the files into the |
DTP Database settings are saved inside the <dtp-db-connection> element of the PSTRootConfig.xml file located in <DTP_DATA_DIR>/conf/. If your organization stores the DTP Database password in Azure Key Vault, you can configure DTP to retrieve the password by adding an <azure-key-vault> element. The example below is for MySQL but will work for all the supported databases.
| Code Block | ||
|---|---|---|
| ||
<dtp-db-connection>
<db-type>MySQL</db-type>
<user>dtp</user>
<url>jdbc:mysql://localhost:3306/DTP</url>
<azure-key-vault>
<url>https://dtp-dev.vault.azure.net/</url>
<secret>default-db-password</secret>
</azure-key-vault>
</dtp-db-connection> |
The value of the <url> element is the Azure Key Vault URI. The value of the <secret> element is the name of the secret in Azure Key Vault. Note that in the example above, there is no need for the <password> element inside <dtp-db-connection> element since DTP is configured to retrieve the database password from Azure Key Vault.
This functionality assumes that you have you have configured Access Control and Managed Identity so that DTP deployed in an Azure VM has access to the secret on Azure Key Vault.
Troubleshooting
A defect in the MySQL 8.x JDBC connector may cause the database creation process may fail
...