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 a “Java Runtime Environments” that has to be installed in the host where Virtual DataPort runs.

   Verify in the documentation of “ybtools”, if there are additional requirements.

3. If the environment variable JAVA_HOME does not exist, either create it or modify the script ybload to point to the correct Java Runtime Environment:

   • 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. In Design Studio, 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.