Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

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.

...

MySQLFor MySQL databases (5.6.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 11.2 or 11gR2: ojdbc6.jar

  • 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

...