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:
64-bit versions are required for all platforms. DTP requires 64-bit Java Runtime Environment.
The following versions are supported:
Microsoft .NET Framework 4.0 is required.
You can install DTP on Linux distributions that support 64-bit Java Runtime Environments.
A dedicated, non-root user account is recommended for installing and managing DTP on Linux. |
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.
The following versions are supported:
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.
The MySQL creation script for the DTP database uses the character set utf8mb4 and collation utf8mb4_general_ci.
Older versions of DTP created databases using the |
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:
The following versions are supported:
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.
The following versions are supported:
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, 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.
|
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:
| Processor | 64-bit (x86_64) processor with at least eight cores. |
|---|---|
| Memory | At least 16 GB RAM; at least 24 GB is recommended if installing DTP Enterprise Pack. |
| Hard drive | At least 200 GB; SSD is recommended. |
| Processor | 64-bit (x86_64) processor with at least eight cores. |
|---|---|
| Memory | At least 16 GB RAM. |
| Hard drive | At least 500 GB; SSD is recommended. |
DTP might not start up properly on some Windows servers due to a port conflict on port 8005. See Reconfiguring DTP Ports for more information about changing port 8005. |
Before you begin installation, you should verify that the necessary ports are available:
| Default Port | Description |
|---|---|
| 80 (Windows), 8080 (Linux) | DTP Server |
| 8443 (Windows and Linux) | SSL Connector |
| 2002 | License Server port for Insure++ |
8005 | Apache Tomcat port |
| 8082 | Data Collector for Parasoft analysis engines and third-party integrations |
| 9003 | Used by the HyperSQL database server responsible for session management data |
| 3306 | Default port used for sending and retrieving MySQL data |
| 5432 | Default port used for sending and retrieving PostgreSQL data |
| 1521 | Default port used for sending and retrieving Oracle data |
| 61617 | JMS events broker |
| 1883 | MQTT transport connector |
You can customize the DTP Server ports as necessary. See Reconfiguring DTP Ports.
The following ports must be available if you are installing DTP Enterprise Pack:
| Default Port | Description |
|---|---|
| 8315 | Event broker in the parent process that orchestrates all of the other processes associated with Enterprise Pack. |
| 8314 | Extension Designer web interface |
| 8320-8399 | DTP Enterprise Pack services. |
| 8316 | Embedded MongoDB database for DTP Enterprise Pack. |
IPv4 and IPv6 addresses are supported.
The latest versions of the following browsers are supported:
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.
The installation machine must have a program installed that can unzip compressed folders and files.
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.