...

When the JDBC driver is installed, you can configure your database connections or create new databases. There are three options available:

Include Page_Connecting-Creating-DBs_Connecting-Creating-DBs

Anchor
ConnectToExistingDTPdatabase ConnectToExistingDTPdatabase

Connect to an existing DTP database

To connect to an existing DTP database using existing user credentials:

1. Click Configure Database Settings and select Connect to existing DTP database in the window that appears.
   
2. Click Next.
   Image Added
   
3. Select a database type: MySQL, Oracle, or PostgreSQL.

4. Enter the database URL and user credentials, then click Test Connection to confirm that it is correct.
   

5. Click Save & Connect to connect to the database.

Anchor
CreateNewDTPdatabase CreateNewDTPdatabase

Create a new DTP database, user, and schema

To create a new DTP database and schema as well as new user credentials:

1. Click Configure Database Settings and select Create new DTP database, user, and schema in the window that appears.
   
2. Click Next.
   Image Added
   
3. Select a database type: MySQL, Oracle, or PostgreSQL.
4. Enter the database URL and root credentials, then click Test Connection to confirm that it is correct.
5. Click Next.
   Image Added
   

6. Enter new user and credentials and click Create Database.
   

   Info
   title Existing Parasoft Users
   The processes will fail if the Parasoft default "dtp" user already exists. In this rare scenario, you can manually create the database and users, then go through the Create a DTP schema for an existing database described below. Alternatively, you can drop the "dtp" user before running this process.

Anchor
CreateSchema CreateSchema

Create a DTP schema for an existing database

To create a DTP schema for an existing database with existing user credentials:

1. Click Configure Database Settings and select Create DTP database schema in the window that appears.
   
2. Click Next.
   Image Added
   
3. Select a database type: MySQL, Oracle, or PostgreSQL.
4. Enter the database URL and user credentials, then click Test Connection to confirm that it is correct.
5. Click Create Schema.

Switching to an External Database

Starting with DTP 2022.2, DTP no longer ships with an embedded database. The feature described below is deprecated. For information about migrating an embedded database to an external database, see Migrating an Embedded Database to an External Database. Include Page_Switching-DB-embedded-to-external_Switching-DB-embedded-to-external

If you installed the DTP distribution with an embedded database, you can switch to an external database at your convenience. Be aware that once DTP has been configured to use an external database, it cannot be configured to use an embedded database again (though it can be configured to use a different external database). Make sure that your database meets the requirements described in Database Requirements.

1. Choose Report Center Settings from the main menu (gear icon).
2. Click Database Settings.
3. Click Configure Database Settings and follow the instructions for preparing and configuring the external database as described in Connecting to the Database.
   Image Added

Follow the instructions for preparing and configuring the external database as described in Connecting to the Database.