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 12.1 or 12cR1: ojdbc7.jar
  • Oracle 12.2 or 12cR2: ojdbc8.jar
  • Oracle 18.3: ojdbc8.jar
  • Oracle 19.x: ojdbc8.jar

Refer to the Oracle documentation for information on choosing the correct driver: https://www.oracle.com/database/technologies/faq-jdbc.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 directory. On Linux, the data directory is set during installation. See Installation Directories for details.

  • No labels

Need assistance? Visit our support page