The standard DTP distribution installation does not ship with the MySQL, PostgreSQL, and Oracle JDBC drivers necessary to set up a database connection. You will need to download the driver for your database software separately. 

MySQLFor MySQL databases (5.7.x - 8.0.x), it is recommended that you use the latest version (8.0.x) of MySQL Java Connector.
PostgreSQLFor PostgreSQL database, it is recommended that you use the latest version (42.x) of JDBC driver.
Oracle

For Oracle databases, you will need to download the JDBC driver version recommended for your version of Oracle that will work with DTP:

  • Oracle 18.3: ojdbc8.jar
  • Oracle 19.x: ojdbc8.jar
  • Oracle 23c: ojdbc11.jar

Refer to the Oracle documentation for information on choosing the correct driver: https://www.oracle.com/database/technologies/faq-jdbc.html

Oracle JDBC drivers can be downloaded from: https://www.oracle.com/pl/database/technologies/appdev/jdbc-downloads.html

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\DTP directory. On Linux, the data directory is set during installation. See Installation Directories for details. For more information about supported databases, see Database Requirements.

  • No labels