Requirements and Support

You should verify that all requirements have been met before you begin installing DTP, migrating from Concerto (4.x) to DTP, or upgrading to a new version of DTP.

In this section:

Operating System

64-bit versions are required for all platforms. DTP requires 64-bit Java Runtime Environment. 

Windows

The following versions are supported:

• Windows Server 2022
• Windows 10
• Windows 11

Microsoft .NET Framework 4.0 is required.

Linux

You can install DTP on Linux distributions that support 64-bit Java Runtime Environments.

Database Requirements

DTP supports MySQL, PostgreSQL, and Oracle databases. See Configuring the Database Connection for information setting up the database for use with DTP.

DTP does not ship with the MySQL, PostgreSQL, and Oracle JDBC drivers necessary to set up a database connection. Download the drivers and place them in the <DTP_DATA_DIR>/lib/thirdparty directory after completing the installation.

MySQL

The following versions are supported:

• MySQL 8.4
• MySQL 8.0
• MySQL 5.7 (deprecated)

If data continuously loads in an explorer view, increase the value of the read_rnd_buffer_size variable.

If binary logging is enabled in MySQL, you must use the "ROW" or "MIXED" binary log format. The "STATEMENT" format will not work.

To perform database updates after upgrading DTP, MySQL must have sufficient disk space to write temporary files, which may be an issue for larger databases. When modifying tables or adding an index during an update, MySQL writes to temporary storage (the directory specified by the MySQL tmpdir variable, which on Linux is the /tmp directory by default). This temporary storage may be on a different disk partition than where it stores its database tables. For more information on how to configure where MySQL stores temporary files, see: https://dev.mysql.com/doc/refman/8.0/en/temporary-files.html.

MySQL Character Set and Collation Settings

The MySQL creation script for the DTP database uses the character set utf8mb4 and collation utf8mb4_general_ci.

If you need to use different settings, you can create the database and database user yourself and then populate the database using DTP. See Create a DTP Schema for an Existing Database for more information about populating the database using DTP.

See the MySQL documentation for more information about server character set configuration and creating MySQL databases: 

• https://dev.mysql.com/doc/refman/8.4/en/charset.html
• https://dev.mysql.com/doc/refman/8.4/en/create-database.html

Oracle

The following versions are supported:

• 23c
• 19c
• 18c (deprecated)

Oracle Character Set and Collation Settings

Oracle recommends setting the target character set to AL32UTF8. See the Oracle Database Migration Assistant for Unicode documentation for instructions: https://docs.oracle.com/database/121/DUMAG/ch2migrasteps.htm#DUMAG136.

PostgreSQL

The following versions are supported:

• 16
• 15
• 14

Minimum Number of Database Connections

The database server should provide at least 150 concurrent connections for DTP. If the database server does not provide sufficient connections, DTP may not be able to create a new connection to the database prior to reaching the maximum number of connections.

DTP Enterprise Pack Database

DTP Enterprise Pack, which includes Extension Designer, ships with its own embedded MongoDB. If you are installing DTP Enterprise Pack, and intend to use the embedded MongoDB, we recommend using an XFS file system in Linux or an NTFS file system in Windows, as per the MongoDB documentation and described in the excerpt below. If you are planning to use an external MongoDB instead, refer to the requirements for whatever version you intend to use.

Hardware

For optimal performance, it is strongly recommended that DTP and the Database be installed on different servers. The minimum hardware requirements for each are shown in the tables below. In addition, be aware of the following:

• If you are installing DTP on a virtual machine (VM), make sure to allocate enough resources. Running DTP on a physical machine may result in greater performance.
• Using SSD will make the biggest difference for performance because DTP is an I/O write/read intensive application.
• DTP server cannot be installed on a machine with an underscore ("_") in its name.

DTP Server

Database Server

Ports

Before you begin installation, you should verify that the necessary ports are available:

You can customize the DTP Server ports as necessary. See Reconfiguring DTP Ports.

DTP Enterprise Pack Ports

The following ports must be available if you are installing DTP Enterprise Pack: 

IP Address Formats

IPv4 and IPv6 addresses are supported.

Browsers

The latest versions of the following browsers are supported:

• Microsoft Edge
• Firefox
• Google Chrome
• Safari

Other Requirements

Open File Descriptor Limit

Linux imposes a limit on the number of open file descriptors per process, which affects the number of allowable concurrent open connections that DTP can safely support. If many concurrent users will interact with DTP components, such as Report Center Dashboard or REST APIs, you should increase the open file descriptor limit before starting DTP.

Parasoft recommends setting the limit to approximately 100 times the number of concurrent users logged in. For example, if you expect 100 concurrent users, an open file descriptor limit of 10,000 should be sufficient.

Server behavior is inconsistent across operating systems, so you should use discretion when determining the proper limit for your environment. Methods for increasing the limit vary widely for different distributions. Consult your operating system documentation to determine whether it is possible to increase the limit and how to do so.

ZIP Extractor

The installation machine must have a program installed that can unzip compressed folders and files. 

Microsoft Visual C++ Redistributable

The Microsoft Visual C++ Redistributable package (2015 or higher) is required for the DTP Enterprise Pack database on Windows. The package is very common and may already be installed on your system. If the package is not already installed, the DTP installer will attempt to download the package.