Yellowbrick

To use the API of Yellowbrick to perform bulk data loads, first follow these steps:

  1. Install the package “ybtools” (provided by Yellowbrick) on the host where the Virtual DataPort server runs. The documentation of Yellowbrick explains how to install ybtools.

  2. The package “ybtools” requires Java 8 64-bit. Make sure the host where Virtual DataPort runs has Java 8 installed. If it is not, download it from the Oracle website. This package supports either a Java Runtime Environment (JRE) or a Java Development Kit (JDK).

  3. If the environment variable JAVA_HOME does not exist or does not point to Java 1.8, modify the script ybload so this tool uses Java 8 as it requires:

    • On Windows, the path to this script usually is C:\Program Files\Yellowbrick Data\Client Tools\bin\ybload.bat.

    • On Linux, the path to this script usually is /opt/ybtools/bin/ybload.

  4. Edit the JDBC data source and click the tab Read & Write. Then, select Use bulk data load APIs and enter the path to the file ybload:

    • On Windows, enter C:\Program Files\Yellowbrick Data\Client Tools\bin\ybload.bat.

    • On Linux, enter /opt/ybtools/bin/ybload.