Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DTPDEVEL and version 2022.1

...

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

Note

If you are connecting to an Oracle database on Amazon RDS, you will need to create the database structure first. See Creating DTP database structure at Amazon RDS for Oracle. When the database structure has been created, proceed to Create a DTP schema for an existing database below.

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 Removed
  3. Select a database type: MySQL or Oracle.
  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.

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 Removed
  3. Select a database type: MySQL or Oracle.
  4. Enter the database URL and root credentials, then click Test Connection to confirm that it is correct.
  5. Click Next.
    Image Removed
  6. Enter new user and credentials and click Create Database.

    Info
    titleExisting 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.

...

Include+
spaceKeyDTP20221
scrollPageId0A010204017ED6B907EAAF0379C7B154

...

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 Removed
  3. Select a database type: MySQL or Oracle.
  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

excerpt-includeplus
spaceKeyDTP20221
scrollPageId0A010204017ED6BE2939F24D5C65312D
scrollEditorUrl/display/DTPDEVEL/.Switching+From+an+Embedded+to+an+External+Database+v2022.1
scrollEditorDisplayTitleSwitching From an Embedded to an External Database
scrollPageId0A01020401582470AEF692490352DDDD

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