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.
The standard DTP distribution installation does not ship with the MySQL and Oracle JDBC drivers necessary to set up a database connection. You will need to download following drivers:
the driver for your database software separately.
For MySQL databases, you will need to download MySQL Java Connector version 5.1.32 or later.
The MySQL Connector/J 8.0 JDBC driver has a known defect that may impact MySQL servers hosted on CentOS and Red Hat Enterprise Linux systems. See https://bugs.mysql.com/bug.php?id=90813 for details.
For Oracle databases, you will need to download the JDBC driver version recommended for your version of Oracle that will work with DTP (JDK 8):
Refer to the Oracle documentation for information on choosing the correct driver: https://www.oracle.com/database/technologies/faq-jdbc.html
When the installation is complete, place the drivers in the <DTP_DATA_DIR>/lib/thirdparty directory. By default, the <DTP_DATA_DIR> directory for Windows is installed in the C:\ProgramData\Parasoft directory. On Linux, the data directory is set during installation. See Installation Directories for details.
You do not need to download and install the JDBC drivers if you are installing the DTP distribution that includes an embedded database server. The drivers are packaged with the database server so that you can begin using the database immediately.The MySQL Connector/J 8.0 JDBC driver has a known defect that may impact MySQL servers hosted on CentOS and Red Hat Enterprise Linux systems. See https://bugs.mysql.com/bug.php?id=90813 for details.
MySQL Charset and Collation Settings